Senior Data Engineer MDM Data Vault

Forward Eye Technologies; Dadri; On-site; INR 2,400,000 - 4,200,000; Full time

Job summary

Forward Eye Technologies is seeking a Senior Data Engineer specializing in MDM Data Vault to design, build, and optimize DBT-based data models and enterprise data warehouses. The role emphasizes Data Vault 2.0 implementation, data quality, and collaboration with data scientists and analysts to deliver scalable data solutions.

You will work with Snowflake, Python, and Airflow to automate data pipelines, validate data quality, and ensure data integrity across complex datasets in a fast-paced

Qualifications

• 8+ years of experience in data engineering or related roles.
• Proven expertise in DBT-based data modeling concepts and best practices.
• Experience implementing Data Vault 2.0 architecture and MDM solutions.

Responsibilities

• Design and develop DBT-based data models and entities per project requirements.
• Implement Data Vault 2.0 architecture with Hubs, Links, and Satellites for MDM.
• Develop and maintain data structures for enterprise data warehouse (Snowflake).
• Collaborate with data architects to align warehousing solutions with business needs.
• Create, debug, and optimize stored procedures, functions and views.

Skills

SQL

Python

DBT

Data Vault 2.0

MDM

Data Warehousing

Airflow

Tools

Snowflake

Stored Procedures

Views

Job description

Job Responsibilities

• Efficiently design and develop DBT-based data models and entities by understanding project requirements.
• Implement Data Vault 2.0 architecture principles, including the creation of Hubs, Links, and Satellites for master data management (MDM).
• Design, develop, and maintain robust data structures to facilitate efficient data processing, storage, and retrieval within an enterprise data warehouse (Snowflake).
• Collaborate with data architects to ensure data warehousing solutions align with business needs and scalability requirements.
• Create, debug, and optimize stored procedures, functions, and views to ensure data accuracy, performance, and availability.
• Write complex SQL queries to support data integration, transformation, and reporting needs.
• Utilize Python for scripting and automation tasks to enhance data workflows and streamline processes.
• Develop automated data quality checks and data validation routines using Python and other relevant tools.
• Implement data quality checks and processes to validate and cleanse data, ensuring integrity and accuracy.
• Identify and resolve data anomalies and inconsistencies proactively.
• Work closely with cross-functional teams, including data analysts, data scientists, and business stakeholders, to understand data requirements.
• Deliver actionable insights and data solutions that meet business objectives.

Required Qualifications

• Minimum of 8 years of experience in data engineering or related roles.
• Proven expertise in DBT-based data modeling concepts and best practices, including project structure, testing automation, packages, and deployment.
• Experience implementing Data Vault 2.0 architecture and MDM solutions, including knowledge of Hubs, Links, and Satellites.

Technical Skills

• Strong proficiency in SQL programming, including the ability to create and debug stored procedures, functions, and views.
• Experience with Python for scripting and automation tasks.
• Knowledge of data warehousing concepts and experience working with Snowflake or similar platforms.
• Familiarity with data orchestration tools such as Airflow is preferred.

Soft Skills

• Self-motivated with a strong sense of ownership and responsibility for projects.
• Strong problem-solving skills and meticulous attention to detail.
• Excellent communication skills for effective collaboration with technical and non-technical stakeholders.

Keywords

• Data Vault 2.0
• Python
• MDM
• DBT (Data Build Tool)
• Data Warehousing
• SQL
• Snowflake
• Data Quality Assurance

This job description outlines the key responsibilities, qualifications, and skills required for a Senior Data Engineer specializing in MDM Data Vault. The role involves designing and developing data models using DBT, implementing Data Vault 2.0 architecture, and leveraging SQL and Python for data processing and automation. The ideal candidate should have a strong background in data engineering, data warehousing, and data quality assurance, with excellent collaboration and problem-solving skills.

Location-

Bengaluru,Chennai,Pune,Kolkata,Ahmedabad,Mumbai,Hyderabad,Delhi NCR

Exp-

8-19 yrs