Back to jobs

Senior Data Integration Engineer

MN-Mankato; MN-Lakeville; IL-Bloomington; WI-Sun Prairie; WI-Prairie du Sac; Open to Any Compeer Location

Live, first seen by us 74 days ago
Pay
USD 94,400–142,900/year · BaseAnnual period assumed — pay source
Base Pay $94,400—$142,900 USD Compeer Financial is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.
Read the full posting
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Design, build, and maintain data integration pipelines in Microsoft Fabric and SSIS

  • Troubleshoot pipeline failures and data anomalies and resolve data quality issues

  • Build secure, performant SQL views and curated data products for reporting users

  • Help prepare and implement backup and disaster recovery procedures for critical databases

  • Provide on-call support for database-related problem resolution

From the employer’s posting
Designs, builds, deploys, and maintains data integration solutions using Microsoft Fabric
Monitors, troubleshoots, and analyzes pipeline failures, data anomalies, inconsistencies
designing and creating secure, performant consumption views and curated data products
preparing and implementing backup and disaster recovery procedures and processes for mission critical databases
Provides on-call support for problem resolution of database related issues.

Before you apply

Work authorization
Must already have the right to work in the USMust be authorized to work for any employer in the United States
Education & alternatives
The skills and experience we prefer you have: - Bachelor’s degree in computer science, engineering, MIS or related field or an equivalent combination of education and experience sufficient to perform the essential functions of the job. - Minimum of 5 years of experience with various MS SQL environments (2008, 2012, 2014, 2017), designing and implementing SSIS packages and ETL development using SQL Server Data Tools.
Apply at Compeer Financial

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 9, 202674 days ago
Recorded sightings
75
Last seen by us
Nov 20, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 74

Up longer than most. Similar jobs usually come down between day 6 and day 56.

From 14,767 similar postings that came down. Coming down is not always a hire.

Compeer Financial is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • T-SQL
  • Power BI
  • SQL Server
  • SSIS
  • SSRS
  • PySpark
Where the posting names them
ELT/ETL Development - Designs, builds, deploys, and maintains data integration solutions using Microsoft Fabric, including Data Factory pipelines, Dataflows Gen2, notebooks, Lakehouses, Warehouses, and SQL Server Integration Services (SSIS) where applicable. - Develops, maintains, and administers data platform databases, Lakehouses, Warehouses, and related data integration components.
- Creates automated, repeatable, and stable processes for data ingestion, transformation, validation, synchronization, and publishing across the data platform. - Develops database and data integration requirements for data migrations, business-unit initiatives, and SQL Server/Fabric projects using SQL, PySpark, notebooks, pipelines, and other appropriate technologies. - Identifies and resolves data integrity, quality, and reconciliation issues between source systems, Lakehouses, data warehouses, and downstream reporting or application consumers.
- Creates logical relationships across source systems, Lakehouses, Warehouses, and enterprise data models to provide consistent, trusted data for reporting and analytics. - Develops and maintains SQL views, semantic-model-ready datasets, and reusable data structures using SQL and Microsoft Fabric tools. - Partners with reporting, analytics, and business teams to define common calculations, data definitions, and access requirements.
- Bachelor’s degree in computer science, engineering, MIS or related field or an equivalent combination of education and experience sufficient to perform the essential functions of the job. - Minimum of 5 years of experience with various MS SQL environments (2008, 2012, 2014, 2017), designing and implementing SSIS packages and ETL development using SQL Server Data Tools. - SQL Server and/or other Microsoft technologies preferred.
- Minimum of 5 years of experience with various MS SQL environments (2008, 2012, 2014, 2017), designing and implementing SSIS packages and ETL development using SQL Server Data Tools. - SQL Server and/or other Microsoft technologies preferred. - Advanced knowledge of SQL, including T-SQL, data modeling, normalization, data types, query tuning, indexing, constraints, query plans, and relational database concepts.
- SQL Server and/or other Microsoft technologies preferred. - Advanced knowledge of SQL, including T-SQL, data modeling, normalization, data types, query tuning, indexing, constraints, query plans, and relational database concepts. - Experience with Microsoft Fabric, including Lakehouse, Warehouse, OneLake, Data Factory pipelines, Dataflows Gen2, notebooks, and related data engineering capabilities.
- Experience with Microsoft Fabric, including Lakehouse, Warehouse, OneLake, Data Factory pipelines, Dataflows Gen2, notebooks, and related data engineering capabilities. - Advanced experience with SSRS, Power BI, Microsoft Fabric reporting, or comparable reporting and analytics tools. - Experience designing data solutions for both operational (OLTP) and analytical/data warehouse environments.

