Subject matter expert

🚀 Job Opening: Senior Data Engineer- SME

📍 Location:

🕒 Type:

About the Role:

Senior Data Engineer

You’ll work across the full data stack—from ingestion and transformation to orchestration and delivery—playing a key role in scaling our analytics and reporting capabilities.

Responsibilities:

• Design and implement efficient, scalable

  ETL/ELT pipelines

  and

  data flows

• Develop transformation models using

  dbt

  and orchestrate pipelines via

  Airflow

• Optimize large-scale processing jobs in

  Apache Spark

• Tune and manage relational and analytical databases (

  PostgreSQL

  ,

  Snowflake

  )
• Architect and maintain schemas using

  Star Schema

  ,

  3NF

  , and

  SCD2

  methodologies
• Design and support

  lakehouse architectures

  and scalable storage solutions
• Implement and enforce

  data governance

  ,

  validation

  , and

  quality control

  mechanisms
• Maintain DevOps standards using

  CI/CD

  ,

  GitFlow

  , and

  containerization tools

  like

  Docker

  and

  Ansible

Requirements

• Advanced proficiency in

  SQL

  and

  ETL/ELT design

• Strong experience with

  dbt

  ,

  Airflow

  , and

  Spark

• Deep understanding of

  data modeling techniques

  (Star Schema, 3NF, SCD2)
• Proven ability to optimize and tune

  PostgreSQL

  and

  Snowflake

  for performance
• Familiarity with

  lakehouse architecture

  principles and tools
• Solid experience in

  data governance

  , validation frameworks, and pipeline monitoring
• Strong grasp of

  GitFlow

  ,

  CI/CD pipelines

  , and

  containerization

  (Docker/Ansible)
• Ability to work independently and collaborate across teams in a dynamic environment

Preferred Qualifications

• Hands-on experience with cloud platforms (AWS, GCP, Azure)
• Familiarity with IaC tools and DevOps best practices
• Experience working in regulated or enterprise environments with strict data governance policies

What We Offer

• Competitive salary and performance-based incentives
• Flexible working hours and remote-first culture
• Opportunity to shape and scale a modern data platform
• A collaborative, engineering-led environment where your voice matters
• [Include benefits like healthcare, equity, learning budgets, etc.]

Interested candidates kindly share your resumes on shikha@digifocal.in