Sr Data Integration Engineer
$94.4k - $142.9kCompeer 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.
$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...SuggestedFull timeTemporary work- ..., 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...SuggestedHourly payFull timeContract workInternshipSummer internshipLocal areaVisa sponsorshipShift work
$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...SeniorFull timeTemporary work- 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
$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...SuggestedH1bWork at officeImmediate start$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 timeTemporary workFlexible hours$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...SeniorPermanent employmentContract workRemote workVisa sponsorshipWork visaRelocation package- 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...SeniorFull timeH1b
$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...SeniorFull timeTemporary work$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...SeniorTemporary workWork experience placementSummer workCasual workInternshipSeasonal workWork at officeRemote workWork from homeWork visaFlexible hours$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...SeniorFull timeTemporary work- 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
- ...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...SeniorRemote workShift work
$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...SeniorFull timeFor contractorsWork experience placementInterim roleLocal areaShift work$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...SeniorTemporary workImmediate startFlexible hours$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 workWork experience placementSummer workCasual workInternshipSeasonal workWork at officeWork from homeWork visaFlexible hours$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...SeniorFull timeTemporary workWork experience placement- ...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
$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...SeniorHourly payOdd jobFull timeTemporary workPart timeLocal areaShift work$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...SeniorOdd jobPermanent employmentContract workTemporary workRemote workVisa sponsorshipWork visaRelocation package$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...SeniorFor contractorsLocal areaRemote workWork from homeNight shift- 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...SeniorShift work
$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,...SeniorDaily paidFlexible hours1 day per week- 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
- ...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 placementWorldwide
- 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, ...SeniorWork experience placement
$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...SeniorRemote workWork from home- 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...SeniorPermanent employmentFull timeWork at officeLocal areaRemote work
- 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
$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...
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Sr Data Integration Engineer. Be the first to apply!
- data engineering intern summer Bloomington, IL
- senior living Bloomington, IL
- senior accountant remote Bloomington, IL
- senior devops engineer remote Bloomington, IL
- senior activities Bloomington, IL
- srs Bloomington, IL
- senior net developer remote Bloomington, IL
- senior financial analyst fp&a Bloomington, IL
- senior database analyst Bloomington, IL
- senior accountant work from home Bloomington, IL




