Job description – Snowflake Data Engineer
Location:
New York or North America
Term:
Permanent/Full-time (flexible working arrangements to be negotiated)

Who we are

Our organization is a leading data and AI consultancy specializing in delivering cloud data platforms and analytics solutions. We are committed to accelerating delivery and building exceptional technical teams for our clients. We deliver services across data, AI, and cloud while building the next generation of tech leaders. As part of our Data Engineering team, you will be joining a motivated team of technology professionals where ongoing learning and development are central to our ethos and internal culture.

Role Description

We are seeking a Snowflake Engineer to design, build, and optimize pipelines and data models within Snowflake. This is a hands-on engineering role where you will develop secure, scalable solutions that deliver high-quality data for analytics and reporting.

Key Responsibilities

• Build and maintain pipelines to ingest, transform and deliver data into Snowflake.

• Design and implement efficient, well-structured Snowflake schemas.

• Write performant SQL and optimize queries for cost and speed.

• Configure Snowflake warehouses, roles, and permissions according to security and governance standards.

• Monitor performance, and query history to identify and implement optimizations.

• Work with data engineers, analysts and business users to understand requirements and deliver solutions that meet functional and non-functional needs.

• Follow engineering best practices including version control, code reviews and CI/CD pipelines.

• Troubleshoot data issues and ensure data quality through validation and testing.

• Stay up to date on Snowflake features and capabilities, applying them to improve performance and efficiency.

Key Requirements & Technical Experience

• 2+ years of experience as a data engineer with Snowflake.

• Strong SQL skills and understanding of data modelling concepts.

• Hands-on experience with ELT/ETL pipelines using tools such as dbt, Airflow, Fivetran, Matillion, or native Snowflake features.

• Familiarity with at least one programming language (Python preferred).

• Experience working with cloud platforms (AWS, Azure, GCP).

• Experience troubleshooting performance issues and tuning queries.

• Comfortable collaborating with cross-functional teams and following structured delivery processes.

Role Details

Contract type: Permanent
Salary: Negotiable dependent on experience + bonus
Working Pattern: Hybrid – expectation of 2-3 days per week in office and/or working at client locations.

Diversity Statement

We welcome candidates from all backgrounds and particularly encourage applications from groups currently underrepresented in the industry, including women, people from black and ethnic minority backgrounds, LGBTQ+ people, people with disability and those who are neurodivergent.
We know that potential applicants are sometimes put off if they don't meet 100% of the requirements. We think individual experience, skills and passion make all the difference, so if you meet a good proportion of the criteria, we'd love to hear from you.
We are committed to ensuring that all candidates have an equally positive experience, and equal chances for success regardless of any personal characteristics. Please speak to us if we can support you with any adjustments to our recruitment process.

Research indicates that men will apply to a role when they only meet 50-60% of the descriptions, however, when looking at women and other minority groups, they can look for up to a 99% match in order to apply to a role. If you feel you are a fit for our role, please still apply, don’t worry if you don’t tick every single box. We’d still love to hear from you. We encourage underrepresented talent to apply to all our roles & support accessibility needs.