Tech Lead - Data Modelling Job

8-10 Years

• Creation of logical and physical data models along with accurate metadata for the Data warehousing Solutions


• Create conceptual data model to identify key business entities and visualize their relationships.


• Experience with Erwin or relevant data modelling tools to generate logical and phyiscal data models on Azure platform


• Perform data profiling/analysis activities that helps to establish, modify and maintain data model.


• Communicate physical database designs and dba and explains features that may affect the physical data model.


• Work closely with business and dev teams to translate the business/functional requirements into technical specifications that drive Big Data solutions to meet functional requirements.


• Present and communicate modeling results and recommendations to internal stakeholders.


• Ensure and enforce a governance process to oversee implementation activities and ensure alignment to the defined architecture.


• Regularly engage and consult stakeholders on solving business problems through data, guiding the conversation rather than following orders.


• Analyze data-related system integration challenges and propose appropriate solutions with strategic approach.


• Ensure compliance with data governance and security policies


• Collaborate internationally with various stakeholders.


• Engage with clients to clarify inbound research requests.


• Contribute to coordination and planning of Cloud Infrastructure related activities / outages


• Performance tuning using caches and parallel execution using bulk loading and dataflow execution


• Lead a team to deliver the expected business results


• Mentor Junior consultants in team and provide assistance in case needed


• Build, test, and maintain database pipeline architectures and collaborate with management to understand company objectives


• Ensure compliance with data governance and security policies


• Work closely with business and dev teams to translate the business/functional requirements into technical specifications that drive Big Data solutions to meet functional requirements.


• Must have one of the domain knowledge (Manufacturing, sales, supply chain, finance)