Data Engineer (On-Premise)

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

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

Life Insurance

PTO 15 days first year

9 paid holidays

401(k) with company match

HSA contribution

Disability Insurance

Parental Leave & Funeral Leave

Fitness membership discount

Education Assistance

Job summary

Ziegler CAT is seeking a Data Engineer to design, develop, and optimize its enterprise data platform and integration architecture. This role focuses on Microsoft Fabric Data Warehouse, ETL/ELT pipelines, and enterprise integrations in an on-premise Bloomington setting.

You will partner with stakeholders to translate data requirements into technical solutions, ensure data quality and governance, and contribute to data models and BI-ready datasets for Power BI and applications.

Qualifications

• Bachelor's degree or equivalent experience in a related field.
• 3+ years of experience in data engineering, data warehousing, or ETL/ELT development.
• Experience designing and supporting enterprise data warehouse solutions.

Responsibilities

• Design, develop, maintain, and optimize enterprise data warehouses and data platforms using Microsoft Fabric.
• Develop, manage, and monitor ETL/ELT pipelines for reporting, analytics, BI, and data integration.
• Design scalable data architectures to support current and future needs.

Skills

SQL proficiency

Data integration

Dimensional modeling

ETL/ELT development

Data pipelines

Troubleshooting

Communication

Self-starter

Data quality

Education

Bachelor's degree in CS/IS/Data Eng/Software or related field; or equivalent experience

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.