Back to jobs
New

Sr Data Integration Engineer

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
  • 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.

#IND100

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.

Create a Job Alert

Interested in building your career at Compeer Financial? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...
Select...

i.e. 2600 Jenny Wren Trail

i.e. PO Box, Unit Number, Apartment Number

i.e. Sun Prairie

Select...

i.e. WI

i.e. 53590

Please read: this field is intended for COUNTY not COUNTRY.

Select...

A current team member would include full-time, part-time, temporary or interns who presently work at Compeer Financial.

Select...

A previous team member would include full-time, part-time, temporary or interns who have worked at Compeer Financial in the past, but are not presently employed with Compeer Financial.

Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Compeer Financial’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 07/31/2029

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.