> Markdown version of [/jobs/ext/1751226-sr-data-integration-engineer](https://www.wearedevelopers.com/jobs/ext/1751226-sr-data-integration-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr Data Integration Engineer - **Company:** Compeer Financial - **Location:** Lakeville, MN, United States (Remote available) - **Experience:** Expert - **Salary:** $94,400.0 - $142,900.0 - **Contract:** Permanent contract - **Skills:** Sql Server Data Tools (SSDT), Build Automation, Databases, Data Validation, Data Dictionary, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Systems, Data Warehousing, Database Development, Microsoft Software, Microsoft SQL Server, Online Transaction Processing, Query Optimization, Software Deployment, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Data Streaming, Transact-SQL, Indexer, Information Technology, Tools for Reporting, Software Version Control - **Published:** July 3, 2026 - **Apply:** https://diversityjobs.com/main/sendform/8/8/28176/1/17471446?backUrl=%2Fcareer%2F17471446%2FSr-Data-Integration-Engineer-Minnesota-Lakeville ## About the Role * 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 SQL server knowledge of T-SQL and OLTP topics such as normalization, data types, query tuning, indexing, constraints and query plans, etc. * Advanced SQL Reporting Services (SSRS) or comparable reporting tools experience. * Ability to translate highly technical information into non-technical terms. * Advanced client service skills. * Advanced experience with software deployment, version control, and build automation preferred. * Strong listening, written and verbal communication skills, with ability to communicate at all levels of the organization. * Ability to work independently and collaboratively with other teams to achieve goals and represent the business. * Valid driver's license., 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. ## Description This position is responsible for the development, enhancement and effective operations of complex datamovement 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: ETL Development * Designs, builds, deploys and maintains SQL Server Integration Service (SSIS) packages. * Develops, maintains and administers systems databases. * Functions as a primary contributor in designing, coding, testing and debugging ETL packages and processes to create a seamless data flow. * Supports overall strategy related to database and data warehouse development. * Monitors, troubleshoots and analyzes ETL process failures, data anomalies, inconsistencies and other ETL related issues identified by monitoring, technical team members, and end-users. * Generates automated, repeatable and stable processes to support data load, data validation, and data synchronizations for the data warehouse. * Creates database coding requirements for data warehouse data migrations and business unit and SQL server projects via programming and the various SQL languages. * Identifies and resolves data integrity issues between the data warehouses and the original data sources. Consumption Views * Supports reporting and analytic users by designing and creating 15%consumption views for use by various reporting or analytics systems. * Creates logical links between databases as part of an Enterprise Data Warehouse. Utilizes various SQL tools. 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., 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 ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated)