A
Senior/Lead Data Modeller
Allianz Services
Pune, India₹20,000–₹50,000/mo≈ AED 880-2.2K/moToday
IndiaMicrosoft AzureData GovernanceData ArchitectureSQLPythonData WarehousingAnalytical SkillsCommunication SkillsData EngineerData ModelerData Vault 20Erwin Data ModelerAzure SQL DatabaseAzure Synapse AnalyticsAzure Data LakeETLELT PipelinesAzure Data FactoryDatabricksDatabase Management SystemsProblemsolving SkillsFull Time
Skills Required
PythonSqlAzureExcelDevopsErpCommunication
Job Description
Job Description As a Senior / Lead Data Modeler at Allianz, you will be responsible for designing and implementing a data model based on Data Vault 2.0 Structure to support the business requirements of Allianz bound business. Your role will involve developing conceptual, logical, and physical data models using Erwin Data Modeler to support transactional, operational, and analytical systems. You will collaborate with business stakeholders, data engineers, and analysts to translate requirements into robust, scalable data structures.
Key Responsibilities:
- Develop conceptual, logical, and physical data models using Erwin Data Modeler.
- Collaborate with stakeholders to translate requirements into robust data structures.
- Ensure adherence to enterprise data standards, naming conventions, and governance policies.
- Architect and deploy data models on Microsoft Azure services.
- Optimize models for cloud-native performance, scalability, and cost efficiency.
- Integrate models with ETL/ELT pipelines using tools like Azure Data Factory or Databricks.
- Maintain comprehensive documentation of data models, including lineage, metadata, and transformation rules.
- Implement data governance frameworks to ensure quality, consistency, and compliance.
- Mentor junior modelers and provide technical guidance to cross-functional teams.
- Partner with DevOps teams to automate model deployment and version control.
Qualifications:
- Education: Bachelors degree in Computer Science, Information Technology, Data Science, or a related field.
- Experience in data engineering, with hands-on exposure to Azure Synapse, Data Factory, SQL, and Python.
- Proficiency in SQL and Python for data tasks.
- Basic understanding of ETL/ELT processes and data warehousing.
- Proven experience as a Data Modeler with Data Vault 2.0 certification or hands-on experience.
- Experience with data modeling tools such as SQLDBMS, Erwin, or similar.
- Strong understanding of database management systems (DBMS) and SQL.
- Excellent analytical and problem-solving skills.
- Strong communication and collaboration skills.
- Attention to detail and ability to work independently.
- Relevant certifications in data modeling or data management are a plus.
- Experience in the insurance or financial services industry.
- Knowledge of data warehousing and business intelligence concepts.
- Familiarity with big data technologies and cloud-based data platforms.
In this role, you will contribute to the enhancement of Allianz's portfolio and accumulation management capabilities by designing and implementing scalable data solutions. Your expertise in data modeling and Azure services will play a crucial role in supporting the business requirements and ensuring data quality and compliance. As a Senior / Lead Data Modeler at Allianz, you will be responsible for designing and implementing a data model based on Data Vault 2.0 Structure to support the business requirements of Allianz bound business. Your role will involve developing conceptual, logical, and physical data models using Erwin Data Modeler to support transactional, operational, and analytical systems. You will collaborate with business stakeholders, data engineers, and analysts to translate requirements into robust, scalable data structures.
Key Responsibilities:
- Develop conceptual, logical, and physical data models using Erwin Data Modeler.
- Collaborate with stakeholders to translate requirements into robust data structures.
- Ensure adherence to enterprise data standards, naming conventions, and governance policies.
- Architect and deploy data models on Microsoft Azure services.
- Optimize models for cloud-native performance, scalability, and cost efficiency.
- Integrate models with ETL/ELT pipelines using tools like Azure Data Factory or Databricks.
- Maintain comprehensive documentation of data models, including lineage, metadata, and transformation rules.
- Implement data governance frameworks to ensure quality, consistency, and compliance.
- Mentor junior modelers and provide technical guidance to cross-functional teams.
- Partner with DevOps teams to automate model deployment and version control.
Qualifications:
- Education: Bachelors degree in Computer Science, Information Technology, Data Science, or a related field.
- Experience in data engineering, with hands-on exposure to Azure Synapse, Data Factory, SQL, and Python.
- Proficiency in SQL and Python for data tasks.
- Basic understanding of ETL/ELT processes and data warehousing.
- Proven experience as a Data Modeler with Data Vault 2.0 certification or hands-on experience.
- Experience with data modeling tools such as SQLDBMS, Erwin, or similar.
- Strong understanding of database management systems (DBMS) and SQL.
- Excellent analytical and problem-solving skills.
- Strong communication and collaboration skills.
- Attention to detail and ability to work independently.
- Relevant certifications in data modeling or data management are a plus.
- Experien