Senior Data Engineer MDM Data Vault

Forward Eye Technologies

Pune District

On-site

INR 1,200,000 - 1,800,000

Full time

8 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Forward Eye Technologies is seeking an experienced Data Engineer to design and implement DBT-based models and Data Vault 2.0 structures in a Snowflake data warehouse. You will work with data analysts, scientists, and business stakeholders to deliver robust data solutions.

The role requires 8+ years in data engineering, strong SQL and Python skills, and expertise in MDM and data warehousing concepts. Pune-based, on-site position with collaboration across cross-functional teams.

Qualifications

  • Minimum 8 years of experience in data engineering or related roles.
  • Proven expertise in DBT-based data modeling, testing, packaging and deployment.
  • Experience implementing Data Vault 2.0 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, Satellites for MDM.
  • Design, develop, and maintain Snowflake data structures for warehousing.
  • Create, debug, and optimize SQL procedures, functions, and views.
  • Develop Python scripts for automation and data quality checks.
  • Collaborate with analysts, scientists and stakeholders to deliver insights.

Skills

SQL programming
Python
Data Vault 2.0
DBT data modeling
MDM
Data Warehousing

Tools

DBT
Airflow
Snowflake

Job description

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
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer MDM Data Vault
Senior Data Engineer MDM Data Vault

Forward Eye Technologies • Dadri

On-site
INR 1,800,000 - 2,800,000
Lead Data Engineer
Lead Data Engineer

Qentelli LLC • Hyderabad

On-site
INR 3,500,000 - 5,500,000
Sr. Data Engineer with Data Vault Experience
Sr. Data Engineer with Data Vault Experience

Cittabase Solutions Pte Ltd • Chennai District

On-site
INR 1,200,000 - 1,800,000
Data Engineer (Snowflake, DBT, SQL)
Data Engineer (Snowflake, DBT, SQL)

VDart Software Services • Hyderabad, Pune District, Bengaluru

Hybrid
INR 1,000,000 - 2,000,000
Data Engineer & Data Vault
Data Engineer & Data Vault

Hitachi Digital Services, LLC • Hyderabad, Bengaluru

On-site
INR 1,500,000 - 2,500,000
Data Engineer (Snowflake & dbt)
Data Engineer (Snowflake & dbt)

Marlabs Inc. • Karnataka

On-site
INR 1,500,000 - 2,500,000
Data Engineer (Snowflake & dbt)
Data Engineer (Snowflake & dbt)

Marlabs • Bengaluru

On-site
INR 1,800,000 - 2,400,000
Data Engineer (Snowflake & dbt)
Data Engineer (Snowflake & dbt)

Marlabs Inc. • India

On-site
INR 1,200,000 - 1,800,000
Data Engineer & SQL Expert
Data Engineer & SQL Expert

PradeepIt Global Consulting Pvt Ltd. • Bengaluru

On-site
INR 800,000 - 1,200,000
Lead Data Engineer - R01571409
Lead Data Engineer - R01571409

Brillio • Bengaluru

On-site
INR 2,600,000 - 4,200,000