Sr Data Engineer

Overview

MN-Mankato; MN-Lakeville; IL-Bloomington

Empowered to live. Inspired to work. Compeer Financial is a member-owned cooperative located in Illinois, Minnesota and Wisconsin. We provide financial services to support agriculture and rural communities. We offer a culture that promotes meaningful work and professional development, with a flexible, hybrid work environment and excellent benefits to help you 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
• Cross-functional committee opportunities (e.g. Inclusion Council, emerging professional groups)
• Professional membership/certification reimbursement and more

Casual/seasonal & intern team members are not eligible for benefits except for state-mandated programs.

This position offers a hybrid work option up to 50% remote and is based out of the Mankato, MN;
Lakeville, MN;
Bloomington, IL office.

This position is responsible for building advanced analytics tools that utilize the data pipeline to provide actionable, high-impact insights for decision making. Delivers processed data to end-users, including business intelligence analysts and business stakeholders who consume the data via interactive dashboards, reports and other tools. Works cross-functionally to define analytical requirements, ensuring that data solutions effectively empower informed, data-driven decision-making across departments.

Serves as a subject matter expert, providing technical guidance and support to less tenured team members.

• Develops complex data models and data pipelines for research, reporting and machine learning.
• Conceptualizes and generates infrastructure that allows data to be accessed and analyzed.
• Maintains and optimizes the performance of the data User Interface layer to ensure accurate, reliable and timely delivery of key insights for decision making.
• Models data sources to help draw a more comprehensive picture of the data that enables powerful data analysis and reporting.
• Leads the development and execution of new concepts and proof of concept designs.
• Conducts research to answer business questions related to data and the data warehouse.
• Employs a variety of SQL languages to bring data from multiple systems together into the user interface layer.
• Generates automated, repeatable and stable processes to support business requests in the user interface layer.
• Proactively identifies and resolves data integrity issues between the data warehouses and the original data sources.

• Stays current on trends and industry best practices, proactively incorporating new insights into the design, implementation and improvement of internal processes.
• Drives the automation of manual processes and the optimization of data delivery and quality.
• Works cross-functionally with Data and Business Technology teams to formulate best practices.
• Evaluates emerging tools, platforms and methodologies.
• Fosters innovation and drives the adoption of new technologies that enhance team and operational effectiveness.
• Advances strategic initiatives by providing thought leadership and building alignment around long-term data strategy.

• Facilitates meetings with Data, Project Delivery and/or business unit team members.
• Supports and trains other team members, acting as a subject matter expert for more complex technical issues and guiding less tenured team members on problem resolution.

• Bachelor’s degree in math, computer science, MIS, or related field or equivalent education/experience
• Minimum of 7 years of experience with MS SQL environments (2017 and above), designing and implementing objects using SQL Server Data Tools
• SQL Server and/or other Microsoft technologies preferred
• Advanced SQL knowledge (T-SQL, OLTP, normalization, data types, query tuning, indexing, constraints, query plans)
• Cloud computing experience (MS Azure)
• Microsoft Fabric experience
• Experience creating stored procedures, views, functions, T-SQL, SQL scripting
• Experience with data warehouses, APIs, ETL scripting, Python, R, PySpark, Notebooks
• Experience with SQL Reporting Services (SSRS) or comparable tools
• Ability to translate technical information for non-technical audiences
• Experience with deployment, version control, and build automation (CI/CD pipelines)
• Strong communication, interpersonal, analytical, organizational and planning skills
• Ability to influence cross-functional stakeholders and drive strategic initiatives
• Independent and collaborative work style with initiative and…