Data Quality Analyst
Optum Gurugram, Haryana, India
Job Description
"Elevate your career as a Data Quality Analyst at Optum, where you'll play a pivotal role in designing and developing robust reports and dashboards within Oracle Cloud HCM to drive enterprise data quality initiatives."
As a Data Quality Analyst at Optum, you'll be part of a dynamic team that's passionate about delivering high-quality audits and error reports to support data governance, accuracy, and operational readiness.
Your expertise will be instrumental in designing, developing, testing, and deploying Oracle BI Publisher (BIP) and OTBI reports and dashboards that drive business insights and inform data-driven decision making.
Why you should learn this:
The demand for skilled Data Quality Analysts is on the rise, with a 15% increase in job postings over the past year, and a median salary range of $80,000 - $110,000 per annum.
Expected Salary: $80,000 - $110,000 per annum
How it works:
- Step 1: Partner with business stakeholders to gather requirements and translate them into technical specifications.
- Step 2: Design and develop Oracle BI Publisher (BIP) and OTBI reports and dashboards to meet business needs and support data quality initiatives.
Core Concepts to Master
Data Quality Frameworks
Learn about the different data quality frameworks, including DQF, ISO 8000, and ANSI/NISO Z39.19, and how to apply them to real-world scenarios.
Oracle Cloud HCM
Master the skills required to design, develop, and deploy reports and dashboards within Oracle Cloud HCM, including BIP and OTBI.
SQL Query Optimization
Develop expertise in writing efficient and optimized SQL queries to extract insights from large datasets and drive data-driven decision making.
Data Analysis and Visualization
Learn how to perform deep data analysis and create visualizations to communicate insights and inform business decisions.
Interview Questions (Beginner)
- What do you understand by data quality, and how would you ensure data accuracy in a large dataset?
- Can you describe a time when you had to troubleshoot an issue with a report or dashboard?
- How would you approach data analysis and visualization to communicate insights to a non-technical audience?
Job Overview
Advance Questions
- • Design a data quality framework for a large enterprise, including metrics and KPIs to measure data quality.
- • Develop a SQL query to extract insights from a large dataset, including aggregation, filtering, and grouping.
- • Create a dashboard to visualize data quality metrics, including error rates, data completeness, and data consistency.