Snowflake Lead

Sr. Data Engineer 

Location: Pune

Responsibilities 

· Lead the end-to-end design and development of scalable, high-performance data pipelines and ETL/ELT frameworks aligned with modern data engineering best practices. 

· Architect complex data integration workflows that bring together structured, semi-structured, and unstructured data from both cloud and on-premise sources. 

· Build robust real-time, batch, and on-demand pipelines with built-in observability—monitoring, alerting, and automated error handling. 

· Partner with analysts, data scientists, and business leaders to define and deliver reliable data models, quality frameworks, and SLAs that power key business insights. 

· Ensure optimal pipeline performance and throughput, with clearly defined SLAs and proactive alerting for data delivery or quality issues. 

· Collaborate with platform, DevOps, and architecture teams to build secure, reusable, and CI/CD-enabled data workflows that align with enterprise architecture standards. 

· Establish and enforce the best practices in source control, code reviews, testing automation, and continuous delivery for all data engineering components. 

· Lead root cause analysis (RCA) and preventive maintenance for critical data failures, ensuring minimal business impact and continuous service improvement. 

· Guide the team in establishing standards for data modeling, transformation logic, and governance, ensuring long-term maintainability and scalability. 

· Design and execute comprehensive testing strategies—unit, integration, and system testing—ensuring high data reliability and pipeline resilience. 

· Monitor and fine-tune data pipeline and query performance, optimizing for reliability, scalability, and cost-efficiency. 

· Create and maintain detailed technical documentation, including data architecture diagrams, process flows, and integration specifications for internal and external stakeholders. 

· Facilitate and lead discussions with business and operational teams to understand data requirements, prioritize initiatives, and drive data strategy forward. 

Qualifications 

· 7 to 10 years of hands-on experience in data engineering roles with a proven record of building scalable and secure data platforms. 

· Over 5 years of experience in scripting languages such as Python for data processing, automation, and ETL development. 

· 4+ years of experience with Snowflake, including performance tuning, security model design, and advanced SQL development. 

· 5+ years of experience with data integration tools such as Azure Data Factory, Fivetran, or Matillion. 

· 5+ years of experience in writing complex, highly optimized SQL queries on large datasets. 

· Proven experience integrating and managing APIs, JSON, XML, and webhooks for data acquisition. 

· Hands-on experience with cloud platforms (Azure/AWS) and orchestration tools like Apache Airflow or equivalent. 

· Experience with CI/CD pipelines, automated testing, and code versioning tools (e.g., Git). 

· Familiarity with dbt or similar transformation tools and best practices for modular transformation development. 

· Exposure to data visualization tools like Power BI for supporting downstream analytics is a plus. 

· Strong interpersonal and communication skills with the ability to lead discussions with technical and business stakeholders. 

Education 

Bachelor’s or Master’s degree in Computer Science/Information technology or related field. 

Equivalent academic and work experience can be considered. 

About the Role

You'll be at the forefront of designing and implementing robust data platform solutions that power advanced analytics, AI, and machine learning. Working with modern cloud technologies, you'll build scalable data foundations that enable clients to make smarter, data-driven decisions.

Key Responsibilities

• Build scalable data pipelines using Snowflake, AWS, GCP, and Databricks.
• Design and optimize data models for AI and machine learning workloads.
• Develop reliable data foundations for MLOps, governance, and data lineage.
• Integrate data from multiple sources into modern data platforms.
• Leverage Snowpark ML and Snowflake's native AI capabilities.
• Ensure data platforms are secure, scalable, and high-performing.

What We're Looking For

• 5+ years of hands-on experience with Snowflake.
• Strong proficiency in SQL and Python.
• Experience with AWS, Azure, or GCP.
• Knowledge of cloud storage services such as S3, ADLS, or GCS.
• Strong understanding of Dimensional Modeling and Data Vault.
• Experience with Scala or Java is a plus.

Tech Stack

• Data Warehouse: Snowflake
• Programming: SQL, Python, Scala (Good to Have), Java (Good to Have)
• Cloud: AWS, Azure, GCP
• Storage: S3, ADLS, GCS
• AI/ML: Snowpark ML, MLOps

Perks & Benefits

• Public Speaking & Communication Program
• Mentoring Program with Senior Support Leads
• 360° Progress Reviews
• Weekly Learning Sessions & Guilds
• Paid Certifications
• Hackathons & Innovation Days
• Recognition & Rewards Programs
• Team Socials & Annual Offsites
• Employee Assistance Program (24/7 Wellbeing Support)

