Job Description
Job Title: Sr. Data Engineer (EDM) - Analytics
Experience : 10+ Yrs ( 5+ Yrs Relevant Exp Data Architecture & Data Modelling)
Location:Chennai
# Purpose :The Data Engineer (EDM) is responsible for designing a highly scalable, agile Enterprise Data Warehouse (EDW) utilizing Data Vault 2.0 methodology. You will solve complex data modelling challenges while championing AI-assisted development tools to automate and accelerate the generation of data models, mappings, and standardized Data Vault boilerplate code.
Note : Candidate must be Expert in enterprise data modelling,data architecture,Snowflake,data vault design,DWH.
# Key Skills :
Data architecture,Data modelling,Logical and Physical data modeling,Data valut 2.0 certified, data vault architecture,Snowflake,Azure,synapse,DBT,AI tools integration i.e. GitHub, Copilot,Clod into Data model.
## Must Have : Hands on Data Vault 2.0 methodology, AI-coding assistants, data modeling tools (Erwin, Hackolade), Snowflake/Azure, and dbt.
# Highlights :
- Typical Activities: Facilitating modeling workshops to identify core business concepts, designing Point-in-Time (PIT) and Bridge tables, and reviewing automated/AI-generated dbt models or SQL scripts to ensure they meet Data Vault 2.0 standards.
- Tools/Technologies: Data Vault 2.0 methodology, AI-coding assistants, data modeling tools (Erwin, Hackolade), Snowflake/Azure, and dbt.
- AI-Driven Efficiency:- Integrate AI-assisted development tools e.g.GitHub Copilot into Data model for automation.
- Enterprise data architecture strategy,pattern,data retention,data Auditing,GRC,data integration.
- GRC : Establish Data modeling standards,Data governance,data standards,data lineage,compliance etc..
- Technical leadership to data modelers and data engineers
- Capability Building for Data Vault 2.0 ,best practices,secure use of AI-coding tools.
- expertise in designing and implementing Data Vault 2.0 architectures (Hubs, Links, Satellites, Hash Keys, PIT/Bridge tables).
