Master Data Analyst

Kwik Trip; La Crosse (WI); On-site; USD 65,000 - 90,000; Full time

Job summary

Kwik Trip's IT Data Services team is seeking a Master Data Analyst to support master data management and enterprise reporting. You will build SQL queries, ETL processes, and MDM workflows while serving as a subject matter expert for data across business units.

The role focuses on sustaining data quality, developing dashboards in Power BI and SSRS, and collaborating with vendors and internal partners to enable data-driven decisions.

Qualifications

• Bachelor’s degree in computer science, data science, or a related field (or equivalent experience).
• At least 2 years of related professional experience.
• Strong SQL skills and experience with relational databases and enterprise software.
• Ability to write complex queries and work with advanced database tools.
• Experience troubleshooting ETL jobs, SQL stored procedures, and data integration issues.

Responsibilities

• Support and manage Kwik Trip’s master data management (MDM) tools, including Informatica, SAS, and future platforms.
• Build MDM jobs and pipelines that ingest, match, merge, and distribute data to downstream systems.
• Develop and maintain complex SQL queries, stored procedures, and ETL processes.
• Create and maintain ETL jobs using SSIS, Informatica ETL, and SAS DataFlux.
• Support enterprise reporting platforms including Power BI, SSRS, and Sigma.
• Build and maintain dashboards and reports that deliver clear, actionable insights for business partners.
• Implement and manage master data best-record and matching processes to improve data quality.
• Assist with creating and maintaining data dictionaries, data flow diagrams, and integration documentation.
• Partner with software vendors to resolve issues, manage upgrades, and stay informed on future enhancements.
• Act as a subject matter expert for enterprise data and support business units with data-related needs.

Skills

SQL

Data analysis

Relational databases

Complex queries

Education

Bachelor’s degree in computer science or related field

Equivalent experience

Tools

Informatica

SAS

SAS DataFlux

SQL Server/SSIS

Informatica ETL

Power BI

SSRS

Sigma

Job description

On Kwik Trip’s IT Data Services team, this role supports master data management and enterprise reporting. You will build SQL and ETL solutions, maintain MDM workflows, and help deliver reporting dashboards that enable business partners to make data-driven decisions.

Role Overview

The Master Data Analyst is responsible for supporting and improving Kwik Trip’s master data management capabilities and enterprise reporting platforms. Work includes creating MDM jobs and pipelines, maintaining ETL processes, and serving as a subject matter expert for enterprise data and data-related requests from business units.

Key Responsibilities

• Support and manage Kwik Trip’s master data management (MDM) tools, including Informatica, SAS, and future platforms.
• Build MDM jobs and pipelines that ingest, match, merge, and distribute data to downstream systems.
• Develop and maintain complex SQL queries, stored procedures, and ETL processes.
• Create and maintain ETL jobs using Microsoft SSIS, Informatica ETL, and SAS DataFlux.
• Support enterprise reporting platforms including Power BI, SSRS, and Sigma.
• Build and maintain dashboards and reports that deliver clear, actionable insights for business partners.
• Implement and manage master data best-record and matching processes to improve data quality.
• Assist with creating and maintaining data dictionaries, data flow diagrams, and integration documentation.
• Partner with software vendors to resolve issues, manage upgrades, and stay informed on future enhancements.
• Act as a subject matter expert for enterprise data and support business units with data-related needs.

Required Qualifications

• Bachelor’s degree in computer science, data science, or a related field (or equivalent experience).
• At least 2 years of related professional experience.
• Strong SQL skills and experience with relational databases and enterprise software.
• Ability to write complex queries and work with advanced database tools.
• Experience troubleshooting ETL jobs, SQL stored procedures, and data integration issues.