Senior Snowflake Developer (HYBRID, NYC)

About the role

We're seeking a Senior Snowflake Developer who will design, develop and maintain data solutions within our client's Snowflake platform. This requires building ELT/ETL pipelines, designing and implementing data models and developing Python-based data processing, automation and integration solutions. The client is a Financial Services company located in New York.

Responsibilities

• Design, develop and maintain scalable data solutions within Snowflake.
• Support platform modernization and migration initiatives from legacy technologies to cloud-based platforms.
• Build and optimize enterprise-grade ELT/ETL pipelines supporting business-critical reporting and analytics requirements.
• Design and implement robust data models, including dimensional, analytical and operational reporting structures.
• Develop and maintain reusable transformation frameworks using dbt.
• Develop Python-based data processing, automation and integration solutions.
• Contribute to architecture decisions and technical design standards.
• Develop data ingestion and transformation processes from a wide variety of source systems.
• Optimize Snowflake databases, queries and workloads to improve performance and cost efficiency.
• Implement data quality controls and monitoring capabilities.

Requirements

• Candidates must be authorized to work in the United States without current or future sponsorship requirements.
• This role is not eligible for c2c arrangements.
• Financial Services experience is a strict requirement.
• Experience engaging with business stakeholders, product owners and senior management.

Skills

• Extensive hands-on experience with Snowflake.
• Strong experience using dbt for transformation, modelling and deployment of data solutions.
• Advanced Python development skills for data engineering and automation.
• Strong SQL Server experience, including database design, optimisation and troubleshooting.
• Significant experience designing and implementing ETL/ELT solutions.
• Strong understanding of data warehousing principles.
• Strong understanding of star schema and dimensional modelling.
• Strong understanding of data architecture and data governance.
• Strong understanding of performance tuning and optimization.
• Experience working with source control and CI/CD delivery practices.

Benefits

• MP health benefits starting on the first day of employment.
• Opportunity to work in the Financial Services industry in New York City.

Schedule

Four days onsite required in Midtown NYC.