Overview

We are seeking a highly skilled and experienced Data Engineer to join our growing data team.

Responsibilities

• Architect and implement modular, test-driven ELT pipelines using dbt and Matillion Data Productivity Cloud on Snowflake.
• Design layered data models (e.g., staging, intermediate, mart layers / medallion architecture) aligned with dbt and Matillion best practices.
• Lead ingestion of structured and semi-structured data from APIs, flat files, cloud storage (Azure Data Lake, AWS S3), and databases into Snowflake using Matillions native connectors and custom components where required.
• Optimize Snowflake for performance and cost : warehouse sizing, clustering, materializations, query profiling, and credit monitoring.
• Apply advanced dbt capabilities including macros, packages, custom tests, sources, exposures, and documentation using dbt docs.
• Build reusable Matillion pipelines, shared jobs, and orchestration flows on the Data Productivity Cloud, integrating them with dbt transformations for end-to-end data delivery.
• Orchestrate workflows using dbt Cloud, Matillion Data Productivity Cloud, Airflow, or Azure Data Factory, integrated with CI/CD pipelines.
• Define and enforce data governance and compliance practices using Snowflake RBAC, secure data sharing, and encryption strategies.
• Collaborate with analysts, data scientists, architects, and business stakeholders to deliver validated, business-ready data assets.
• Mentor junior engineers, lead architectural/code reviews, and help establish reusable frameworks and standards across dbt, Matillion, and Snowflake.
• Engage with clients to gather requirements, present solutions, and manage end-to-end project delivery in a consulting setup.

Qualifications

• 3 to 5 years of experience in data engineering roles, with 3 years of hands-on experience working with Snowflake and dbt in production environments, and demonstrable project experience with Matillion (Data Productivity Cloud or Matillion ETL).
• Cloud Data Warehouse &
• Transformation Stack :
• Expert-level knowledge of SQL and Snowflake, including performance optimization, storage layers, query profiling, clustering, and cost management.
• Hands-on experience with Matillion Data Productivity Cloud, including Designer pipelines, orchestration jobs, transformation jobs, variables, shared jobs, and Git-based project management.
• Orchestration and Integration :
• Proficiency in orchestrating workflows using dbt Cloud, Matillion Data Productivity Cloud, Airflow, or Azure Data Factory.
• Comfortable working with data ingestion from cloud storage (e.g., Azure Data Lake, AWS S3) and APIs, including building Matillion pipelines that consume REST APIs and leverage native SaaS connectors.
• Data Modelling and Architecture :
• Dimensional modelling (Star/Snowflake schemas), Slowly changing dimensions.
• Knowledge of modern data warehousing principles.
• Programming Languages :
• Jinja (nice to have) : Exposure to Jinja for advanced dbt development.
• Data Engineering &
• Analytical Skills :
• ETL/ELT pipeline design and optimization across dbt and Matillion.
• Exposure to AI/ML data pipelines, feature stores, or MLflow for model tracking (good to have).
• Exposure to data quality and validation frameworks.
• Security &
• Governance :
• Data encryption, secure key management, and security best practices for Snowflake, dbt, and Matillion (credential management, OAuth, workspace/environment isolation).
• Leadership
• Ability to thrive in client-facing roles with competing/changing priorities and fast-paced delivery cycles.
• Stakeholder Communication : Collaborate with business stakeholders to understand objectives and convert them into actionable data engineering designs.
• Project Ownership : End-to-end delivery including design, implementation, and monitoring.
• Mentorship : Guide junior engineers and establish best practices
• Build new skill in the team.
• Agile Practices : Work in sprints, participate in scrum ceremonies, story estimation.

Education

• Bachelors or masters degree in computer science, Data Engineering, or a related field.
• Certifications such as Snowflake SnowPro Advanced, dbt Certified Developer, and Matillion Associate or Professional Certification (Data Productivity Cloud) are a plus.
• Work on modern data architecture at scale using cutting-edge technologies alongside best-in-class tools like Snowflake, dbt, and Matillion Data Productivity Cloud.
• Collaborate with a dynamic and talented team of data professionals.
• Grow your leadership skills through hands-on project ownership and mentorship.
• Competitive compensation, flexible work options, and continuous learning culture.
• This is 5 days work from office role.
• Interview process : 3-4 rounds in the process.