Data Quality Analyst I

Job description

Primary Purpose of job: 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. This position relies on instructions and pre-established guidelines to perform the functions of the job. Major Functions: Data Profiling – 40% a. Utilize profiling tools to analyze source data from QuikTrip systems. i. Base profiling: structure and constraint (primary/foreign key), duplicate, obsolete and invalid record, and composite analyses. ii. Column-level profiling: identifying missing or non-standard values, data types, and allowed values. iii. Cross-column profiling: dependency checks and business rule validations. iv. Cross-table and cross-system profiling: join analysis to identify anomalies such as duplications and orphans, and attribute survivorship. b. Document and maintain data definitions and data types in a data dictionary. c. Adhere to QuikTrip's data governance standards and best practices. 2. Quality Analysis – 30% a. Analyze profiling results against the key dimensions of data quality: accuracy, completeness, consistency, timeliness, relevance, validity, and uniqueness. b. Identify and document data quality issues; recommend data cleansing, transformation, or enrichment strategies. c. Create metrics and reports on data quality to track improvements; report results to management. d. Partner with stakeholders, data stewards, and engineers to identify and implement data cleansing rules. e. Create and manage test plans for user acceptance testing. 3. Application Administration – 10% a. Perform the administration of Data Governance specific applications like Data Catalog, MDM Hubs, stewardship tools, etc. b. Includes system configuration, user access management, troubleshooting, and ongoing platform maintenance to support business operations. 4. Documentation – 10% a. Partner with business stakeholders and subject matter experts to identify and document scope, purpose, business rules, and requirements. b. Document lifecycle management processes for data creation, modification, and deletion. c. Identify and document data sources, including systems, files, and tables. d. Translate business rules, processes, and requirements into functional and non-functional requirements. e. Understand source systems contributing to the master data domain and identify overlaps and inconsistencies across systems. 5. Training – 5% a. Seek input from team members and supervisors on areas to improve skill set. b. Actively apply feedback received into day-to-day work and strive to improve performance. c. Actively utilize training outlets as necessary to improve analytical and technical skills, including self-study, in-house classes, seminars, or online training. d. Maintain professional and technical knowledge by attending ongoing training, reviewing professional publications, and reviewing industry best practices and new technologies to determine fit within the organization. 6. Administration and Communication – 5% a. Listen to others and accept input from team members. b. Clearly articulate ideas and thoughts both in verbal and written formats. c. Accurately prepare written business correspondence that is coherent, grammatically correct, effective, and professional. d. Timely communicate status updates with supervisors, project stakeholders, and/or key customers regarding specific assignments and overall scheduling and coordination needs. Position in Organization: Reports to: Manager of Enterprise Data & Business Intelligence Relationships: Inside the Company: Enterprise Data & Business Intelligence staff, business stakeholders, data stewards, and primary users of data across departments. Outside the Company: N/A Position Specifications: The required specifications (education, experience, and skills) are those that the employee must have to hold the position. Applicants applying for this position must possess the required specifications in order to be considered for the job. The desired specifications are those that are not required for the employee to hold the position, but the employee should try to obtain the desired education, experience, and/or skills to be effective and successful in the position. Required education: Bachelor's degree in mathematics, computer science, statistics, or a related field, or equivalent professional experience. Desired education : Coursework or certification in data management, data quality, or data governance (such as CDMP). Required experience: 3 or more years of professional experience working with real-world datasets, or meets desired education requirements above. Desired experience : Experience supporting Master Data Management (MDM) or data quality initiatives in a business environment. Required skills: Proficiency with SQL; understanding of database systems and querying languages used at QuikTrip. Desired skills : Python; experience with Databricks or similar cloud data platforms; ability to create clear, insightful data visualizations using Power BI or Excel. Additional criteria: This position requires good communication skills to work effectively with business stakeholders and data stewards across the organization. Ability to work in a fast-paced team environment. Works under general supervision. Intermittent or extended travel may be required based on project requirements. Starting Salary: $74,900 - $93,630 Benefits: Employee Benefits – QuikTrip #LI-MI1