Data Analyst L5
Diageo · Bengaluru
- Experience2–5 yrs
- SalaryNot disclosed
- Work modeonsite
- Levelmid
- Posted16 Sept 2026
About Diageo
Diageo is hiring in Bengaluru in consumer goods. This role looks for around 2+ years of experience.
Skills
- SAP
- Databricks
- SQL
- PySpark
- Python
- data quality
- data validation
- data reconciliation
The role
A data analyst at a consumer goods company validates SAP data quality rules across Databricks layers, translating data validation and data reconciliation requirements into SQL logic. The role also applies PySpark and Python to rule migration and defect analysis.
Full job description
Data Discovery: Identify the SAP tables and fields used for existing Data Quality(DQ) rules & reports and locate the corresponding data in DatabricksData Validation: Validate data across all the layers(bronze, silver,etc) in Databricks for completeness, structure and availability of required fieldsDQ Rule Migration & BUILD: Select and build a set of existing DQ rules in Databricks as part of the PoCPoC Testing & Reconciliation: Execute the rules in Databricks and compare results with the existing DQ results, investigating and resolving differencesEnd-to-End Rule Migration: Following the PoC, migrate / BUILD the agreed As-Is DQ rules to data bricks, including SQL logic, data mappings, rule outputs and required transformationsData & Rule Validation: Perform end-to-end validation of source data, DQ rules, results and defects in Databricks to ensure the migrated process produces expected outcomesDQ Reporting: Support the development of DQ outputs, KPIs and dashboard reporting from Databricks, including validation of report resultsDocumentation & BAU Handover: Document data mappings, DQ rules, validation results and migration processesSQL & Pyspark/Python knowledgeExperience in Data Quality / Data Validation.Experience working with SAP data, preferably master dataGood understanding of SAP tablesExperience with Databricks platformExperience in data reconciliation and comparison between different data sources.Ability to translate DQ requirements/rules into technical SQL or Python logicExperience in DQ rule testing, defect analysis and troubleshooting
Degree Level