Data Engineer

Ziegler Caterpillar; Bloomington (IN); On-site; USD 95,000 - 119,000; Full time

Benefits offered by this job

Health Insurance

PTO 15 days

9 paid holidays

401(k) with company match

HSA contributions

Disability Insurance

Parental Leave

Fitness membership

Job summary

Ziegler Caterpillar in Bloomington, IN, is seeking a Data Engineer to design, develop, maintain, and optimize Ziegler's enterprise data platform and integration architecture. This on-prem role will manage the Microsoft Fabric Data Warehouse, ETL/ELT processes, and enterprise integrations.

You will design scalable data architectures, build cross-system integrations, and ensure data quality and governance while mentoring teammates.

Qualifications

• Bachelor's degree in a related field or equivalent experience.
• 3+ years in data engineering, data warehousing, ETL/ELT development, or related.
• Experience designing and supporting enterprise data warehouse solutions.
• Strong SQL and relational database design skills.
• Experience with data integration and enterprise interfaces.
• Knowledge of dimensional modeling and star schemas.
• Experience with data pipelines and orchestration.
• Strong problem-solving and communication abilities.

Responsibilities

• Design, develop, maintain, and optimize enterprise data warehouses and platforms using Microsoft Fabric.
• Develop, manage, and monitor ETL/ELT pipelines for reporting, analytics, BI, and integrations.
• Design scalable data architectures to meet current and future needs.
• Build and maintain integrations between ERP/CRM/cloud vendors and internal applications.
• Collaborate with stakeholders to translate data requirements into technical solutions.
• Ensure data integrity, quality, and compliance across systems.
• Govern and secure data per governance standards.
• Monitor and improve data pipelines and warehouse performance.
• Develop data models, dimensional structures, and reporting datasets for BI.

Skills

SQL proficiency

Relational DB design

Data warehousing

ETL/ELT development

Microsoft Fabric

Azure Data Services

Data pipelines

Dimensional modeling

Star schemas

Troubleshooting

Effective communication

Self-starter

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software 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.