Data Analyst L5
- ๐ฎ๐ณ India
- On-site
- 20 hours ago
- SAP
- Databricks
- SQL
- PySpark
- Python
About The Client:
A British multinational alcoholic beverage company, with its headquarters in London, England. It operates from 132 sites around the world. It is a major distributor of Scotch whisky and other spirits. Distilleries owned by Client produce 40% of all Scotch whisky with over 24 brands.
Essential Job Functions:
- Data Discovery: Identify the SAP tables and fields used for existing Data Quality(DQ) rules & reports and locate the corresponding data in Databricks.
- Data Validation: Validate data across all the layers(bronze, silver,etc) in Databricks for completeness, structure and availability of required fields.
- DQ Rule Migration & BUILD: Select and build a set of existing DQ rules in Databricks as part of the PoC.
- PoC Testing & Reconciliation: Execute the rules in Databricks and compare results with the existing DQ results, investigating and resolving differences.
- End-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 transformations.
- Data & Rule Validation: Perform end-to-end validation of source data, DQ rules, results and defects in Databricks to ensure the migrated process produces expected outcomes.
- DQ Reporting: Support the development of DQ outputs, KPIs and dashboard reporting from Databricks, including validation of report results.
- Documentation & BAU Handover: Document data mappings, DQ rules, validation results and migration processes.
Qualifications:
Skills:
- SQL & Pyspark/Python knowledge.
- Experience in Data Quality / Data Validation.
- Experience working with SAP data, preferably master data.
- Good understanding of SAP tables.
- Experience with Databricks platform.
- Experience in data reconciliation and comparison between different data sources.
- Ability to translate DQ requirements/rules into technical SQL or Python logic.
- Experience in DQ rule testing, defect analysis and troubleshooting.
Education:
- Degree Level.
How to Apply: Interested candidates are encouraged to respond/submit their updated resumes, and for additional job opportunities, please visit Jobs In India โ VARITE.
Unlock Rewards: Refer Candidates and Earn.
If you're not available or interested in this opportunity, please pass this along to anyone in your network who might be a good fit and interested in our open positions. VARITE offers a Candidate Referral program, where you'll receive a one-time referral bonus based on the following scale if the preferred candidate completes a three-month assignment with VARITE.
| Experience Level | Bonus Referral |
|---|---|
| 0-2 years | INR 5,000 |
| 2-6 years | INR 7,500 |
| 6+ years | INR 10,000 |
About VARITE:
VARITE is a global staffing and IT consulting company providing technical consulting and team augmentation services to Fortune 500 Companies in USA, UK, CANADA and INDIA. VARITE is currently a primary and direct vendor to the leading corporations in the verticals of Networking, Cloud Infrastructure, Hardware and Software, Digital Marketing and Media Solutions, Clinical Diagnostics, Utilities, Gaming and Entertainment, and Financial Services.
Equal Opportunity Employer:
VARITE is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate based on race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, marital status, veteran status, or disability status.
Data Analyst L5 ยท VARITE INDIA PRIVATE LIMITED