Description:
The Senior Data Quality Analyst in this role will join a growing Data & Analytics team. In this critical role, you will play a key part in ensuring the accuracy, completeness, consistency, and reliability of our valuable data assets. You will work closely with business teams and technology partners to identify and address data quality issues proactively.
Business Purpose
To help further the Data Quality Program. To proactively find and fix data quality issues closer to the source.
Accountabilities
Document and implement data quality checks on various business data assets.
Work with business teams and technology teams to solicit data quality requirements, including identifying critical data elements and business logic checks.
Major Responsibilities
Data Quality Assessment and Monitoring:
- Perform comprehensive data quality assessments across various systems to evaluate accuracy, completeness, consistency, and reliability.
- Set up and manage ongoing data quality monitoring processes and tools.
- Develop and implement data quality metrics and frameworks to track and improve data quality over time.
Data Profiling And Requirement Analysis
- Profile data to gain insights and identify trends to work with data teams in identifying the data quality checks.
- Identify data quality issues such as inconsistencies, inaccuracies, and missing values.
- Validate data integrity through automated and manual checks, ensuring data meets quality standards.
Data Quality Checks And Data Analysis
- Write, optimize, and execute complex SQL queries to create data quality checks and measure the data from multiple sources.
- Use SQL for in-depth data analysis to identify and troubleshoot data quality issues.
- Configure and schedule Data Quality checks on the DQ framework to run as per the required schedules.
Root Cause Analysis And Remediation
- Conduct root cause analysis to identify underlying issues contributing to data quality problems.
- Develop and implement remediation plans to address identified issues and prevent recurrence.
Documentation And Compliance
- Document data quality issues, remediation actions, and processes clearly.
- Ensure adherence to data governance policies and standards, maintaining compliance with relevant regulations.
Stakeholder Engagement And Communication
- Collaborate with data owners, IT, and business units to understand data quality requirements and address issues.
- Provide training and support to teams on data quality best practices and governance policies.
- Communicate data quality status and improvement efforts effectively to stakeholders.
- Oversee and manage data integration processes to ensure consistent data quality across systems.
- Ensure accurate and consistent data transformation to meet business needs.
Reporting And Dashboarding
- Design, create, and maintain dashboards and reports to visualize data quality metrics and trends.
- Communicate findings, insights, and remediation progress to both technical and non-technical stakeholders through clear and actionable reports.
Required
- 4-6 years of experience in Data Quality Assurance, Data Analysis, or a related field.
- SQL Expertise: Proficient in writing and optimizing complex SQL queries for data profiling, analysis and to create data quality checks. Preferably Snowflake.
- Business Analysis: Strong analytical skills to interpret data quality metrics, identify issues, and provide actionable insights and possible solutions.
- Problem Solving: Ability to perform root cause analysis, develop solutions, and implement effective remediation plans.
- Communication and Collaboration: Excellent communication skills to interact with stakeholders, explain technical concepts, and report on data quality findings.
- Attention to Detail: Strong focus on detail to ensure high data accuracy and quality. Data Governance:
- Understanding of data governance principles and ability to enforce data quality standards and policies.
- Power BI Dashboarding: Experience with dashboarding tools such as Power BI, Tableau, or similar for creating visualizations and tracking data quality.
- Bachelors Degree in Computer Science or relevant field
- Relevant certifications (nice to have) such as CDMP, CIMP, AWS Certified Data Analytics
- Nice to Haves
- Programming Skills (Python):
- Experience with Python for data manipulation, automation, and advanced data quality tasks.
- Debugging Skills:
- Ability to debug and troubleshoot data quality issues and code-related problems effectively.
- DQ Tools: Familiarity with DQ tools such as Montecarlo, DQ Labs, Anomalo, Ataccama, Owl DQ, IBM Information Analyzer, Informatica Data Quality etc.
- Soft Skills