Senior Data Integration Engineer — Hybrid ETL Expert

Compeer Financial; Town of Sun Prairie (WI); Hybrid; USD 94,000 - 143,000; Full time

Benefits offered by this job

Hybrid model

Flexible schedules

401k match up to 9%

Health, dental, vision insurance

Paid time off

Job summary

Compeer Financial is seeking a data integration specialist focused on ELT/ETL development within a Microsoft Fabric environment. You will design, implement, and optimize data pipelines, SQL Server databases, and data warehouses to support enterprise reporting and analytics.

The role requires strong SQL and ETL skills, experience with SSIS and Power BI, and the ability to translate complex data requirements into scalable solutions.

Qualifications

• Bachelor’s degree or equivalent combination of education and experience.
• Minimum of 5 years of experience with MS SQL environments (2008, 2012, 2014, 2017).
• Experience with SSIS, ETL development, and data pipelines.

Responsibilities

• Design, build, deploy, and maintain data integration solutions using Microsoft Fabric and SSIS.
• Develop and administer data platform databases, Lakehouses, and Warehouses.
• Create reliable ETL/ELT pipelines and ensure data quality and consistency.

Skills

ETL development

SQL Server

Microsoft Fabric

Data warehousing

Data integration

Python / PySpark

Education

Bachelor’s degree in computer science or related field

Tools

SSIS

Power BI

Data Factory

Notebooks

Job description

Compeer Financial is seeking a data integration specialist focused on ELT/ETL development within a Microsoft Fabric environment. You will design, implement, and optimize data pipelines, SQL Server databases, and data warehouses to support enterprise reporting and analytics.

The role requires strong SQL and ETL skills, experience with SSIS and Power BI, and the ability to translate complex data requirements into scalable solutions.