Logo
Wisconsin Psychiatric Association Inc

Data Engineer

Wisconsin Psychiatric Association Inc, Ripon, Wisconsin, United States, 54971

Save Job

Alliance Laundry System LLC Data Engineer

US-WI-Ripon

Job ID: 2025-10914

Type: Full-Time

# of Openings: 1

Category: Information Technology

Overview Our Enterprise Analytics Center of Excellence (CoE) is building the next-generation analytics stack centered on Snowflake (AWS) and Sigma. We're looking for a Data Engineer to help design, build, and operate this modern data architecture. This role focuses on developing efficient, governed data pipelines and enabling analytics teams across the business to access reliable, high-quality data.

Responsibilities Ingestion & Transformation

Build and maintain scalable data pipelines using Snowflake OpenFlow and related Snowflake-native tools.

Assist in migrating existing Dataiku pipelines into Snowflake to simplify architecture and improve efficiency.

Continuously improve workflows for performance, reliability, and maintainability.

Semantic Modeling & Views

Develop and maintain Snowflake semantic views that support analytics and reporting needs.

Apply data modeling best practices to ensure consistency across business domains.

Support creation of governed, role-based semantic layers for Finance, Operations, and other enterprise areas.

Governance & Security

Implement data access controls aligned with enterprise RBAC frameworks.

Support metadata management and cataloging for visibility in Sigma.

Ensure pipelines and models meet enterprise data governance standards.

Analytics Enablement

Deliver clean, governed data sets for Sigma dashboards and embedded analytics use cases.

Monitor and optimize query performance to balance cost and speed.

Partner with analysts and BI developers to ensure data is reliable and ready for consumption.

Continuous Improvement

Stay current with Snowflake and Sigma feature updates.

Recommend improvements to data engineering processes and automation where possible.

Contribute to a culture of learning and collaboration within the CoE.

Qualifications Education & Experience

Bachelor's or Master's degree in Computer Science, Data Engineering, or related field.

At least 5 years of experience as a Data Engineer or in a similar role.

Required Skills & Experience

Snowflake expertise:

SQL, OpenFlow, Tasks/Streams, and performance optimization.

Cloud experience:

Hands-on with AWS (S3, IAM, Glue, Lambda, etc.).

Data modeling:

Familiar with dimensional modeling and semantic layer design.

ETL/ELT engineering:

Experience building and optimizing data pipelines.

Governance & Security:

Understanding of AD/LDAP integration, RBAC, and data cataloging.

Programming:

Proficient in SQL and Python.

Strong problem-solving skills and a desire to learn emerging data technologies.

Preferred Skills

Experience supporting Power BI to Sigma migrations or similar modern BI transitions.

Familiarity with Sigma features such as Ask Sigma, Write-Back, or Embedded Analytics.

Exposure to Dataiku or similar ETL platforms.

Interest in modern data practices such as AI-assisted analytics or NLP-based BI tools.

Travel Approximately 10%

Standard and Physical Requirements Position involves sitting for long periods, standing, manual dexterity, stooping, bending, and minimal lifting.

Alliance Team Members Demonstrate DRIVE:

Dedicated:

Follows through on commitments.

Respectful:

Acts with integrity and values diverse perspectives.

Innovative:

Always looking for a better way; leads change.

Versatile:

Adapts quickly to changing circumstances. Demonstrates agility.

Engaged:

Acts like an owner. Wants to create and grow a business which is tightly aligned with market needs.

#J-18808-Ljbffr