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

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.

Skills

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

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