The Data People Shaping Tomorrow

Our client helps organizations unlock the power of data through modern cloud, analytics, and AI solutions. We believe in creating an environment where talented technologists can learn, innovate, and make a real impact while building cutting-edge data platforms for global clients. If you're passionate about data engineering and want to work with the latest technologies in AI, cloud, and analytics, we'd love to hear from you.

Technical Lead 

Job Description 

Role Overview 

We are seeking a highly skilled Data Engineering Lead with minimum of 5 years of hands-on experience in Azure data engineering, data warehousing, and automation-driven  integration. The ideal candidate should be a proven technical lead, capable of driving end-to-end 

project delivery and working closely with customer teams. This is a Work from Office / Customer Site role. 

Roles and Responsibilities 

• Lead the design, development, and delivery of data engineering and automation projects. 

• Architect and implement ETL/ELT pipelines using Azure Data Factory. 

• Design and manage enterprise data warehouses including dimensional modeling and 

schema optimization. 

• Manage Azure components including Storage Accounts, Data Lakes, Azure SQL, and Synapse. 

• Drive automation initiatives across data ingestion and transformation workflows. 

• Collaborate with business and technical stakeholders to translate requirements into scalable solutions. 

• Mentor team members and enforce engineering best practices. 

• Serve as the technical anchor responsible for ensuring high-quality, on-time delivery. 

Skills and Qualification 

• Strong hands-on experience with Azure Data Factory, Azure Storage, Azure SQL/Synapse. 

• Deep understanding of data warehousing concepts: star/snowflake schemas, fact/dimension modeling. 

• Experience with automation-led data engineering solutions. 

• Strong troubleshooting, optimization, and analytical skills. 

• Excellent communication and stakeholder management abilities. 

• Proven experience as a Technical Lead leading teams and delivery. 

Must Have 

• Min of 5 years of relevant data engineering experience. 

• Strong Azure Data Engineering and Data Warehousing expertise. 

• Proven Technical Lead experience. 

• Ability to work from office and customer site. 

• Strong ownership mindset with a focus on quality and delivery excellence.

SENIOR DATA ENGINEER – DATABRICKS & SNOWFLAKE

Experience: 7+ Years

Location: Remote

Employment Type: Full-Time

Budget: Up to ₹30 LPA

Time Zone: US Eastern Time (ET)

Shift: US ET Night Shift

Job Description

We are looking for an experienced Senior Data Engineer with strong expertise in Databricks, Snowflake, Apache Spark, and AWS to design, develop, and maintain scalable data engineering solutions.

The candidate will work on integrating data from multiple sources, building modern data pipelines, developing enterprise data models, and preparing data platforms for AI/ML applications.

Experience in healthcare, scientific data, or the histopathology domain will be an added advantage.

Key Responsibilities

• Design, build, and maintain scalable data pipelines to acquire, integrate, and manage data from diverse sources such as laboratory systems, MES, clinical supply, quality systems, and external partners.
• Develop and optimize data workflows for structured and unstructured data using Python, PySpark, R, SQL, Databricks, and Snowflake.
• Design and maintain enterprise-level data models and data repositories.
• Perform ETL development, data warehousing, database design, and data integration.
• Ensure data quality, versioning, traceability, and consistency to support AI/ML readiness.
• Collaborate with stakeholders and technical teams to translate business requirements into technical solutions.
• Manage multiple projects while ensuring scalability, performance, and reliability.

Required Skills

• 7+ years of experience in Data Engineering.
• Strong hands-on experience with Databricks and Snowflake.
• Excellent knowledge of Apache Spark / PySpark.
• Strong experience with AWS cloud services and AWS RDS.
• Experience with Oracle and Microsoft SQL Server (MSSQL).
• Proficiency in Python, R, and SQL.
• Strong understanding of ETL, Data Warehousing (DWH), data modeling, and database design.
• Experience with dbt and cloud-based data architectures.
• Knowledge of NoSQL and graph databases.
• Strong analytical, problem-solving, and stakeholder-management skills.
• Good English communication skills (B2 level or above).
• Willingness to work in the US Eastern Time (ET) night shift.

Preferred / Good to Have

