DataJobs.io
← Back to all jobs
Kwik Trip

Master Data Analyst

Kwik Trip
La Crosse, WI $67k - $100k/yr Full time Posted 16d ago
Business Intelligence Data Analysis Data Analytics Data Integration Data Pipeline Data Platform Data Processing Data Visualization ETL Informatica Mdm Power BI Reporting and Analytics SQL
Apply Now

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.
  • Understanding of Master Data and Data Quality concepts.
  • Ability to develop data requirements and specifications.
  • Familiarity with version control and release management.
  • Strong problem-solving, communication, and collaboration skills.

Preferred (Even Better If You Have)

  • Experience with SSIS and Azure Data Factory.
  • Experience with Informatica MDM, SAS DataFlux, or similar tools.
  • Experience creating dashboards in Power BI, SSRS, or Sigma.

Technologies

  • SQL
  • Informatica
  • SAS
  • Informatica ETL
  • SAS DataFlux
  • Microsoft SSIS
  • Microsoft Power BI
  • SSRS
  • Sigma

Compensation and Benefits

Salary: USD 66,535 - 99,803 per year.

  • Comprehensive benefits package, including health insurance, 401k, paid time off, and more.
  • 40% of pre-tax profits returned to coworkers, with bonuses ranging from 8-12% of each coworker’s gross annual wage depending on company profitability.

Location and Work Schedule

  • Location: La Crosse, WI (hybrid)
  • Schedule: Monday through Friday, daytime hours

Education

Bachelor’s degree in computer science, data science, or related field (or equivalent experience).

Similar Jobs