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