Data Engineer (On-Premise)

Ziegler Inc.; BLOOMINGTON (MN); On-site; USD 95,000 - 119,000; Full time

Benefits offered by this job

Health, Dental, Vision and Life Insur.

15 days PTO first year

9 paid holidays

401(k) plan with company contribution

HSA contributions up to $1000/year

Disability Insurance, FSA & EAP

Paid Parental Leave & Funeral Leave

Fitness membership discount

Education Assistance

Job summary

Ziegler CAT in Bloomington, MN is seeking a Data Engineer to design, develop, and optimize the enterprise data platform, including Microsoft Fabric-based data warehouse and ETL/ELT pipelines, with on-premises work at the Bloomington office.

The role focuses on building scalable data architectures, ensuring data quality, and guiding integrations across ERP/CRM systems, BI tools, and cloud interfaces, while collaborating with stakeholders and mentoring teammates.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or related field; or equivalent experience.
• 3+ years of experience in data engineering, data warehousing, ETL/ELT development, or related fields.
• Experience designing and supporting enterprise data warehouse solutions.
• Experience with Microsoft Fabric, Azure Data Services, or comparable cloud-based data platforms.
• Strong proficiency with SQL and relational database design.
• Experience developing and maintaining data integration solutions and enterprise interfaces.
• Strong understanding of dimensional modeling, star schemas, and data warehouse architecture.
• Experience working with data pipelines, orchestration tools, and data transformation frameworks.
• Strong troubleshooting, problem-solving, and analytical skills.
• Excellent communication skills with the ability to work effectively across multiple departments and organizational levels.
• Self-starter with the ability to manage multiple priorities and projects.
• Strong attention to detail and commitment to data quality.

Responsibilities

• Design, develop, maintain, and optimize enterprise data warehouses and data platforms utilizing Microsoft Fabric.
• Develop, manage, and monitor ETL/ELT pipelines that support operational reporting, analytics, business intelligence, and data integration initiatives.
• Design and implement scalable data architectures that support current and future business needs.
• Build and maintain integrations between ERP systems, CRM systems, cloud applications, third-party vendors, and internal business applications.
• Collaborate with business stakeholders to understand data requirements and translate them into technical solutions.
• Ensure data integrity, quality, consistency, and accuracy across enterprise systems.
• Implement and maintain data governance, security, and compliance standards.
• Monitor and troubleshoot data pipelines, integrations, and warehouse performance while proactively identifying improvement opportunities.
• Develop and maintain data models, dimensional structures, and reporting datasets that support business intelligence initiatives.
• Partner with Business Intelligence, Power BI, and application development teams to deliver reliable and performant data solutions.
• Establish and enforce data engineering standards, development processes, and documentation practices.
• Evaluate emerging technologies and recommend improvements to Ziegler's data platform and architecture.
• Provide technical leadership, mentoring, and coaching to team members and new hires.

Skills

SQL

Analytical skills

Communication skills

Self-starter

Education

Bachelor's degree in Computer Science / Information Systems / Data Engineering or related field

Tools

Microsoft Fabric

Azure Data Services

Job description

Ziegler CAT has an opening for a Data Engineer to design, develop, maintain, and optimize Ziegler's enterprise data platform and integration architecture. This position will be responsible for the ongoing administration and enhancement of the organization's Microsoft Fabric Data Warehouse, data pipelines, ETL/ELT processes, and enterprise integrations. This position will work on-premise at our Bloomington office.

Responsibilities

• Design, develop, maintain, and optimize enterprise data warehouses and data platforms utilizing Microsoft Fabric.
• Develop, manage, and monitor ETL/ELT pipelines that support operational reporting, analytics, business intelligence, and data integration initiatives.
• Design and implement scalable data architectures that support current and future business needs.
• Build and maintain integrations between ERP systems, CRM systems, cloud applications, third-party vendors, and internal business applications.
• Collaborate with business stakeholders to understand data requirements and translate them into technical solutions.
• Ensure data integrity, quality, consistency, and accuracy across enterprise systems.
• Implement and maintain data governance, security, and compliance standards.
• Monitor and troubleshoot data pipelines, integrations, and warehouse performance while proactively identifying improvement opportunities.
• Develop and maintain data models, dimensional structures, and reporting datasets that support business intelligence initiatives.
• Partner with Business Intelligence, Power BI, and application development teams to deliver reliable and performant data solutions.
• Establish and enforce data engineering standards, development processes, and documentation practices.
• Evaluate emerging technologies and recommend improvements to Ziegler's data platform and architecture.
• Provide technical leadership, mentoring, and coaching to team members and new hires.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or related field; or equivalent experience.
• 3+ years of experience in data engineering, data warehousing, ETL/ELT development, or related fields.
• Experience designing and supporting enterprise data warehouse solutions.
• Experience with Microsoft Fabric, Azure Data Services, or comparable cloud-based data platforms.
• Strong proficiency with SQL and relational database design.
• Experience developing and maintaining data integration solutions and enterprise interfaces.
• Strong understanding of dimensional modeling, star schemas, and data warehouse architecture.
• Experience working with data pipelines, orchestration tools, and data transformation frameworks.
• Strong troubleshooting, problem-solving, and analytical skills.
• Excellent communication skills with the ability to work effectively across multiple departments and organizational levels.
• Self-starter with the ability to manage multiple priorities and projects.
• Strong attention to detail and commitment to data quality.

Minimum Physical Requirements:

• Using hands, talking, hearing

This job description is intended to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position. Ziegler Inc. will reasonably accommodate the known disabilities of qualified disabled individuals.

SEE YOURSELF AT ZIEGLER

Founded in 1914, Ziegler is a third-generation, family-owned CAT dealer with over 2400 employees across 30+ locations in Minnesota, Iowa and northern Missouri. Since day one Ziegler has had the same philosophy- if the customer is successful- then Ziegler will be successful. That is why Ziegler is committed to providing employees with the best possible work environment and the right tools for career development. This means great benefits, work/life balance, and ongoing professional development and training. Fulfill your calling by starting a career with Ziegler today!

The pay range for this position is

$95,100.00 to $118,800.00

Starting wage is dependent on skills, experience, education and location. Pay range may vary by 10% depending upon the applicant's location. Along with competitive pay, full time positions are benefits eligible which includes:

• Health, Dental, Vision and Life Insurance
• 15 days of PTO your first year, accrual starts day 1
• 9 paid holidays
• 401(k) plan with company contribution and match
• HSA (Health Savings Account), Ziegler contributes up to $1000 tax-free each year
• Short-Term and Long-Term Disability Insurance, FSA & EAP
• Paid Parental Leave & Funeral Leave
• Fitness membership discount
• Education Assistance

At Ziegler Inc. we're committed to equal opportunity. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.