Data Engineer (On-Premise)

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

Benefits offered by this job

Health, Dental, Vision and Life Ins.

PTO 15 days first year

9 paid holidays

401(k) with company match

HSA contribution

Disability Insurance

Paid Parental Leave

Fitness membership discount

Education Assistance

Job summary

Ziegler Caterpillar is seeking a Data Engineer to design, develop, maintain, and optimize Ziegler's enterprise data platform, including Microsoft Fabric Data Warehouse, ETL/ELT pipelines, and enterprise integrations. This position is on-premise at the Bloomington office.

You will design scalable data architectures, ensure data quality and governance, and collaborate with BI, ERP, and application teams to deliver reliable data solutions.

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 and optimize enterprise data warehouses and platforms using Microsoft Fabric.
• Develop, manage, and monitor ETL/ELT pipelines for reporting and analytics.
• Create scalable data architectures to meet business needs.
• Build integrations between ERP/CRM, cloud apps, and internal systems.
• Collaborate with stakeholders to translate data requirements into technical solutions.
• Ensure data integrity, quality, and consistency across systems.
• Implement data governance, security, and compliance standards.
• Monitor pipelines and warehouse performance; identify improvements.
• Develop data models and reporting datasets for BI initiatives.
• Partner with BI and application teams to deliver reliable data solutions.
• Establish data engineering standards and documentation practices.
• Evaluate emerging technologies to enhance the data platform.

Skills

SQL

Relational DB design

Data pipelines

ETL/ELT development

Microsoft Fabric

Azure Data Services

Data warehousing

Data governance

Problem solving

Communication

Education

Bachelor's degree in Computer Science/IS/Data Engineering/Software Eng

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.