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