Senior Data Engineer MDM Data Vault

Job Responsibilities :

MDM Data Vault Design and Development :

- 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).

Data Warehousing :

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

SQL Development :

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

Python Scripting and Automation :

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

Data Quality Assurance :

- Implement data quality checks and processes to validate and cleanse data, ensuring integrity and accuracy.

- Identify and resolve data anomalies and inconsistencies proactively.

Collaboration and Stakeholder Engagement :

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

Experience :

- 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