Data Analyst

About the Role

As a Data Analyst on Kwik Trip’s IT Data Services team, you will help ensure the accuracy, consistency, and reliability of the data that powers decision‑making across the company. You will develop and maintain SQL‑based data solutions, support enterprise reporting platforms, and implement master data management (MDM) processes that improve data quality and integrity. This role is ideal for someone who enjoys solving complex data challenges and collaborating across business units.

• Support and manage Kwik Trip’s MDM tools (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 tools such as Microsoft SSIS, Informatica ETL, and SAS Data Flux.
• Support enterprise reporting platforms including Power BI, SSRS, and Sigma.
• Build dashboards and reports that provide clear, actionable insights to business partners.
• Implement and manage MDM best‑record and matching processes to improve data quality.
• Assist in 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.
• Serve as a subject matter expert for enterprise data and support business units with data‑related needs.

• Bachelor’s degree in computer science, data science, or a related field, or equivalent experience.
• At least two 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 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.

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