Data Engineer (On-Premise)

Ziegler Caterpillar•Minneapolis, MN

13d•$95,100 - $118,800•Onsite

About The Position

Ziegler CAT is hiring a Data Engineer to design, develop, maintain, and optimize its enterprise data platform and integration architecture. The role administers and enhances the Microsoft Fabric Data Warehouse, data pipelines, ETL/ELT processes, and enterprise integrations. The position is performed on-premise at Ziegler’s Bloomington office. The Data Engineer works with business stakeholders and teams across Business Intelligence, Power BI, and application development to deliver reliable data solutions. The role also provides technical leadership, mentoring, and coaching to team members and new hires. Ziegler describes itself as a third-generation, family-owned CAT dealer with more than 2,400 employees across over 30 locations in Minnesota, Iowa, and northern Missouri.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field; or equivalent experience.
At least 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 with data pipelines, orchestration tools, and data transformation frameworks.
Strong troubleshooting, problem-solving, and analytical skills.
Excellent communication skills and ability to work effectively across departments and organizational levels.
Ability to manage multiple priorities and projects as a self-starter.
Strong attention to detail and commitment to data quality.
Ability to use hands, talk, and hear.

Responsibilities

Design, develop, maintain, and optimize enterprise data warehouses and data platforms using Microsoft Fabric.
Develop, manage, and monitor ETL/ELT pipelines for operational reporting, analytics, business intelligence, and data integration.
Design and implement scalable data architectures for current and future business needs.
Build and maintain integrations among ERP systems, CRM systems, cloud applications, third-party vendors, and internal business applications.
Work 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, and identify improvement opportunities.
Develop and maintain data models, dimensional structures, and reporting datasets for 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.

Benefits

Health insurance
Dental insurance
Vision insurance
Life insurance
15 days of PTO in the first year, with accrual starting on day one
9 paid holidays
401(k) plan with company contribution and match
Health Savings Account (HSA), with Ziegler contributing up to $1,000 tax-free each year
Short-term and long-term disability insurance
Flexible Spending Account (FSA)
Employee Assistance Program (EAP)
Paid parental leave
Funeral leave
Fitness membership discount
Education assistance
Work/life balance
Ongoing professional development and training