• Experience in histopathology, healthcare, life sciences, or scientific data environments.
• Knowledge of CDISC, HL7, FHIR, OMOP, DICOM, or other regulated data standards.
• Experience handling high-dimensional data, including imaging and sensor data.
• Familiarity with MLOps and machine learning model deployment workflows.
• Knowledge of Manufacturing Execution Systems (MES) and Laboratory Information Management Systems (LIMS).
• Exposure to knowledge graphs and ontology-driven architectures.

Education

Bachelor's degree in Engineering, Data Science, Life Sciences, Computer Science, or a related field. A master's degree is preferred.

Interested candidates can apply with their updated resumes.

Lead Data Engineer – Databricks & Azure

• We are looking for a Lead Data Engineer with 5–7 years of experience in Azure, Databricks, and Microsoft Fabric to lead and mentor the data engineering team. The role involves implementing scalable data solutions using Databricks as the core platform, building modern data pipelines, and enabling seamless integration with Microsoft Fabric and Power BI.

Responsibilities & Requirements:

• Lead and mentor data engineers while driving hands-on technical delivery.
• Implement approved Databricks and Microsoft Fabric architectures and solutions.
• Develop metadata-driven bronze, silver, and gold data pipelines.
• Build reusable batch, incremental, CDC, and streaming ingestion pipelines.
• Strong hands-on experience with Azure Databricks, PySpark, SQL, and Delta Lake.
• Experience with Microsoft Fabric, OneLake, Direct Lake, and Power BI integration.
• Implement data quality checks, reconciliation, source-to-target mapping, and metadata management.
• Configure Unity Catalog for data governance, access control, auditing, and lineage.
• Implement CI/CD, automated deployments, and Datadog monitoring.
• Drive testing, documentation, operational readiness, and knowledge transfer.

Good to have:

• Experience with MDM and master data integration.
• Exposure to Azure DevOps or GitHub Actions.
• Experience with automated data testing and reconciliation frameworks.
• Experience working with onshore stakeholders and distributed engineering teams.
• Strong communication, problem-solving, and team leadership skills.

Job Description: Associate Director-Data Engineering (Databricks Lakehouse Architect + Cloud Data Engineering Leader)

About our Client -

Client is a leading SAP consulting and digital transformation partner committed to delivering innovative, high-impact solutions across enterprise analytics, cloud, and intelligent business platforms.

As enterprises modernize their data landscapes, the role of traditional data warehousing is rapidly evolving into scalable cloud-native Data Lakehouse architectures. Applexus is expanding its modern data engineering capabilities to help customers integrate enterprise data from SAP and non-SAP ecosystems, build advanced analytics platforms, and enable future-ready AI-driven solutions.

We are looking for an accomplished Databricks Lakehouse Architect / Cloud Data Engineering Leader who can play a key role in this transformation journey — designing modern data platforms, leading cloud data engineering initiatives, and bridging enterprise analytics with next-generation technologies.

The ideal candidate will combine strong hands-on expertise in Databricks, Spark/PySpark, Delta Lake, and Azure/AWS cloud platforms with the ability to engage customers, architect solutions, guide engineering teams, and drive successful delivery.

Role Overview:

We are looking for a hands-on Data Engineering leader who can architect modern cloud data platforms using Databricks Lakehouse and lead solution design, delivery, and engineering teams. This role requires strong technical ownership rather than a pure people management background.

Key Responsibilities:

• Architect scalable Data Lakehouse platforms

• Own solution design, estimation, architecture reviews and client discussions

• Build and optimize enterprise data pipelines

• Provide technical guidance to data engineering teams

• Establish best practices around performance, governance and architecture

Must Have - Databricks Architecture:

• Databricks Lakehouse design

• Delta Lake implementation

• Apache Spark / PySpark engineering

• Medallion architecture (Bronze/Silver/Gold layers)

• Data pipeline optimization

• Unity Catalog and data governance exposure

Cloud Platform Expertise (depth in one required):

Microsoft Azure:

• Azure Databricks

• Azure Data Factory (ADF)

• Azure Data Lake Storage (ADLS)

• Azure Synapse Analytics

OR

Amazon AWS:

• Databricks on AWS

• Amazon S3

• AWS Glue

• Redshift

• Athena

Good to Have:

• Snowflake

• ML Engineering exposure

• Cloud/Data Engineering certifications

Ideal Candidate:

A hands-on architect who can talk to customers, design solutions, estimate projects, guide engineers and review architecture while helping build a modern Data Engineering practice.

 We are looking for an accomplished Databricks Lakehouse Architect / Cloud Data Engineering Leader who can play a key role in this transformation journey — designing modern data platforms, leading cloud data engineering initiatives, and bridging enterprise analytics with next-generation technologies.

