Senior Data Engineer - Snowflake/DBT/Matillion

Senior Data EngineerSnowflake - dbt - Matillion Data Productivity CloudLocations : Hyderabad / AhmedabadExperience : 5 - 8 YearsCompensation : 15,00,000 - 21,00,000 per annumWork Mode : 5 days work from office (no hybrid/remote)Joining : Immediate joiners preferred (max 15 days)Interview Process : 3 - 4 roundsAbout the Role : We are seeking a highly skilled and experienced Senior Data Engineer to join our growing data team. In this role, you will lead the design and implementation of scalable, high-performance data pipelines using Snowflake, dbt, and Matillion Data Productivity Cloud, define architectural best practices, and drive data transformation at scale. You will work closely with clients to translate business needs into robust data solutions and play a key role in mentoring junior engineers, enforcing standards, and delivering production-grade data platforms.Key Responsibilities : - Architect and implement modular, test-driven ELT pipelines using dbt and Matillion Data Productivity Cloud on Snowflake.- Design layered data models (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.- 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.- Build reusable Matillion pipelines, shared jobs, and orchestration flows on the Data Productivity Cloud, integrated with dbt transformations.- Orchestrate workflows using dbt Cloud, Matillion DPC, Airflow, or Azure Data Factory with CI/CD integration.- 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 and code reviews, and establish reusable frameworks across dbt, Matillion, and Snowflake.- Engage with clients to gather requirements, present solutions, and manage end-to-end project delivery in a consulting setup.Required Qualifications : 5-8 years of experience in data engineering, with : - 3+ years of hands-on Snowflake and dbt experience in production environments.- Demonstrable project experience with Matillion (Data Productivity Cloud or Matillion ETL).Technical Skills : 1. Cloud Data Warehouse & Transformation Stack : - Expert-level SQL and Snowflake : performance optimization, storage layers, query profiling, clustering, cost management.- dbt development : modular model design, macros, tests, documentation, version control via Git.- Matillion Data Productivity Cloud : Designer pipelines, orchestration jobs, transformation jobs, variables, shared jobs, Git-based project management.2. Orchestration & Integration : - Proficiency orchestrating workflows via dbt Cloud, Matillion DPC, Airflow, or Azure Data Factory.- Data ingestion from cloud storage (Azure Data Lake, AWS S3) and REST APIs using Matillion native connectors.3. Data Modelling & Architecture : - Dimensional modelling : Star/Snowflake schemas, slowly changing dimensions.- Medallion Architecture (Bronze/Silver/Gold) using Matillion for ingestion and dbt for downstream transformations.- Experience with Parquet, JSON, CSV, and other common data formats.4. Programming Languages : - Python - data transformation, notebook development, automation, and Matillion script components.- SQL - strong query and performance tuning skills.- Jinja - exposure for advanced dbt development (nice to have).5. Security & Governance : - Data quality checks using dbt tests and Matillion validation components.- Data encryption, secure key management, Snowflake RBAC, OAuth, and workspace/environment isolation.Soft Skills & Leadership : - Ability to thrive in client-facing roles with competing priorities and fast-paced delivery cycles.- Stakeholder communication - translate business objectives into actionable data engineering designs.- End-to-end project ownership including design, implementation, and monitoring.- Mentorship - guide junior engineers and establish best practices.- Agile practices - sprints, scrum ceremonies, story estimation.Education & Certifications : - Bachelor's or Master's degree in Computer Science, Data Engineering, or a related field.- Certifications (plus) : Snowflake SnowPro Advanced, dbt Certified Developer, Matillion Associate or Professional (Data Productivity Cloud).Screening Questionnaire : All submitted profiles must include answers to the following : - LinkedIn URL (mandatory - CV and LinkedIn tenure will be cross-verified).- Which clouds do you have hands-on experience with? (Hybrid/multi-cloud preferred.)- Communication skills rating out of 5.- Number of end-to-end projects where you led and mentored junior data engineers.- Experience with Matillion ETL or Matillion Data Productivity Cloud - specify which.- Years of hands-on experience with Snowflake and dbt (minimum 3-4 years required).Budget Note : Ahmedabad - up to 20 LPA | Hyderabad - up to 22 LPA (ref:hirist.tech)