Principal Snowflake Data Engineer - Contract (Manchester)
At a glance
Senior Data Engineering role at Insight Investment. Manchester · contract.
Pay not stated Data Engineering salary
dataroles summary, based on the employer's posting.
What you'll do
- Shape and build a scalable Snowflake data platform, choosing complementary tools to meet business needs
- Set firm-wide practices for bringing in, governing, transforming, storing and sharing data
- Improve ELT pipeline performance and configure tools that support advanced analytics and AI
- Work with cloud engineering to expand infrastructure-as-code, while keeping designs aligned with data, privacy and security policies
- Help develop the data strategy and explain its outcomes to leaders and delivery teams
What you bring
- Hands-on Snowflake expertise across features such as warehouses, Snowpipe and Snowpark
- You have delivered end-to-end Snowpark pipelines, or used a transferable framework such as PySpark
- Strong Python and SQL skills, including testing, build practices and Snowflake-tuned queries
- Experience with dbt or a comparable transformation framework, plus CI/CD pipelines
Who this fits
This senior contract role suits a principal-level engineer who can work independently, communicate complex technical ideas and collaborate with stakeholders and Agile teams. The position is onsite in Manchester.
From the employer
We are looking for an experienced Principal Snowflake Data Engineer to join our growing team building our strategic data
platform as we look to adopt best in class data governance and democratise data around the business. The successful candidate will play a pivotal role in shaping and executing our data strategy, leveraging our data assets to the full, elevating our decision-making, streamlining processes, and drive innovation within our organisation.
You will be part of the long-standing Data Platform team using Agile methods to deliver solutions on top of our cloud platform. Starting with Snowflake as a foundational component, we will look to integrate other technologies and grow capability to meet the demands of the business. You will work closely with a variety of business areas and be involved in all aspects of the Secure System Development Lifecycle (S-SDLC).
We operate in a collaborative and inclusive environment, where each team member's expertise is valued. Our culture emphasizes open communication, mutual support, and a shared commitment to delivering exceptional results. We foster a learning culture, providing opportunities for growth and innovation while maintaining high standards of professionalism and integrity.
Role Responsibilities
- Contribute to the solution design and implementation of a robust and scalable data platform using
- Snowflake with complementary tooling to meet the organisation's needs.
- Help evolve the Insight Data Strategy, communicate outcomes from a leadership through to team level.
- Set the firm-wide standards and conventions for ingesting, governing, transforming, persisting, and democratising data.
- Provide expertise in ELT pipeline performance optimisation
- Enable the adoption of advanced analytics & AI by configuring best-in-class tooling.
- Evolve the usage of infrastructure-as-code in collaboration with cloud engineering.
- Align technical designs with internal data, privacy, security and compliance policies.
- Stay abreast of industry trends and emerging technologies related to Snowflake and big data processing, recommending relevant advancements for consideration.
Experience Required
- Snowflake (Warehouses, Tasks/Streams, Snowpipe, Snowpark, Distributed UDF/Sproc, Time Travel, Cloning)
- Demonstratable experience of delivering end to end pipelines in Snowpark (transferable frameworks such as Pyspark, Polars or Dask are also welcome).
- DBT including Jinja templating or equivalent transformation frameworks
- Python including build tools, test automation frameworks and engineering best practices
- SQL (including Snowflake-optimised SQL)
- Experience with CI/CD pipelines (GitHub Actions / TeamCity / Artifactory).
- Demonstrate initiative and independence to solve problems.
- Be able to communicate abstract or complex ideas or solutions effectively.
- Stand by software engineering principles around quality and doing things the right way.
- Experience working in and with Agile teams performing iterative development.
- Ability to collaborate with end users, stakeholders, teams, and team members.
- Have a constant desire to improve knowledge and drive adoption of new tech or approaches within the teams.
- Own mistakes and work with your colleagues to redress them, learn from them and make improvements for the long-term.
- Docker
- Java / Scala
- Event streaming technologies such as Kafka, Pulsar, or Azure Event Hub
- Integration with Collibra
- Apache Iceberg
- Apache Arrow
- Pyspark
- AI engineering (Snowflake AI, Langchain, Llamaindex, Pinecone, etc)
Insight is committed to being an inclusive employer and encourages applications from all suitably qualified applicants irrespective of background, circumstances, age, disability, gender identity, ethnicity, religion or belief, sexual orientation or other factors protected by federal, state and/or local laws. If you are a candidate with a disability, or are assisting a candidate with a disability, and require an accommodation to apply for one of our jobs, please email us at TalentAcquisition@InsightInvestment.com
Insight Investment is a leading asset manager focused on designing investment solutions to meet its clients' needs. Founded in 2002, Insight's collaborative approach has delivered both investment performance and growth in assets under management. Insight manages assets across its core liability-driven investment, risk management, full-spectrum fixed income, currency and absolute return capabilities. Insight has a global network of operations in the UK, Ireland, Germany, US, Japan and Australia. More information about Insight Investment can be found at: https://www.insightinvestment.com/corporate/
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.