Senior Data Engineer

Techment

Indore

Hybrid

INR 2,400,000 - 4,200,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Techment in Indore, India is seeking a Senior Data Engineer with 6+ years of experience to design and maintain data transformation pipelines on Snowflake using Coalesce. You will build dimensional models, implement SCDs, and enable AI-assisted development for faster delivery of BI and AI-ready data products.

You will work with Fivetran for ingestion, leverage AI tools like Snowflake CoCo and Copilot, and contribute to CI/CD while ensuring data quality, performance, and reliability across CURATE

Qualifications

  • 6+ years of experience in Data Engineering with hands-on work on modern cloud data platforms.
  • Strong hands-on experience with Coalesce, including production-grade transformation pipelines.
  • Strong expertise in Snowflake, including advanced SQL development and performance optimization.
  • Experience with AI-assisted development tools such as Snowflake CoCo, Claude, Cursor, or GitHub Copilot.
  • Experience with Fivetran or similar data ingestion tools.
  • Strong understanding of dimensional data modeling and Kimball methodology.
  • Experience with Apache Airflow for workflow orchestration.
  • Knowledge of data quality frameworks, testing, validation, and reconciliation.
  • Working knowledge of PostgreSQL.
  • Experience with Snowflake administration, RBAC, warehouses, and cost optimization.
  • Hands-on experience with Git, version control, and CI/CD for data engineering workflows.
  • Excellent written and verbal communication skills.
  • Ability to work independently and collaborate with globally distributed teams.

Responsibilities

  • Design, develop, and maintain data transformation pipelines using Coalesce and Snowflake across CURATE and PUBLISH layers.
  • Build dimensional data models, including fact and dimension tables with SCD following Kimball methodology.
  • Develop reusable data models to support reporting, analytics, and AI use cases.
  • Leverage AI tools for pipeline development, testing, refactoring, and documentation.
  • Maintain RAW data ingestion pipelines using Fivetran.
  • Write optimized SQL queries with incremental and full-refresh patterns.
  • Implement automated data quality checks and reconciliation processes.
  • Schedule and orchestrate workflows using Apache Airflow and Coalesce.
  • Establish monitoring, alerts, and runbooks for pipeline reliability.
  • Support CI/CD with Git version control, branching and deployments across DEV/QA/EARLY_ACCESS/PROD.
  • Perform Snowflake administration including RBAC, warehouses, and cost control.
  • Participate in Kanban delivery, daily stand-ups, backlog prioritization, and demonstrations.
  • Review AI-generated code for accuracy, performance, and maintainability.
  • Communicate project progress, risks, and dependencies clearly.

Skills

Coalesce
Snowflake
AI-assisted development
SQL development
Airflow
Git/CICD
RBAC & admin
PostgreSQL
Dimensional modeling
Data quality

Tools

Fivetran
Snowflake CoCo
Claude
Cursor
GitHub Copilot

Job description

Job Title: Senior Data Engineer
Experience: 6+ Years
Location: indore
Work Shift: 1:30PM 10:30PM IST

About the Role

We are looking for an experienced Senior Data Engineer with strong hands-on expertise in Coalesce and Snowflake, along with practical experience in AI-assisted development. The organization operates a modern Snowflake-based data platform with a governed RAW, CURATE, and PUBLISH (Medallion) architecture built using Coalesce. With the migration from the legacy platform completed, the focus is now on developing new data models, expanding the CURATE and PUBLISH layers, optimizing existing pipelines, and delivering production-ready data products for BI and AI use cases. The ideal candidate should have strong technical expertise, the ability to work independently, and experience leveraging AI coding tools to accelerate development while maintaining code quality, performance, and reliability.

Key Responsibilities
  • Design, develop, and maintain data transformation pipelines using Coalesce and Snowflake across CURATE and PUBLISH layers.
  • Build dimensional data models, including fact tables, dimension tables, and Slowly Changing Dimensions (SCD), following Kimball methodology.
  • Develop reusable and conformed data models to support reporting, analytics, and AI use cases.
  • Leverage AI-assisted development tools such as Snowflake CoCo, Claude, Cursor, and GitHub Copilot for pipeline development, testing, refactoring, and documentation.
  • Maintain data ingestion processes into the RAW layer using Fivetran.
  • Write optimized, scalable, and well-tested SQL queries, including incremental and full-refresh load patterns.
  • Implement automated data quality checks, validation, and reconciliation processes.
  • Schedule and orchestrate workflows using Apache Airflow and Coalesce.
  • Establish monitoring, alerting, and operational runbooks to ensure pipeline reliability.
  • Support CI/CD processes using Git-based version control, branching strategies, code reviews, and deployments across DEV, QA, EARLY_ACCESS, and PROD environments.
  • Perform Snowflake administration activities, including role-based access control (RBAC), warehouse management, resource monitors, databases, and schemas.
  • Participate in Kanban-based delivery processes, including daily stand-ups, backlog prioritization, continuous delivery, and regular demonstrations.
  • Review and validate AI-generated code to ensure accuracy, performance, maintainability, and adherence to engineering standards.
  • Ability to use AI development tools responsibly while ensuring all generated code is reviewed, tested, and validated.
  • Proactive communication regarding project progress, risks, and dependencies.
  • Ability to maintain clear technical documentation and develop clean, reusable, and maintainable code.
