Responsibilities:
Ensure Data Accuracy and Completeness in BigQuery
- Validate row counts, null values, and duplicate records
- Verify data logic consistency
- Reconcile data with source systems
Monitor and Report Data Ingestion Issues
- Review data after ingestion into the database
- Identify root causes and contributing factors
- Communicate issues to relevant teams
Validate Calculation Methods for Analytical Consistency
- Review calculation processes and formulas
- Ensure reported metrics align with business definitions
Develop and Maintain Data Quality Standards (SOP)
- Create and maintain data validation checklists
- Continuously improve SOPs based on identified issues
Provide Data Support and Consultation to Cross-Functional Teams
- Respond to inquiries regarding data and metrics
- Explain calculation methodologies and data sources
- Coordinate with relevant teams on data-related issues
- Follow up on issue resolution and validate fixes
Requirements:
- Bachelor's degree in Data Analytics, Computer Science, Information Systems, Statistics, Business Analytics, or a related field
- 13 years of experience in data analysis, data quality, or related roles (fresh graduates with strong skills are welcome)
- Experience working with databases and cloud data platforms (e.g., BigQuery, Snowflake, Redshift)
- Understanding of data pipelines, ETL/ELT processes, and data validation concepts
- Familiarity with business intelligence and reporting tools (e.g., Power BI, Tableau, Looker)
- Basic knowledge of data governance and data management principles
- Good command of English (written and verbal)
- Data Quality Assessment & Validation
- SQL Querying and Data Profiling
- Data Reconciliation & Root Cause Analysis
- Documentation & SOP Development
- Stakeholder Communication
- Problem-Solving and Analytical Thinking
- Attention to Detail
