Data Modeler/Architect - Power BI/Python (5-16 yrs)

Experience : 5-16 Years

Work Type : Hybrid

Location : Bangalore, Chennai, Pune, Gurgaon and Kolkata

Mandatory Skills : Data Modelling, Data Architect, Data Warehousing, Data Visualization, Power BI, Python, SQL, OLAP, OLTP, Dimensional Modelling, Erwin, Azure DevOps, Azure Data Bricks, and Azure DataFactory

Roles and responsibilities :

- 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 5 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

- 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 spanning over an year.

- Understand Cloud architecture, solution components in Cloud, DevOps, DataOps; Data Governance, Data Quality frameworks, Data Observality and the candidate should be :

1. Familiar with DevOps process

2. Knowing how to check existing tables, data dictionary, table structures

3. Experienced with normalizing tables

4. Having good understanding of Landing, Bronze, Silver and Gold layers and concepts

5. Familiar with Agile techniques