The ideal candidate will combine strong hands-on expertise in Databricks, Spark/PySpark, Delta Lake, and Azure/AWS cloud platforms with the ability to engage customers, architect solutions, guide engineering teams, and drive successful delivery.

If you are a hands-on Data Architect who enjoys building modern data platforms and wants to move beyond execution into solution ownership and leadership, I would love to connect.

Job Title: Senior Data Engineer

Position Summary

We are seeking a highly skilled Data Engineer with strong expertise in reporting infrastructure, data modeling, and analytics platforms. This role will focus on building scalable reporting solutions, optimizing data pipelines, and enabling data-driven decision-making across the organization. The ideal candidate will have deep experience with databases, data warehousing, and complex query development. While Ruby on Rails experience is beneficial, the primary emphasis is on data engineering and reporting systems.

Key Responsibilities

• Design, develop, and maintain reporting infrastructure and data platforms.
• Build and optimize complex SQL queries, data models, and reporting datasets.
• Develop scalable ETL/ELT pipelines and data integration processes.
• Design and maintain database schemas to support analytics and reporting requirements.
• Collaborate with business stakeholders to understand reporting needs and translate them into technical solutions.
• Implement data quality, governance, and performance best practices.
• Support and enhance enterprise reporting solutions and dashboards.
• Work with large-scale datasets in cloud data warehouse environments.
• Troubleshoot reporting issues and optimize database performance.
• Partner with engineering and product teams to establish sustainable data architecture.

Must Have: Technical Skills

• PostgreSQL
• Snowflake
• Advanced SQL
• Data Modeling
• Data Warehousing
• Reporting & Analytics Infrastructure
• ETL/ELT Development
• Query Performance Tuning

Success Profile:

The ideal candidate is a data-focused engineer who enjoys working with complex datasets, designing scalable reporting solutions, and building foundational infrastructure that empowers analytics and business intelligence teams. They should be comfortable navigating databases, optimizing queries, and translating business reporting needs into robust technical implementations.

Experience Range: 5-10 years

Role Type: Individual Contributor / Senior Engineer

Primary Focus: Reporting Infrastructure, Data Engineering, Data Warehousing, and Analytics Enablement.

Job Title : Tech Lead – Data Lake Platform

Number of Positions : 2

Experience : 7+ Years

Role Type : Technical Lead / Data Platform Lead

Domain : Data Engineering / Data Platform / AWS

About the Role :

We are looking for an experienced Tech Lead – Data Lake Platform to lead the design, development, and operations of an enterprise-scale AWS-based Data Lake Platform.

The platform will ingest data from multiple business systems, process it through structured data layers, and serve data for analytics, reporting, APIs, and operational applications.

As a Tech Lead, you will be responsible for setting the technical direction, leading data engineering teams, driving platform reliability and performance, and owning the platform's delivery, governance, and production support end to end.

Core Tech Stack :

AWS | S3 | EMR | Glue | Athena | Redshift | DMS | Lambda | RDS | IAM | Airflow | Spark/PySpark | SQL | Data Modeling | Hasura | GraphQL | DBT | PostgreSQL/Aurora | Kafka

Key Responsibilities :

• Own the overall Data Lake Platform architecture, covering data ingestion, staging, curated layers, consumption, analytics, and API/data serving.
• Lead the design and development of production-grade data pipelines using AWS Glue, EMR/Spark, Airflow, DBT, Athena, and Redshift.
• Design scalable batch and analytics pipelines with a focus on reliability, performance, data quality, and maintainability.
• Own the API/data-serving architecture from consumption data → RDS/PostgreSQL → Hasura GraphQL → Lambda/API Gateway.
• Drive improvements in platform stability, including orchestration failures, cluster sizing, pipeline SLAs, query performance, and production reliability.
• Design and implement appropriate AWS security, access control, IAM, PII handling, and data governance practices.
• Lead technical discussions, architecture decisions, code reviews, and engineering best practices.
• Mentor and guide data engineers while ensuring high-quality and scalable engineering delivery.
• Own production support, incident management, troubleshooting, and root-cause analysis (RCA) for critical data platform issues.
• Develop and maintain runbooks, operational procedures, monitoring, and incident response practices.
• Collaborate with business, product, application, and analytics teams to onboard new datasets and support reporting, API, and data consumption requirements.
• Ensure the platform meets defined availability, performance, security, data quality, and compliance requirements.

