Data Modeler

Job Location- Bangalore, Chennai, Pune, Kolkata, Gurugram

Exp Level : 5+ Yrs

Role & responsibilities

• Must have total 5+ yrs. of IT experience
• Mandatory experience in Consumer Packaged Goods (CPG) or Retail industries
• Solution Architect for Data modelling Understanding of Enterprise datasets Sales, Procurement, Finance, Supply Chain, Logistics, R&D, Advanced Planning systems (SAP / Oracle etc.).
• Have worked for minimum five years for Data projects ( Upgradation, Migration, Building Data lake foundation, Maintenance etc).
• Collaborate with the product / business teams, understand related business processes and document business requirements and then write high level specifications / requirements for DEs.
• Develop logical / physical data models as per Medallion architecture / EDW / Kimball model; Scout for right grain of data either in True source systems or in Data WHs and build reusable data models in intermediary layers before creating physical consumable views from data mart.
• Understand Cloud architecture, solution components in Cloud, DevOps, DataOps; Data Governance, Data Quality frameworks, Data Observality
• Candidate should be : Familiar with DevOps process
• Knowing how to check existing tables, data dictionary, table structures
• Experienced with normalizing tables
• Having good understanding of Landing, Bronze, Silver and Gold layers and concepts
• Familiar with Agile techniques
• Create business process map, user journey map and data flow integration diagrams; Understand Integration needs (Integration through API, FTP, webservices and SFTP) for E2E deployment of models.
• Stakeholder management with data engineering, product owners, central data modelling team, data governance & stewards, Scrum master, project team and sponsor.
• Ability to handle large implementation program with multiple projects