Your next step

Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

Job description

View original posting ↗

Empowered to live. Inspired to work.
Compeer Financial is a member-owned cooperative located in Illinois, Minnesota and Wisconsin. We bring together team members with a variety of backgrounds and experiences to help provide financial services to support agriculture and rural communities. Join us in a culture that not only promotes meaningful work and professional development, but provides a flexible, hybrid work environment and excellent benefits, which empower you to thrive both personally and professionally.

How we support you:

  • Hybrid model – up to 50% work from home
  • Flexible schedules including ample flexibility in the summer months
  • Up to 9% towards 401k (3% fixed Compeer contribution plus up to 6% match)
  • Benefits: medical, dental, vision, HSA/FSA, life & AD&D insurance, short-term and long-term disability, wellness program & EAP
  • Vacation, sick leave, holidays/floating holidays, parental leave, and volunteer paid time off
  • Learning and development programs
  • Mentorship programs
  • Cross-functional committee opportunities (i.e. Inclusion Council, emerging professional groups, etc.)
  • Professional membership/certification reimbursement and more!

Casual/seasonal & intern team members are not eligible for benefits except for state-mandated programs.

To learn more about Compeer Financial visit www.compeer.com/careers. 

This position offers a hybrid work option up to 50% remote and is open to any Compeer office location in Illinois, Minnesota and Wisconsin.


The contributions you will make: 

This position is responsible for the development, enhancement and effective operations of complex data movement between various systems using ETL methodologies. Responsible for leading company database development efforts and coordinating with business users, consultants/contractors, vendors and internal team members to maximize the usage and value of company data assets. In many cases ETL processes are used to extract data from source systems, transform and enrich the data, and load it into the Data Warehouse.

A typical day: 

ELT/ETL Development

  • Designs, builds, deploys, and maintains data integration solutions using Microsoft Fabric, including Data Factory pipelines, Dataflows Gen2, notebooks, Lakehouses, Warehouses, and SQL Server Integration Services (SSIS) where applicable.
  • Develops, maintains, and administers data platform databases, Lakehouses, Warehouses, and related data integration components.
  • Functions as a primary contributor in designing, coding, testing, and debugging ETL/ELT pipelines and processes to create reliable, seamless data flows across source systems and the enterprise data platform.
  • Supports the overall strategy for Microsoft Fabric, data warehouse, Lakehouse, and database development, including adoption of scalable and reusable data integration patterns.
  • Monitors, troubleshoots, and analyzes pipeline failures, data anomalies, inconsistencies, and other data integration issues identified through monitoring, technical team members, and end users.
  • Creates automated, repeatable, and stable processes for data ingestion, transformation, validation, synchronization, and publishing across the data platform.
  • Develops database and data integration requirements for data migrations, business-unit initiatives, and SQL Server/Fabric projects using SQL, PySpark, notebooks, pipelines, and other appropriate technologies.
  • Identifies and resolves data integrity, quality, and reconciliation issues between source systems, Lakehouses, data warehouses, and downstream reporting or application consumers.
  • Applies data engineering best practices for security, performance, documentation, source control, testing, and deployment across Microsoft Fabric environments.

