Data Quality Analyst I

About the role

This position is responsible for profiling, analyzing, and evaluating data from QuikTrip's source systems to support data governance and Master Data Management (MDM) efforts, ensuring data used in centralized master data systems is accurate, complete, consistent, relevant, valid, and trustworthy. The role relies on instructions and pre-established guidelines to perform its functions. It reports to the Manager of Enterprise Data & Business Intelligence and collaborates with Enterprise Data & Business Intelligence staff, business stakeholders, data stewards, and primary users of data across departments.

Responsibilities

• Data Profiling – 40%
  • Utilize profiling tools to analyze source data from QuikTrip systems.
  • Base profiling: structure and constraint (primary/foreign key), duplicate, obsolete and invalid record, and composite analyses.
  • Column-level profiling: identifying missing or non-standard values, data types, and allowed values.
  • Cross-column profiling: dependency checks and business rule validations.
  • Cross-table and cross-system profiling: join analysis to identify anomalies such as duplications and orphans, and attribute survivorship.
  • Document and maintain data definitions and data types in a data dictionary.
  • Adhere to QuikTrip's data governance standards and best practices.
• Quality Analysis – 30%
  • Analyze profiling results against the key dimensions of data quality: accuracy, completeness, consistency, timeliness, relevance, validity, and uniqueness.
  • Identify and document data quality issues; recommend data cleansing, transformation, or enrichment strategies.
  • Create metrics and reports on data quality to track improvements; report results to management.
  • Partner with stakeholders, data stewards, and engineers to identify and implement data cleansing rules.
  • Create and manage test plans for user acceptance testing.