Senior Snowflake Developer

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:

• Degree educated.
• Professional certification in Snowflake highly preferred.