Consumption Views

  • Supports reporting, analytics, and application users by designing and creating secure, performant consumption views and curated data products in Microsoft Fabric Lakehouses and Warehouses.
  • Creates logical relationships across source systems, Lakehouses, Warehouses, and enterprise data models to provide consistent, trusted data for reporting and analytics.
  • Develops and maintains SQL views, semantic-model-ready datasets, and reusable data structures using SQL and Microsoft Fabric tools.
  • Partners with reporting, analytics, and business teams to define common calculations, data definitions, and access requirements.

Database Administration

  • Supports overall strategy related to database and data warehouse development.
  • Actively participates with the Business Technology department in preparing and implementing backup and disaster recovery procedures and processes for mission critical databases.
  • Contributes to data dictionaries and database diagrams for complex in-house databases.
  • Provides on-call support for problem resolution of database related issues.

The skills and experience we prefer you have: 

  • Bachelor’s degree in computer science, engineering, MIS or related field or an equivalent combination of education and experience sufficient to perform the essential functions of the job.
  • Minimum of 5 years of experience with various MS SQL environments (2008, 2012, 2014, 2017), designing and implementing SSIS packages and ETL development using SQL Server Data Tools.
  • SQL Server and/or other Microsoft technologies preferred.
  • Advanced knowledge of SQL, including T-SQL, data modeling, normalization, data types, query tuning, indexing, constraints, query plans, and relational database concepts.
  • Experience with Microsoft Fabric, including Lakehouse, Warehouse, OneLake, Data Factory pipelines, Dataflows Gen2, notebooks, and related data engineering capabilities.
  • Advanced experience with SSRS, Power BI, Microsoft Fabric reporting, or comparable reporting and analytics tools.
  • Experience designing data solutions for both operational (OLTP) and analytical/data warehouse environments.
  • Experience with software deployment, source control, CI/CD pipelines, build automation, and promoting solutions across development, test, and production environments.
  • Ability to translate complex technical concepts and data issues into clear, non-technical language.
  • Advanced client-service skills and a strong customer-focused mindset.
  • Strong listening, written, and verbal communication skills, with the ability to communicate effectively at all levels of the organization.
  • Ability to work independently and collaboratively across teams to achieve shared goals and represent business needs.
  • Valid driver’s license.

#IND123

How we will take care of you:

Our job titles may span more than one career level (associate, senior, principal, etc.). The actual title and base pay offered is dependent upon many factors, such as: training, transferable skills, work experience, business needs and market demands. The base pay range is subject to change and may be modified in the future. This role is eligible for variable compensation and other benefits.

Base Pay
$94,400—$142,900 USD

Compeer Financial is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Must be authorized to work for any employer in the United States. Compeer is unable to sponsor or take over sponsorship of an employment visa at this time.

Click here to view federal employment laws applicable for applicants.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Base Pay $94,400—$142,900 USD Compeer Financial is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.
Location & working pattern

MN-Mankato; MN-Lakeville; IL-Bloomington; WI-Sun Prairie; WI-Prairie du Sac; Open to Any Compeer Location

Empowered to live. Inspired to work. Compeer Financial is a member-owned cooperative located in Illinois, Minnesota and Wisconsin. We bring together team members with a variety of backgrounds and experiences to help provide financial services to support agriculture and rural communities. Join us in a culture that not only promotes meaningful work and professional development, but provides a flexible, hybrid work environment and excellent benefits, which empower you to thrive both personally and professionally. How we support you: - Hybrid model – up to 50% work from home - Flexible schedules including ample flexibility in the summer months
More source context
- Professional membership/certification reimbursement and more! Casual/seasonal & intern team members are not eligible for benefits except for state-mandated programs. To learn more about Compeer Financial visit www.compeer.com/careers. This position offers a hybrid work option up to 50% remote and is open to any Compeer office location in Illinois, Minnesota and Wisconsin. The contributions you will make:
Work authorization
Compeer Financial is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. Must be authorized to work for any employer in the United States. Compeer is unable to sponsor or take over sponsorship of an employment visa at this time. Click here to view federal employment laws applicable for applicants.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.