Required Qualifications
  • 6+ years of experience in Data Engineering, with recent hands-on experience in modern cloud data platforms.
  • Strong hands-on experience with Coalesce, including developing and maintaining production-grade transformation pipelines.
  • Strong expertise in Snowflake, including advanced SQL development and query performance optimization.
  • Practical experience using AI-assisted development tools such as Snowflake CoCo, Claude, Cursor, or GitHub Copilot.
  • Experience with Fivetran or similar managed data ingestion tools.
  • Strong understanding of dimensional data modeling and Kimball methodology.
  • Experience with Apache Airflow for workflow orchestration.
  • Strong knowledge of data quality frameworks, testing, validation, and reconciliation.
  • Working knowledge of PostgreSQL.
  • Experience with Snowflake administration, including RBAC, warehouses, resource monitors, and cost optimization.
  • Hands-on experience with Git, version control, and CI/CD for data engineering workflows.
  • Excellent written and verbal communication skills.
  • Ability to work independently and collaborate effectively with globally distributed teams.
Good to Have
  • Experience with BI tools such as Tableau or Sigma.
  • Exposure to Azure cloud services.
  • Familiarity with Master Data Management (MDM) concepts or platforms such as Semarchy.
  • Experience with Infrastructure as Code (IaC) for data platform provisioning.
  • Experience designing AI-ready data models for advanced analytics and AI applications.
Work Expectations
  • Comfortable working in a Kanban-based, continuous delivery environment.
  • Ability to collaborate with US-based Product Owners and Architecture Leads.
  • Willingness to maintain a minimum of 4 hours of overlap with US Central business hours.
First 90 Days Expected Deliverables
  • Gain a strong understanding of the existing Snowflake environment, Coalesce workspaces, and development standards.
  • Independently deliver new CURATE and PUBLISH data products from the prioritized backlog.
  • Implement appropriate data quality checks and validation processes.
  • Integrate AI-assisted development tools into the regular engineering workflow while maintaining code quality.
About Us

Techment is an innovative software solution provider that empowers enterprises with cutting-edge technology solutions. We are a fast-growing IT firm venturing into AI, data engineering, cloud data warehousing, and process automation. Headquartered in Bhilai, Techment has a successful track record of 10+ years. We have a team of passionate techno-functional experts that work as an extension of client teams. Our clientele is based in the US, and we are continuously expanding our global footprints in Texas. For more information, please log on to www.techment.com

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Engineer
Snowflake Engineer

Persistent Systems • Pune

Hybrid
INR 1,200,000 - 2,100,000
Competitive salary
Hybrid work model
Career development & certifications
+2
Senior Data Engineer- Snowflake
Senior Data Engineer- Snowflake

Squareshift • Chennai District

On-site
INR 1,200,000 - 1,800,000
Sr. Data Engineer (India- Remote)
Sr. Data Engineer (India- Remote)

CloudLabs Inc • India

Remote
INR 3,000,000 - 5,000,000
Remote work option
Competitive pay
Medical insurance
+1
Data Engineer
Data Engineer

Capestart Inc. • Chennai

On-site
INR 900,000 - 1,400,000
Data Engineer (India-Remote)
Data Engineer (India-Remote)

CloudLabs Inc • India

Remote
INR 1,800,000 - 3,200,000
Reentry support
Competitive pay
Medical insurance
+2
Data Engineer
Data Engineer

CapeStart • Nagercoil, Chennai

On-site
INR 900,000 - 1,300,000
Lead Snowflake Data Engineer
Lead Snowflake Data Engineer

VMC Soft Technologies • Bengaluru Urban

On-site
INR 1,500,000 - 2,700,000
SENIOR DATA ENGINEER-AZURE AND SNOWFLAKE IMMEDIATE JOINERS
SENIOR DATA ENGINEER-AZURE AND SNOWFLAKE IMMEDIATE JOINERS

Phigital Care • Bengaluru

On-site
INR 1,200,000 - 1,800,000
Data Engineer - Snowflake &Python
Data Engineer - Snowflake &Python

VMC Soft Technologies • Bengaluru

On-site
INR 1,800,000 - 2,400,000
Data Engineering Manager
Data Engineering Manager

Experity • Bengaluru

On-site
INR 4,000,000 - 7,000,000