Data Engineer (On-Premise)
Ziegler Cat
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Benefits offered by this job
Job summary
Ziegler CAT is seeking a Data Engineer to design, develop, maintain, and optimize its enterprise data platform and integration architecture. This on-prem role at the Bloomington office focuses on Microsoft Fabric Data Warehouse, ETL/ELT pipelines, and enterprise integrations to enable robust BI solutions.
You will collaborate with stakeholders to ensure data quality and security, mentor teammates, and help evolve the data landscape with scalable architectures and governance.
Qualifications
- Bachelor's degree in CS/IS/Data Engineering or equivalent experience.
- 3+ years of data engineering or data warehousing experience.
- 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 across departments.
Responsibilities
- Design, develop, maintain, and optimize enterprise data warehouses and data platforms utilizing Microsoft Fabric.
- Develop, manage, and monitor ETL/ELT pipelines supporting reporting, analytics, BI, and data integrations.
- Design and implement scalable data architectures to meet business needs.
- Build and maintain integrations between ERP/CRM systems, cloud apps, third-party vendors, and internal apps.
- Collaborate with stakeholders to translate data requirements into technical solutions.
- Ensure data integrity, quality, consistency, and accuracy across systems.
- Implement and maintain data governance, security, and compliance standards.
- Monitor and troubleshoot data pipelines and warehouse performance; identify improvements.
- Develop and maintain data models, dimensional structures, and reporting datasets for BI.
- Partner with BI and Power BI teams to deliver reliable data solutions.
- Establish and enforce data engineering standards and documentation.
- Evaluate emerging technologies and propose platform improvements.
- Provide technical leadership and mentoring to team members.
Skills
Education
Tools
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.
- 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.
- 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.
Using hands, talking, hearing
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.
Ziegler sells and services CAT® construction and mining equipment, generators and industrial engines in Minnesota and Iowa, as well as AGCO agricultural equipment across Minnesota, Iowa and Missouri. Ziegler has a team focus, a first-class reputation for service, and a healthy work‑life balance. We train our employees to do things the Ziegler Way — the right way —and then we take it one step forward. If you’re a talented, hard‑work‑and‑down‑to‑e‑arth person, you’ll fit in perfectly here.
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.
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.
- 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
- Competitive pay
- Health, dental/orthodontia, vision & life insurances
- Paid time off (PTO) – 15 days to start 9
- Paid holidays
- 401(k) contributions & match HSA, Ziegler contributes up to $1000 tax‑free annually
- STD & LTD Insurance, FSA & EAP
- Paid Parental Leave & Funeral Leave
- Fitness membership discount
- Ongoing training
- Education assistance
- Advancement opportunities
- Safe, clean, and friendly work environment
- Military Friendly
- We actively hire those with prior military experience and accommodate the needs of Reserve and National Guard members.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
