· 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.
Nice to have
· 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.
Full description
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.
· Ensure adherence to security standards, RBAC implementation and basic data governance principles.
**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.
**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.