Must-Have Skills :

• 7+ years of experience in Data Engineering, Data Platform Engineering, or related areas, including experience in technical leadership or architecture.
• Strong hands-on experience with AWS Data Services, including:
• Amazon S3
• AWS EMR
• AWS Glue
• Amazon Athena
• Amazon Redshift
• AWS DMS
• AWS Lambda
• Amazon RDS
• AWS IAM
• Strong production experience with Apache Airflow.
• Strong hands-on experience with Apache Spark / PySpark.
• Strong SQL skills and experience with data modeling, including layered data architecture, data marts, and enterprise data models.
• Experience with Hasura or a similar GraphQL layer for PostgreSQL-based data/API serving.
• Strong understanding of data lake architecture and enterprise data platforms.
• Proven experience leading engineers and driving technical decisions.
• Hands-on experience with production support, troubleshooting, incident management, and RCA.
• Strong understanding of data platform performance, scalability, reliability, and SLA management.

Good-to-Have Skills :

• Experience with DBT and modern data transformation practices.
• Experience with lakehouse table formats on Amazon S3, such as Apache Iceberg or similar technologies.
• Strong knowledge of Amazon Redshift workload optimization, including :
• Distribution keys
• Sort keys
• Spectrum
• External tables
• Experience with Kafka or other streaming/data ingestion technologies.
• Experience with PostgreSQL / Amazon Aurora as a data-serving layer.
• Experience with Lambda and API Gateway for API-based data serving.
• Experience with enterprise data governance, data quality, security, and compliance.
• Experience in BFSI / Banking / Financial Services / Insurance domain.

Ideal Candidate :

The ideal candidate is a hands-on Data Platform / Data Engineering Lead who can operate at both the architecture and implementation level. You should be comfortable designing an AWS Data Lake from end to end, leading engineers, troubleshooting production issues, and working closely with business and application teams to deliver reliable data products.

Responsibilities and JD

Job Description: We are looking for a Senior Developer with strong expertise in PySpark, Databricks, and Snowflake to build scalable data engineering solutions and enterprise data platforms.

Key Responsibilities:

1. Design, develop, and maintain ETL/ELT pipelines using PySpark, Databricks, and Snowflake.
2. Develop batch and real-time data processing solutions for structured and semi-structured data.
3. Build and optimize Databricks notebooks, workflows, and Delta Lake solutions.
4. Design and implement Snowflake databases, schemas, views, stored procedures, tasks, and streams.
5. Develop scalable data models, data marts, and data warehouse solutions.
6. Optimize PySpark jobs, Databricks workloads, and Snowflake queries for performance and cost efficiency.
7. Implement data quality, validation, governance, and security controls.
8. Collaborate with business stakeholders, architects, and cross-functional teams to deliver data solutions.
9. Manage source control and CI/CD deployments using Git and Azure DevOps.
10. Troubleshoot production issues, perform root cause analysis, and ensure pipeline reliability.
11. Mentor junior team members and participate in code reviews and technical design discussions.

Required Skills: PySpark, Databricks, Snowflake, Python, SQL.

Experience: 5+ years of Data Engineering experience with strong hands-on expertise in PySpark, Databricks, and Snowflake.

Position: Technical Architect – Data Engineering

Job Summary:

• We are looking for an experienced Technical Architect to lead the design and implementation of modern cloud-based data platforms.
• The ideal candidate should have strong expertise in Azure and/or AWS, Databricks, Snowflake, modern data architecture, and large-scale data engineering.
• The candidate will work closely with business stakeholders, architects, and engineering teams to deliver scalable, secure, and high-performance data solutions.

Key Responsibilities

• Design enterprise-scale data lakehouse and data warehouse architectures.

• Define data ingestion, transformation, and serving architecture.

• Lead architecture discussions and technical governance.

• Design scalable ETL/ELT frameworks using Databricks and Snowflake.

• Define best practices for security, performance, CI/CD, and DevOps.

• Guide engineering teams on implementation.

• Collaborate with business, product, and data governance teams.

Must Have Skills :

• Azure or AWS

• Databricks

• Snowflake

• Data Lakehouse Architecture

• PySpark

• SQL

• Data Modelling

• ETL/ELT Architecture

• Performance Optimization

• CI/CD

• Terraform or Infrastructure as Code (preferred)

Preferred

• Insurance domain

• dbt

• Unity Catalog

• Delta Lake

• Iceberg

• Azure Data Factory / AWS Glue