Role: Senior Snowflake Developer

Location: New York, NY (Onsite)

Job Description:

Duties:

Solution Design & Development:

Design, develop and maintain scalable data solutions within Snowflake.
Build and optimise 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.
Support platform modernisation and migration initiatives from legacy technologies to cloud-based platforms.

Data Engineering & Optimisation:

Develop data ingestion and transformation processes from a wide variety of source systems.
Optimise Snowflake databases, queries and workloads to improve performance and cost efficiency.
Ensure solutions are scalable, maintainable and aligned with enterprise standards.
Implement data quality controls and monitoring capabilities.
Troubleshoot and resolve complex production and performance-related issues.

Stakeholder Engagement:

Engage directly with business stakeholders to understand requirements and translate them into technical solutions.
Facilitate workshops and requirements gathering sessions.
Communicate effectively with both technical and non-technical audiences.
Build strong working relationships across business and technology teams.
Provide technical leadership and guidance throughout project delivery.

Governance & Best Practice:

Champion best practices across data engineering, modelling and software development.
Contribute to technical documentation and knowledge-sharing initiatives.
Support code reviews, testing and release activities.
Ensure compliance with governance, security and regulatory standards.

Skills:

Technical 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
Star schema and dimensional modelling
Data architecture and data governance
Performance tuning and optimisation
Experience working with source control and CI/CD delivery practices.

Financial Services Experience:

Proven experience within Banking or Financial Services organisations, preferably within the Credit or Market Risk arena.
Strong understanding of enterprise data environments supporting risk, finance, treasury, regulatory or management reporting.
Experience working within governance and control frameworks common to regulated financial institutions.

Stakeholder Management:

Demonstrable experience engaging with business stakeholders, product owners and senior management.
Strong requirements gathering and business analysis skills.
Ability to translate complex business requirements into scalable technical solutions.
Excellent verbal and written communication skills.

Education:

Senior Snowflake Developer

Key skills