Data Engineer ( Snowflak and DBT)

Required Qualifications

• 3 to 5 years of experience in data engineering roles, with 2+ years of hands-on experience in Snowflake and DBT or Matillion (Matillion-DPC is highly preferred, not mandatory

Experience building and deploying DBT models in a production environment.

Expert-level SQL and strong understanding of ELT principles. Strong understanding of ELT patterns and data modelling (Kimball/Dimensional preferred).

• Familiarity with data quality and validation techniques: dbt tests, dbt docs etc.

Experience with Git, CI/CD, and deployment workflows in a team setting

Familiarity with orchestrating workflows using tools like dbt Cloud, Airflow, or Azure Data Factory.
Core Competencies:

o Data Engineering and ELT Development:

• Building robust and modular data pipelines using dbt.
• Writing efficient SQL for data transformation and performance tuning in Snowflake.
• Managing environments, sources, and deployment pipelines in dbt.

o Cloud Data Platform Expertise:

• Strong proficiency with Snowflake: warehouse sizing, query profiling, data loading, and performance optimization.
• Experience working with cloud storage (Azure Data Lake, AWS S3, or GCS) for ingestion and external stages.

'

Technical Toolset:

o Languages & Frameworks:

• Python: For data transformation, notebook development, automation.
• SQL: Strong grasp of SQL for querying and performance tuning.

Best Practices and Standards:

o Knowledge of modern data architecture concepts including layered architecture (e.g., staging → intermediate → marts, Matillion architecture).

Familiarity with data quality, unit testing (dbt tests), and documentation (dbt docs).

Security & Governance:

o Access and Permissions:

• Understanding of access control within Snowflake (RBAC), role hierarchies, and secure data handling.
• Familiar with data privacy policies (GDPR basics), encryption at rest/in transit.

Deployment & Monitoring:

o DevOps and Automation:

• Version control using Git, experience with CI/CD practices in a data context.
• Monitoring and logging of pipeline executions, alerting on failures.

Soft Skills:

o Communication & Collaboration:

• Ability to present solutions and handle client demos/discussions.
• Work closely with onshore and offshore team of analysts, data scientists, and architects.
• Ability to document pipelines and transformations clearly.
• Basic Agile/Scrum familiarity – working in sprints and logging tasks.
• Comfort with ambiguity, competing priorities and fast-changing client environment.

Education:

o Bachelor’s or master’s degree in computer science, Data Engineering, or a related field.

o Certifications such as Snowflake SnowPro, dbt Certified Developer Data Engineering are a plus.

Please note the mandatory or most preferred skill set for this role

• Must have experience in Snowflake
• Must have experience in DBT or Matillion (Matillion-DPC is highly preferred)
• Must have experience in SSIS

Job Type: Full-time

Pay: ₹516,021.65 - ₹1,873,637.25 per year

Work Location: In person