Sr Data Integration Engineer

The Role

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

Responsibilities

• Develops, enhances and operates complex data movement between various systems using ETL methodologies.
• Led company database development efforts and coordinates with business users, consultants/contractors, vendors and internal team members to maximize the usage and value of company data assets.
• 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.
• Supports reporting and analytic users by designing and creating 15% consumption views for use by various reporting or analytics systems.
• Supports overall strategy related to database and data warehouse development.
• 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.

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

Qualifications

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.

Benefits

• Up to 9% towards 401k (3% fixed Compeer contribution plus up to 6% match).
• 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!

Pay

$94,400 - $142,900 USD

Schedule

Hybrid model – up to 50% work from home