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