About the Role :
We are seeking an experienced and highly motivated Senior Software Engineer to specialize in our modern data platform built on Snowflake.
This pivotal role requires an expert-level command of SQL and a proven track record in designing, developing, and optimizing highly scalable data pipelines.
As a Senior team member, you will not only be hands-on with development but also take ownership of key data initiatives and mentor junior developers.
Key Responsibilities :
ELT / ETL Architecture and Development :
- Architect, design, and implement robust and scalable ELT pipelines using Snowflake and related cloud technologies (e.g., AWS / Azure / GCP integration).
- Develop complex stored procedures, UDFs, Streams, Tasks, and Snowpipe solutions to automate and process large volumes of data.
Performance and Optimization :
Lead performance tuning and optimization efforts across the entire data warehouse, focusing on query rewrite, warehouse sizing, clustering, and micro-partitioning strategies.Conduct in-depth data profiling and source-to-target mapping analysis to ensure data quality, integrity, and lineage are maintained.Technical Leadership and Mentoring :
Serve as a technical lead, taking full ownership of complex tasks and end-to-end data features.Mentor junior and mid-level developers, conduct thorough code reviews, and drive the adoption of data engineering best practices and standards.Cross-Functional Collaboration :
Actively collaborate with Product Managers to translate business requirements into technical specifications and data models.Work closely with QA Teams to define testing strategies and ensure the delivery of high-quality, reliable data solutions.Required Qualifications :
Expertise and Experience :
5+ years of professional experience in data warehousing, ETL / ELT development, or data engineering.A Bachelors or Masters degree in Computer Science, Engineering, or a related field, or equivalent practical experience.Technical Skills (Must-Haves) :
Snowflake Mastery : Deep, hands-on experience with the Snowflake platform, including architecture, advanced features (Time Travel, Zero-Copy Cloning), administration, and optimization techniques.Advanced SQL Proficiency : Expert-level command of SQL for complex data manipulation, including :Mastery of Common Table Expressions (CTEs), window functions (RANK, ROW_NUMBER, etc.), and recursive queries.Designing and optimizing complex joins, subqueries, and set operations.Experience with query execution plans and performance tuning.Cloud Fundamentals : Experience with at least one major cloud provider (AWS, Azure, or GCP) for data storage (S3, ADLS, GCS) and compute resources.Preferred Qualifications (Nice-to-Haves) :
Data Modeling : Strong understanding and practical experience with dimensional modeling (Star / Snowflake Schema) and other data modeling techniques (e.g., 3NF).DBT (Data Build Tool) : Hands-on experience with DBT for transformation development, testing, and documentation within the Snowflake environment.Industry Knowledge : Previous experience in the Healthcare domain, specifically with Payer systems (e.g., Claims, Enrollment, Provider data).Programming : Proficiency in a scripting language like Python for pipeline orchestration or data manipulation tasks(ref : hirist.tech)
%20Pvt%20Ltd){kind=logo}