Sr Data Integration Engineer

Compeer Financial • Lakeville, MN

3d • $94,400 - $142,900 • Hybrid

About The Position

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.
This position offers a hybrid work option up to 50% remote and is open to any Compeer office location in Illinois, Minnesota and Wisconsin.

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

Nice To Haves

• SQL Server and/or other Microsoft technologies preferred.
• Advanced experience with software deployment, version control, and build automation preferred.

Responsibilities

• Develops, enhances, and maintains complex data movement between various systems using ETL methodologies.
• Leads 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.
• 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.
• Supports reporting and analytic users by designing and creating consumption views for use by various reporting or analytics systems.
• Creates logical links between databases as part of an Enterprise Data Warehouse.
• 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.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior