Sr. Data Quality Analyst

Job Overview

The responsibilities of the Sr. Data Quality Analyst include implementation and support of business rules within the data quality framework. This role will participate in the full data quality lifecycle from requirement elicitation through ongoing support. The candidate selected for this role will develop technical components that meet the business/functional requirements or from logged data incidents. The position plays a pivotal role in the definition of our data quality program, which includes policy, process, standards, and tools. The role demands an ability to understand the data semantics, business use and relationships.

Roles And Responsibilities

• Ability to translate business concerns into technical requirements/specifications
• Ability to elicit requirements both from business users as well as Data Incident Management. Ensure data issues detected in the past are not repeated in the future.
• Develop technical specifications that demonstrate how data quality will be preserved/enforced. Maintain as built documentation for the current as-built rules register.
• Build quality rules code base to monitor data flows and ensure acceptable levels of trust.
• Participate in Data Profiling POC evaluating product capabilities and make recommendations.
• Oversee the execution of data profiling both for the purpose of ensuring acceptable quality as part of ingestion but also to understand data shift over time. Adjust these two profiling processes as necessary to meet business objectives.
• Analyze Profiling and Rule results to ensure business requirements are being met. Fine tune configurations and rules to optimize both results and performance. Make design/process recommendations as needed.
• Triage data anomalies to determine root cause. Participate in solutioning sessions to determine anomaly resolution and address any data purity issues.
• Work with the BA team to generate data to power quality dashboards, which allow both data providers and data consumers to monitor data quality.
• Contribute to business/technical definitions of data objects within the data catalogue.
• Assist in the creation and maintenance of Data Lineage documentation.
• Serve as an SME for multiple data domains. Assist business users in the selection, understanding and use of data.
• Perform UAT on data sets as part of data ingestion, egress, transformation and rule execution.
• Ensure that all solutions, technical configurations and other work products are thoroughly unit-tested prior to delivery. Participate in system/integration testing as appropriate. Perform reviews and other QA steps as requested.
• Adhere to Darden SDLC, coding and data standards.
• Proactively identify data issues or process issues impacting data.
• Effectively communicate with stakeholders. Ensure issues are analyzed discussed and resolved in a timely manner.
• Consistently enhance skills and job knowledge by researching techniques, technologies and software products; reading professional publications.
• Provide for thorough and accurate Data Quality Tool administration to ensure the platform is properly managed.
  
  

Required Technical Skills

• Strong understanding of data structures, data types, and data transformation.
• Ability to perform complex data mappings, workflows and sessions.
• Experience with SQL, and other data transformation/analytics tools such as Informatica, Talend, or Alteryx.
• Expertise in reading, analyzing and debugging SQL.
• Ability to troubleshoot data processing performance issue.
• Experience or willingness to learn data profiling/quality tools such as Collibra, Ataccama, Informatica or OEDQ.
• Experience or willingness to learn SparkSQL and Databricks.
• Good analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively analyze result set and triage quality issues.
• Work in multiple stages of the SDLC from development through production support.
• Expertise in working with spreadsheets, strong understanding of financial concepts and data.
• Ability to work independently, take ownership of tasks and follow through to implementation/resolution.
• Resolve end user data problems through collaboration with both technical and functional personnel in a team environment.
• Demonstrated competency in developing and testing complex rule sets.
• Exceptional verbal and written communications skills, with an ability to express complex technical concepts in business terms.
• Solid teamwork and interpersonal skills.
• Strong analytical, problem-solving and conceptual skills.
  
  

Required Education

• Bachelor's degree in IT related discipline or equivalent experience (BS / BA in MIS, Computer Science, Business, Mathematics or Engineering)
  
  

Other Key Qualifications

• Data modeling Experience
• Experience with Cloud Data Warehouse products such as Snowflake or Azure Synapse
• Experience using reporting tools like Power BI for Data quality visualizations
• Experience with Python, Scala or Java
• Knowledge of restaurant or retail business
  
  

Preferred Skills And Experience

• 5 years’ experience across Business Intelligence/Data Warehouse/Data Lake projects
• 1 years’ experience on Data Quality and Governance initiatives, with at least one successful implementation
• Experience programming in SQL with ability to develop complex queries against large disparate data sets
• Experience with data integration patterns, data pipelines and tools such as Azure Data Factory
• Knowledge of Data and Delta Lake Structures