Time since we first saw it
Day 172
Up longer than most. Similar jobs usually come down between day 6 and day 56.
From 14,766 similar postings that came down. Coming down is not always a hire.
Pune, India
Open 5 months, first seen by us 172 days agoWork setup in the employer’s posting: On-siteFrom the employer’s posting
Employment type in the employer’s posting: Full timeFrom the employer’s posting
Design and implement scalable Snowflake architectures with multi-cluster virtual warehouses
Build CDC-based incremental ELT pipelines using Streams & Tasks and Snowpipe
Design dimensional data models (star and snowflake schemas) for BI tools
Analyse query profiles and tune performance and warehouse cost
Build analytics-ready datasets with BI developers and support dashboard performance
Design and implement scalable Snowflake architectures leveraging multi-cluster Virtual Warehouses.
Implement Snowpipe for continuous ingestion and leverage Streams & Tasks for CDC-based incremental processing.
Implement dimensional modeling techniques (Star Schema, Snowflake Schema).
Analyse query profiles and execution plans to identify bottlenecks.
Work closely with BI developers to design analytics-ready datasets within Snowflake.
Required Qualifications: · Bachelor’s/Master’s degree in Computer Science, Data Science, Information Systems, or a related field. · 5+ years of hands-on experience in Data Engineering with strong Snowflake implementation experience.
· Implement CDC-based incremental loading using Streams & Tasks. · Develop advanced transformations using Snowpark (Python/Scala/Java) where required. · Create and manage UDFs and Stored Procedures using SQL, JavaScript, and Snowpark.
· Hands-on experience designing ELT pipelines using Snowflake and orchestration tools (ADF, Airflow, dbt, etc.). · Experience developing ELT pipelines using Snowflake-native SQL and Snowpark (Python/Scala/Java). · Experience building UDFs and Stored Procedures using SQL, JavaScript, or Snowpark.
· Develop advanced transformations using Snowpark (Python/Scala/Java) where required. · Create and manage UDFs and Stored Procedures using SQL, JavaScript, and Snowpark. · Integrate Snowflake with cloud storage platforms (Azure Data Lake, AWS S3, Blob Storage).
· Experience developing ELT pipelines using Snowflake-native SQL and Snowpark (Python/Scala/Java). · Experience building UDFs and Stored Procedures using SQL, JavaScript, or Snowpark. · Experience handling semi-structured data using Snowflake VARIANT data types and JSON functions.
- ETL Development, Snowpark & Data Integration: · Develop modular and scalable ELT pipelines using Snowflake-native SQL transformations. · Implement CDC-based incremental loading using Streams & Tasks.
· Implement version control and CI/CD processes for data pipelines. · Promote reusable SQL components, clean coding practices and Modular ELT design. · Ensure adherence to security standards, RBAC implementation and basic data governance principles.
· Mandatory strong experience in Data Modeling (conceptual, logical, physical) with solid knowledge of dimensional modeling and data warehousing principles. · Advanced proficiency in SQL, including performance optimization and complex transformations; experience with NoSQL databases is a plus. · Hands-on experience designing ELT pipelines using Snowflake and orchestration tools (ADF, Airflow, dbt, etc.).
· Create and manage UDFs and Stored Procedures using SQL, JavaScript, and Snowpark. · Integrate Snowflake with cloud storage platforms (Azure Data Lake, AWS S3, Blob Storage). · Design external stages and file formats for structured and semi-structured data ingestion.
· Handle semi-structured data using VARIANT data types, JSON parsing, and Snowflake-native functions. · Work with dbt for modular transformation orchestration and scalable modeling layers. - BI Collaboration & Analytical Enablement:
· Advanced proficiency in SQL, including performance optimization and complex transformations; experience with NoSQL databases is a plus. · Hands-on experience designing ELT pipelines using Snowflake and orchestration tools (ADF, Airflow, dbt, etc.). · Experience developing ELT pipelines using Snowflake-native SQL and Snowpark (Python/Scala/Java).
· Work closely with BI developers to design analytics-ready datasets within Snowflake. · Ensure seamless integration between Snowflake and BI tools such as Power BI, Tableau, or Looker. · Support backend optimization to improve dashboard performance.
· Develop well-structured fact and dimension tables optimized for analytical workloads. · Ensure data models are optimized for BI tools such as Power BI, Tableau, or similar platforms. · Maintain consistency, scalability, and performance across evolving data models.
At ADROSONIC, we are looking for a highly skilled Senior Data Engineer - Snowflake with 5+ years of hands-on experience in designing, building, and optimizing modern cloud-native data platforms. The ideal candidate will bring strong expertise in Snowflake architecture, cloud data services, and advanced data modelling practices. The ideal candidate will bring deep expertise in Snowflake architecture, advanced ELT design, Snowpark-based development, performance tuning, and data modelling best practices. This role requires strong ownership of Snowflake environments, enabling high-concurrency analytics workloads, cost-efficient compute management, and seamless BI enablement.
At ADROSONIC, we are looking for a highly skilled Senior Data Engineer - Snowflake with 5+ years of hands-on experience in designing, building, and optimizing modern cloud-native data platforms. The ideal candidate will bring strong expertise in Snowflake architecture, cloud data services, and advanced data modelling practices. The ideal candidate will bring deep expertise in Snowflake architecture, advanced ELT design, Snowpark-based development, performance tuning, and data modelling best practices. This role requires strong ownership of Snowflake environments, enabling high-concurrency analytics workloads, cost-efficient compute management, and seamless BI enablement. You will play a key role in building scalable Snowflake data warehouse architectures, enabling seamless integration with BI tools, and ensuring efficient, secure, and optimized ELT pipelines across projects.
The ideal candidate will bring deep expertise in Snowflake architecture, advanced ELT design, Snowpark-based development, performance tuning, and data modelling best practices. This role requires strong ownership of Snowflake environments, enabling high-concurrency analytics workloads, cost-efficient compute management, and seamless BI enablement. You will play a key role in building scalable Snowflake data warehouse architectures, enabling seamless integration with BI tools, and ensuring efficient, secure, and optimized ELT pipelines across projects. Requirements
Key Responsibilities: - Snowflake Data Platform Development: · Design and implement scalable Snowflake architectures leveraging multi-cluster Virtual Warehouses.
- Snowflake Data Platform Development: · Design and implement scalable Snowflake architectures leveraging multi-cluster Virtual Warehouses. · Configure and manage auto-scaling, auto-suspend/resume, and workload isolation strategies.
· Maintain consistency, scalability, and performance across evolving data models. · Design data models using different database schemas (Kimball, Star, Snowflake) for optimal data retrieval and storage. · Ensure models are optimized for both transactional (OLTP) and analytical (OLAP) workloads, using best practices in database design.
· Design external stages and file formats for structured and semi-structured data ingestion. · Handle semi-structured data using VARIANT data types, JSON parsing, and Snowflake-native functions. · Work with dbt for modular transformation orchestration and scalable modeling layers.
- BI Collaboration & Analytical Enablement: · Work closely with BI developers to design analytics-ready datasets within Snowflake. · Ensure seamless integration between Snowflake and BI tools such as Power BI, Tableau, or Looker.
· Collaborate seamlessly with internal stakeholders and external clients. · Translate complex business requirements into scalable Snowflake-based solutions. · Gather, analyze, and translate business requirements into scalable technical solutions.
· Ensure high availability, reliability, and secure data access. · Continuously improve scalability and maintainability of Snowflake environments. - Best Practices & Standards
- Performance Optimization & Maintenance: · Continuously monitor and optimize the performance of Snowflake data models, making improvements to ensure efficiency and scalability. · Conduct regular audits to ensure architecture alignment with evolving data strategy and business needs.
· Conduct periodic architecture reviews and performance audits. · Ensure alignment of Snowflake architecture with evolving enterprise data strategy. · Evaluate and implement new Snowflake features and capabilities proactively.
· Ensure alignment of Snowflake architecture with evolving enterprise data strategy. · Evaluate and implement new Snowflake features and capabilities proactively. Required Qualifications:
· Bachelor’s/Master’s degree in Computer Science, Data Science, Information Systems, or a related field. · 5+ years of hands-on experience in Data Engineering with strong Snowflake implementation experience. · Strong expertise in Snowflake architecture including Virtual Warehouses, Snowpipe, Streams, Tasks, Time Travel, Zero-Copy Cloning, RBAC, and Query Profiling.
· 5+ years of hands-on experience in Data Engineering with strong Snowflake implementation experience. · Strong expertise in Snowflake architecture including Virtual Warehouses, Snowpipe, Streams, Tasks, Time Travel, Zero-Copy Cloning, RBAC, and Query Profiling. · Mandatory strong experience in Data Modeling (conceptual, logical, physical) with solid knowledge of dimensional modeling and data warehousing principles.
· Experience building UDFs and Stored Procedures using SQL, JavaScript, or Snowpark. · Experience handling semi-structured data using Snowflake VARIANT data types and JSON functions. · Good understanding of data governance fundamentals, data quality, metadata management, and compliance standards.
Preferred Qualifications: · Snowflake SnowPro Core or SnowPro Advanced certification preferred · Domain experience in Insurance and Financial Services is a strong plus.
Open 5 monthsWe first saw this posting 172 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Day 172
Up longer than most. Similar jobs usually come down between day 6 and day 56.
From 14,766 similar postings that came down. Coming down is not always a hire.
2 open jobs
Check the employer’s posting for the current role and application details.
Already applied? Track this application
At
ADROSONIC, we are looking for a highly skilled Senior Data Engineer - Snowflake with 5+ years of hands-on experience in designing, building, and
optimizing modern cloud-native data platforms. The ideal candidate will bring
strong expertise in Snowflake architecture, cloud data services, and
advanced data modelling practices.
The ideal candidate will bring deep expertise in Snowflake
architecture, advanced ELT design, Snowpark-based development, performance
tuning, and data modelling best practices. This role requires strong ownership of Snowflake environments, enabling high-concurrency analytics workloads,
cost-efficient compute management, and seamless BI enablement.
You will
play a key role in building scalable Snowflake data warehouse architectures, enabling seamless integration with BI tools, and ensuring efficient, secure,
and optimized ELT pipelines across projects.
Key
Responsibilities:
· Design and
implement scalable Snowflake architectures leveraging multi-cluster Virtual
Warehouses.
· Configure
and manage auto-scaling, auto-suspend/resume, and workload isolation
strategies.
· Implement
Snowpipe for continuous ingestion and leverage Streams & Tasks for
CDC-based incremental processing.
· Utilize
Time Travel and Fail-safe for audit, recovery, and governance requirements.
· Implement
Zero-Copy Cloning for environment management (Dev / UAT / Prod).
· Design
secure access models using RBAC, Dynamic Data Masking, Row Access Policies, and
Secure Views.
· Optimize
separation of storage and compute for cost and concurrency efficiency.
· Design conceptual, logical, and
physical data models.
· Implement dimensional modeling
techniques (Star Schema, Snowflake Schema).
· Develop well-structured fact
and dimension tables optimized for analytical workloads.
· Ensure data models are
optimized for BI tools such as Power BI, Tableau, or similar platforms.
· Maintain consistency,
scalability, and performance across evolving data models.
· Design data models using
different database schemas (Kimball, Star, Snowflake) for optimal data
retrieval and storage.
· Ensure models are optimized for
both transactional (OLTP) and analytical (OLAP) workloads, using best practices
in database design.
· Analyse
query profiles and execution plans to identify bottlenecks.
· Optimize
micro-partition pruning and clustering depth.
· Implement
warehouse sizing strategies for workload segmentation (BI vs batch).
· Monitor
warehouse utilization and resource monitors proactively.
· Leverage
Materialized Views and Search Optimization Service where applicable.
· Continuously
optimize compute cost while maintaining performance SLAs.
· Develop modular and scalable
ELT pipelines using Snowflake-native SQL transformations.
· Implement CDC-based incremental
loading using Streams & Tasks.
· Develop advanced
transformations using Snowpark (Python/Scala/Java) where required.
· Create and manage UDFs and
Stored Procedures using SQL, JavaScript, and Snowpark.
· Integrate Snowflake with cloud
storage platforms (Azure Data Lake, AWS S3, Blob Storage).
· Design external stages and file
formats for structured and semi-structured data ingestion.
· Handle semi-structured data
using VARIANT data types, JSON parsing, and Snowflake-native functions.
· Work with dbt for modular
transformation orchestration and scalable modeling layers.
· Work closely with BI developers
to design analytics-ready datasets within Snowflake.
· Ensure seamless integration
between Snowflake and BI tools such as Power BI, Tableau, or Looker.
· Support backend optimization to
improve dashboard performance.
· Act as a technical bridge
between Data Engineering and BI teams.
· Collaborate seamlessly with
internal stakeholders and external clients.
· Translate
complex business requirements into scalable Snowflake-based solutions.
· Gather, analyze, and translate
business requirements into scalable technical solutions.
· Clearly communicate data
architecture decisions, pipeline designs, and modeling approaches.
· Participate in client
workshops, technical discussions, and solution presentations.
· Ensure strong alignment between
business objectives and delivered data solutions.
· Monitor warehouse utilization
and query performance proactively.
· Optimize compute usage,
clustering, partitioning, and caching strategies.
· Implement logging, monitoring,
and alerting mechanisms.
· Ensure high availability,
reliability, and secure data access.
· Continuously improve
scalability and maintainability of Snowflake environments.
· Follow data engineering
standards, naming conventions, and documentation practices.
· Implement version control and
CI/CD processes for data pipelines.
· Promote reusable SQL components,
clean coding practices and Modular ELT design.
· Ensure adherence to security
standards, RBAC implementation and basic data governance principles.
· Continuously monitor and
optimize the performance of Snowflake data models, making improvements to
ensure efficiency and scalability.
· Conduct regular audits to
ensure architecture alignment with evolving data strategy and business needs.
· Conduct
periodic architecture reviews and performance audits.
· Ensure
alignment of Snowflake architecture with evolving enterprise data strategy.
· Evaluate
and implement new Snowflake features and capabilities proactively.
Required
Qualifications:
· Bachelor’s/Master’s degree in Computer
Science, Data Science, Information Systems, or a related field.
· 5+ years of hands-on experience
in Data Engineering with strong Snowflake implementation experience.
· Strong expertise in Snowflake architecture including
Virtual Warehouses, Snowpipe, Streams, Tasks, Time Travel, Zero-Copy Cloning,
RBAC, and Query Profiling.
· Mandatory strong experience in
Data Modeling (conceptual, logical, physical) with solid knowledge of
dimensional modeling and data warehousing principles.
· Advanced proficiency in SQL,
including performance optimization and complex transformations; experience with
NoSQL databases is a plus.
· Hands-on experience designing
ELT pipelines using Snowflake and orchestration tools (ADF, Airflow, dbt,
etc.).
· Experience
developing ELT pipelines using Snowflake-native SQL and Snowpark
(Python/Scala/Java).
· Experience building UDFs and
Stored Procedures using SQL, JavaScript, or Snowpark.
· Experience handling
semi-structured data using Snowflake VARIANT data types and JSON functions.
· Good understanding of data
governance fundamentals, data quality, metadata management, and compliance
standards.
· Strong analytical,
troubleshooting, and stakeholder collaboration skills with experience working
in Agile delivery environments and version-controlled setups.
Preferred
Qualifications:
· Snowflake SnowPro Core or
SnowPro Advanced certification preferred
· Domain
experience in Insurance and Financial Services is a strong plus.
· Experience in client-facing or
consulting environments.
· Exposure to DevOps practices
and Git-based version control.
· Experience handling
enterprise-scale data environments.
Soft
Skills:
· Strong collaborative mindset.
· Seamless coordination with BI
teams and stakeholders.
· Strong client communication and
stakeholder management skills.
· Ownership-driven and proactive
approach.
· Strong analytical and
problem-solving abilities.
· Ability to work effectively in
fast-paced, evolving environments.
New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
Pune, India
Working pattern and location restrictions need checking in the full posting.
No clear work-authorization passage found. Eligibility is unconfirmed.
We couldn’t identify enough role detail in this saved description to support an AI answer. Read the full posting