Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Sr Data Integration Engineer

$94.4k - $142.9k

Compeer Financial

Job Description

Job Description

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  

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.

Vacancy posted 14 days ago
Similar jobs that could be interesting for youBased on the Sr Data Integration Engineer in Bloomington, IL vacancy
  • $132k - $181.5k

     ...roleDesigns, develops, and delivers enterprise data solutions that enable trusted, scalable,...  ..., logical, and physical data models, integration designs, data flows, interface...  ...with Product Management, Architecture, Engineering, Security, and business stakeholders to... 
    Suggested
    Full time
    Temporary work

    Country Financial

    Bloomington, IL
    3 days ago
  •  ..., train, and deploy machine learning models Build mathematical optimization algorithms Collaborate with data engineers to clean, transform, and integrate massive streams of data and market signals. Establish automated CI/CD pipelines Partner with logistics coordinators... 
    Suggested
    Hourly pay
    Full time
    Contract work
    Internship
    Summer internship
    Local area
    Visa sponsorship
    Shift work

    Rivian

    Normal, IL
    3 days ago
  • $113.2k - $155.65k

     ...difference for our clients.About the roleSenior Integration Developer (MuleSoft / Azure API...  ...specifications.• Perform interface analysis, data mapping, payload validation,...  ...outcomes, and exercise strong integration engineering judgment.#LI-CORP#LI-HybridBase Pay Range... 
    Senior
    Full time
    Temporary work

    Country Financial

    Bloomington, IL
    3 days ago
  • Job Title: Lead Databricks Migration Position Overview Play a critical role in a large-scale data warehouse modernization initiative migrating legacy DB2 and Amazon Redshift environments, supported by Informatica and Unix shell scripting, onto Databricks. This position... 
    Senior

    HTC Global Services

    Bloomington, IL
    2 days ago
  • $90k - $130k

    Data Engineer Being good neighbors - helping people, investing in our communities, and making the world a better place - is who we are...  ...Include: Design, build, and maintain scalable data pipelines, integrations, and data solutions. Develop reusable data products that... 
    Suggested
    H1b
    Work at office
    Immediate start

    State Farm

    Bloomington, IL
    2 days ago
  • $132k - $181.5k

     ...who do the work. Apply today to help our organization grow and make a difference for our clients.About the roleCOUNTRY is seeking a Data Scientist focused on leveraging advanced analytics, machine learning, and artificial intelligence to drive meaningful business outcomes... 
    Full time
    Temporary work
    Flexible hours

    Country Financial

    Bloomington, IL
    17 hours ago
  • $131k - $174k

     ...for supporting and maintaining critical applications and related data processing platforms and services. Ensure the team has the...  ...provisioning compliantly Job Description Roles and Responsibilities: Engineering Operations Serve as the senior technical operations authority... 
    Senior
    Permanent employment
    Contract work
    Remote work
    Visa sponsorship
    Work visa
    Relocation package

    GE Aerospace

    Bloomington, IL
    2 days ago
  • Company DescriptionSonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled...
    Senior
    Full time
    H1b

    Sonsoft

    Bloomington, IL
    4 days ago
  • $94.4k - $129.8k

    Experience more with a career at COUNTRY Financial!We’re excited you’re interested in a career at COUNTRY as we strive toward our vision - to enrich lives in the communities we serve. Our footprint spans coast to coast. But more important than where we operate, is the people...
    Senior
    Full time
    Temporary work

    Country Financial

    Bloomington, IL
    1 day ago
  • $94.4k - $142.9k

    Senior Network Engineer Empowered to live. Inspired to work. Compeer Financial is a member...  ...issues, and advances campus, branch, data center, cloud, WAN, wireless, voice, unified...  ..., automation, configuration management, integration, version-control, testing, observability... 
    Senior
    Temporary work
    Work experience placement
    Summer work
    Casual work
    Internship
    Seasonal work
    Work at office
    Remote work
    Work from home
    Work visa
    Flexible hours

    Compeer Financial

    Bloomington, IL
    2 days ago
  • $113.2k - $155.65k

     ...About the roleCOUNTRY Financial is seeking a Sr. Quality Practice Lead in the IT Quality...  ...across Technology. This Quality Engineering-level role provides enterprise quality assurance...  ...performance testing, observability, test data management, and test environment... 
    Senior
    Full time
    Temporary work

    Country Financial

    Bloomington, IL
    1 day ago
  • Field Service Engineer As a leader in autonomous vehicle solutions for industry and aviation...  ...design, automation, and operational integration, TLD Robotics delivers autonomous solutions...  ...security policies, safeguard company data and systems, and promptly report any suspected... 
    Remote work

    TLD AMERICA

    Bloomington, IL
    3 days ago
  •  ...bill rate remains unchanged. Job Title: Staff AI/ML Engineer & Data Scientist Schedule: 9-6 Central Time (1 hour non-...  ...engineering and hyper parameter tuning. Programming & Integration Build scalable ML pipelines and APIs in Python (primary) and... 
    Senior
    Remote work
    Shift work

    Artech LLC

    Normal, IL
    25 days ago
  • $41.52 - $71.41 per hour

     ...responsibility for the successful planning, execution, monitoring, control and closure of a project. Through contacts with users, architects, engineers, and code officials, the employee will be involved with all phases of design and construction management including user... 
    Senior
    Full time
    For contractors
    Work experience placement
    Interim role
    Local area
    Shift work

    Carle Health

    Normal, IL
    4 days ago
  • $105k - $125k

     ...Position: Sr. Structural Engineer Location: Normal, IL Job Id: 3685 of Openings: 1 Farnsworth Group is seeking a Sr. Structural Engineer in one of the below posting locations. In this role, you will provide customer-oriented design and construction services to... 
    Senior
    Temporary work
    Immediate start
    Flexible hours

    Farnsworth Group

    Normal, IL
    4 days ago
  • $133k - $180k

     ...individual contributor in the software engineering career framework, providing enterprise technical...  ...AI platforms, tools, services, and integrations for LLMs, retrieval-augmented generation...  ...Security, Legal, Compliance, and Data Governance, translating requirements into... 
    Temporary work
    Work experience placement
    Summer work
    Casual work
    Internship
    Seasonal work
    Work at office
    Work from home
    Work visa
    Flexible hours

    Compeer Financial

    Bloomington, IL
    a month ago
  • $94.4k - $129.8k

     ...difference for our clients.About the roleAs a Product Analytics Analyst Sr at COUNTRY Financial, you will be a critical member of our Market...  ...capabilities, leveraging tools such as SQL and Python to enhance data exploration, generating actionable insights, and localized... 
    Senior
    Full time
    Temporary work
    Work experience placement

    Country Financial

    Bloomington, IL
    1 day ago
  •  ...lead cross-functional readiness and execution to bring new vehicle products from concept to life. You will partner with Product Engineering & Development, Supply Chain Management, Manufacturing Engineering, Quality Engineering, and Operations to design, develop, build,... 
    Senior

    Rivian

    Normal, IL
    2 days ago
  • $24.53 - $28.08 per hour

     ...Sr. Warehouse AssociateRivian is on a mission to keep the world adventurous forever. This goes for the emissions-free Electric Adventure Vehicles we build, and the curious, courageous souls we seek to attract. As a company, we constantly challenge what's possible, never... 
    Senior
    Hourly pay
    Odd job
    Full time
    Temporary work
    Part time
    Local area
    Shift work

    Rivian

    Normal, IL
    4 days ago
  • $131k - $174k

     ...Job Description Summary As a Sr Staff Technical Product...  ...Organization within the CES (commercial Engines and Services) you will be...  ...Analytics and will build a connected data ecosystem across the Modeling...  .... Your priority is seamless integration and alignment of perspectives... 
    Senior
    Odd job
    Permanent employment
    Contract work
    Temporary work
    Remote work
    Visa sponsorship
    Work visa
    Relocation package

    GE Aerospace

    Bloomington, IL
    1 day ago
  • $107.75k - $148.18k

     ...customers across North America, providing agronomy, energy, facility engineering and construction, and logistics products and services, as well...  ...on all customers and prospects, contributing daily to CRM data.Maintains the customer addressable volume summary.Maintains a sales... 
    Senior
    For contractors
    Local area
    Remote work
    Work from home
    Night shift

    GrowMark

    Bloomington, IL
    2 days ago
  • Why You Should Work With UsAs a Sinceri Senior Living company, we are a fun loving, employee-centric community like no other! Maybe that's why we have been certified by our employees as a Great Place to Work ® for our 7th Year in a row. Create your healthcare career with...
    Senior
    Shift work

    Sinceri Senior Living

    Normal, IL
    4 days ago
  • $850 per month

    DirectShifts is seeking a Traveling Dentist to provide care in skilled nursing facilities on a one-day-per-week basis. The role offers a flexible schedule and a guaranteed daily pay, with compensation that includes drive time and clinic time. The daily pay rate is $850,...
    Senior
    Daily paid
    Flexible hours
    1 day per week

    DirectShifts

    Bloomington, IL
    4 days ago
  • Job Description Job Description Description: Support Lead is responsible for coordinating and overseeing the CRM Salesforce Production Support team while providing overall direction and leadership for ongoing support and operational activities. This role collaborates...
    Senior

    AVA Consulting

    Bloomington, IL
    23 days ago
  •  ...Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and...  ...technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint... 
    Work experience placement
    Worldwide

    USM Systems

    Bloomington, IL
    4 days ago
  • Senior Fp&A Analyst A Brief Overview The Senior FP&A Analyst executes interest rate risk, budgeting and forecasting modeling, while supporting management reporting and variance analysis. The role works closely with business line leaders to deliver timely, accurate, ...
    Senior
    Work experience placement

    Heartland Bank and Trust Company

    Bloomington, IL
    2 days ago
  • $110k - $150k

     ...rates and rating plans using established procedures while recommending strategic improvements.Strategic Collaboration: Analyze trend data to develop and propose actionable solutions for actuarial and product line management.Project Representation: Serve as the core... 
    Senior
    Remote work
    Work from home

    Fox Point Recruitment

    Bloomington, IL
    5 days ago
  • Senior Sales Executive - Building Controls (New Construction) Job ID 523533 Posted since 22-Sep-2026 Organization Smart Infrastructure Field of work Sales Company Siemens Industry, Inc. Experience level Mid-level Professional Job type Full-time Work mode Hybrid (Remote...
    Senior
    Permanent employment
    Full time
    Work at office
    Local area
    Remote work

    Siemens

    Bloomington, IL
    2 days ago
  • CLA is a top 10 national professional services firm where our purpose is to create opportunities every day, for our clients, our people, and our communities through industry-focused wealth advisory, digital, audit, tax, consulting, and outsourcing services. Even with...
    Senior

    CliftonLarsonAllen

    Bloomington, IL
    2 days ago
  • $150k - $200k

     ...into well-architected solutions that best leverage the Salesforce platform. Develop, test, document and maintain solutions, integrations, and data migration elements of a Salesforce implementation using Salesforce declarative or programmatic development resources such... 

    Steampunk.com

    Bloomington, IL
    2 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Sr Data Integration Engineer. Be the first to apply!