Lead Snowflake Data Engineer

Atrium; Jaipur; On-site; INR 2,000,000 - 3,200,000; Full time

Job summary

Atrium in Jaipur, India, invites a Lead Snowflake Data Engineer to expand and optimize data pipelines for cross-functional teams. You will support developers, data architects, analysts and data scientists on data initiatives and ensure scalable delivery architecture.

The role requires a strong background in Snowflake, SQL, Python, Airflow, and DBT, plus hands-on experience with AWS and big data tools. You will mentor onshore and offshore teams, enforce data quality, design data models, and

Qualifications

• Bachelor's degree in Computer Science or Software Engineering.
• Experience delivering consulting services to enterprises.
• Strong data warehousing and Snowflake experience.
• Understanding of Data Vault methodologies.

Responsibilities

• Create and maintain optimal data pipeline architecture.
• Assemble large, complex data sets meeting functional/non-functional requirements.
• Identify, design, and implement internal process improvements for scalability.
• Lead and mentor onshore and offshore development teams.
• Build infrastructure for data extraction, transformation, and loading using SQL, DBT, Python, AWS, and Big Data tools.
• Develop ELT processes for timely data delivery to customers.
• Implement Data Quality measures for data accuracy and integrity.
• Design, implement, and maintain data models to support storage and analysis.
• Deliver technical and functional specifications to support data governance.

Skills

Team leadership

Data architecture

Problem-solving

Customer success mindset

Presentation skills

Education

Bachelor's degree in Computer Science or Software Engineering

SnowPro Core certification

Tools

Snowflake

SQL

Python

Airflow

DBT

AWS

Big Data tools

Docker

Job description

Are you ready for new challenges and new opportunities?

Join our team!

Current job opportunities are posted here as they become available.

Subscribe to our RSS feeds to receive instant updates as new positions become available.

Take your career to the next level with the only consulting firm born in AI and delivering with AI.

At Atrium, we’re not simply adapting to an AI-driven world — we’ve helped define it since we were founded. Our clients partner with us because we turn potential into measurable impact, reshaping industries, realizing exponential value, and empowering organizations to thrive in an era of unprecedented technological advancement.

As pioneers in AI-assisted delivery, we’re constantly optimizing how we deliver services for greater speed, accuracy, and efficiency. This commitment allows us to repeatedly deliver outcomes that other Salesforce and Snowflake partners merely promise. Care to join us?

Who are you?

You’re a smart collaborator who likes solving complex problems and takes ownership to get things done. You stay up to date with the latest and greatest in business and technology tools, platforms, and languages — and want to ensure your clients do too. You love working across teams and are enthusiastic about doing your part to ensure everyone succeeds.

As a Lead Snowflake Data Engineer, you will be responsible for expanding and optimizing the data and data pipeline architecture, as well as optimizing data flow and collection for cross‑functional teams. You will support the software developers, database architects, data analysts, and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.

In this role, you will:

• Create and maintain optimal data pipeline architecture.
• Assemble large, complex data sets that meet functional / non‑functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re‑designing infrastructure for greater scalability, etc.
• Lead and mentor both onshore and offshore development teams, creating a collaborative environment.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, DBT, Python, AWS, and Big Data tools.
• Development of ELT processes to ensure the timely delivery of required data for customers.
• Implement Data Quality measures to ensure accuracy, consistency, and integrity of data.
• Design, implement, and maintain data models that can support the organization's data storage and analysis needs.
• Deliver technical and functional specifications to support data governance and knowledge sharing.

In this role, you will have:

• Bachelor's degree in Computer Science, Software Engineering, or equivalent combination of relevant work experience and education
• 6+ years of experience delivering consulting services to medium and large enterprises. Implementations must have included a combination of the following experiences:
• Data Warehousing or Big Data consulting for mid-to-large-sized organizations
• Strong experience with Snowflake and Data Warehouse architecture
• Understanding of Data Vault Methodology
• Strong analytical skills with a thorough understanding of how to interpret customer business needs and translate those into a data architecture
• SnowPro Core certification is highly desired
• Hands‑on experience with Python (Pandas, Dataframes, Functions)
• Hands‑on experience with SQL (Stored Procedures, functions), including debugging, performance optimization, and database design
• Strong Experience with Apache Airflow and API integrations
• Solid experience in any one of the ETL/ELT tools (DBT, Coalesce, Wherescape, Mulesoft, Matillion, Talend, Informatica, SAP BODS, DataStage, Dell Boomi, etc.)
• Nice to have: Experience in Docker, DBT, data replication tools (SLT, Fivetran, Airbyte, HVR, Qlik, etc), Shell Scripting, Linux commands, AWS S3, or Big data technologies
• Strong project management, problem‑solving, and troubleshooting skills with the ability to exercise mature judgment
• Enthusiastic, professional, and confident team player with a strong focus on customer success who can present effectively even under adverse conditions
• Strong presentation and communication skills

Next steps

Our recruitment process is highly personalized. Some candidates complete the hiring process in one week, others may take longer as it’s important we find the right position for you. It's all about timing and can be a journey as we continue to learn about one another. We want to get to know you and encourage you to be selective - afterall, deciding to join a company is a big decision!

Atrium is an Equal Opportunity Employer. We evaluate every candidate on merit, regardless of gender, caste, religion, or disability status. In line with our Equal Opportunity Policy under the Rights of Persons with Disabilities Act, 2016, candidates with disabilities may request reasonable accommodations at any stage of the hiring process. To request an accommodation, reach out to us at [e-mail].