Job description

• Mid-sized, growing Financial Services firm based in Midtown Manhattan! • Contract with the opportunity for conversion, as the team is rapidly growing! About Our Client A company in the Financial Services industry located in New York. Job Description 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. FOUR DAYS ONSITE IN MIDTOWN NYC ARE REQUIRED! • 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. MPI does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, or based on an individual's status in any group or class protected by applicable federal, state or local law. MPI encourages applications from minorities, women, the disabled, protected veterans and all other qualified applicants. The Successful Applicant • 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; Star schema and dimensional modelling; Data architecture and data governance; Performance tuning and optimization • Experience working with source control and CI/CD delivery practices. • Financial Services experience is a strict requirement • Experience engaging with business stakeholders, product owners and senior management. Please note: Candidates must be authorized to work in the United States without current or future sponsorship requirements. This role is not eligible for c2c arrangements. What's on Offer • MP health benefits starting on the first day of employment. • Opportunity to work in the Financial Services industry in New York City. Interested? Apply today!

Requirements

Must-haves

Mid-sized, growing Financial Services firm based in Midtown Manhattan!
Contract with the opportunity for conversion, as the team is rapidly growing!
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.
The Successful Applicant
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; Star schema and dimensional modelling; Data architecture and data governance; Performance tuning and optimization
Experience working with source control and CI/CD delivery practices.
Financial Services experience is a strict requirement
Experience engaging with business stakeholders, product owners and senior management.
Please note: Candidates must be authorized to work in the United States without current or future sponsorship requirements.
What's on Offer

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

pythonsqlci/cd

Platform: careers-page
Effort: medium