Senior Data Quality Analyst from System One
Columbus, OH 43219
About the Job
Overview
Immediate focus of this role is to support business object migration to power bi. Candidate will be responsible for analyzing and understanding existing reports, data mapping, identifying any data gaps, validating data quality & metrics and ensuring a smooth transition.
Additional responsibilities include maintaining data quality standards by proactively measuring data quality metrics and work cross-functionally to improve the quality of data across multiple sources and platforms. A successful candidate should have a passion for data, is detail oriented, understand technical systems, and can effectively communicate with team members and business stakeholders.
Primary Duties and Responsibilities
Immediate focus of this role is to support business object migration to power bi. Candidate will be responsible for analyzing and understanding existing reports, data mapping, identifying any data gaps, validating data quality & metrics and ensuring a smooth transition.
Additional responsibilities include maintaining data quality standards by proactively measuring data quality metrics and work cross-functionally to improve the quality of data across multiple sources and platforms. A successful candidate should have a passion for data, is detail oriented, understand technical systems, and can effectively communicate with team members and business stakeholders.
Primary Duties and Responsibilities
- Maintain overall data quality and integrity across the organization. Develop, document, and maintain data quality goals and standards
- Review data loaded into the enterprise data warehouse for accuracy
- Identify areas for data quality improvement and help to resolve data quality problems through the appropriate choice of error detection and correction, process control and improvement.
- Work across functional teams to identify and resolve data issues
- Perform data profiling and statistical tests, verifying the integrity of complex datasets
- Collaborate with data stewards, data custodians and business partners to define data quality standards for error detection
- Assist data engineering team in conjunction with the analytics team to help classify data architecture for use with various reporting tools
- As a key member of the Data Quality team access business impact level for data quality issues, determine root causes and make recommendations for long-term solutions.
- Work with data engineers to implement and automate data quality related business requirements
- Partner with the business to promote data quality overall quality awareness across organization
- Define overall data quality KPIs, measurements and reporting standards including escalation of systemic data quality issues
- Work with DB and BI developers in unit testing views and stored procedures
- Perform data validation and support report validation
- 5+ years of working experience in IT
- 3+ years of hands-on SQL experience
- 2+ years of data quality experience in a data warehouse
- 2+ years of experience in data profiling
- Experience with enterprise data quality monitoring
- Experience with data migration & data mapping
- Advanced MS Office Suite skills, especially Excel
- Strong problem-solving and analytical skills are required
- Knowledge of tools used to support data management including data profiling and data quality
- Should be able to adapt communication style to suit different audiences such as IT, sales, finance, operations.
- Experience with agile methodologies: SCRUM
- Working knowledge of BI tools (Power BI)
- Knowledge of SAP modules a plus
- Business acumen is desirable
- Bachelor's degree in statistics, computer science, information management, or similar