Job Title: Data Engineer
Job Description
This contract Data Engineer role focuses on delivering complex data migration projects into a Snowflake data warehouse within the private equity and fund administration domain. You will work as a hands-on, mid-to-senior level individual contributor, designing and building data models, developing robust pipelines, and supporting multiple concurrent migration initiatives across US and EU regions. The position offers remote working, with a preference for candidates based in the UK for effective collaboration across distributed teams.
Responsibilities
1. Design, build, and optimise scalable data models in Snowflake using dbt to support analytics and reporting requirements.
2. Lead and support data migration projects from legacy systems into Snowflake, ensuring accuracy, completeness, and consistency of data.
3. Develop, maintain, and troubleshoot end-to-end data pipelines and workflows across multiple concurrent migration projects.
4. Perform hands-on SQL development to deliver complex data transformations, calculations, and analytical queries.
5. Collaborate with cross-functional teams to design and deliver data products, reporting structures, and semantic layers that meet business needs.
6. Investigate and resolve data quality issues, including analysing logs, debugging pipeline failures, and performing performance tuning.
7. Work closely with stakeholders to translate business and reporting requirements into robust data models and transformation logic.
8. Contribute to semantic modelling and ensure consistency and standardisation across data layers and projects.
9. Support knowledge transfer across ongoing migration projects, sharing best practices and ensuring continuity of delivery.
10. Operate effectively as an individual contributor in a fast-paced, delivery-focused environment, managing priorities across multiple US and EU migration initiatives.
Essential Skills
11. Strong, hands-on experience with Snowflake, including deep knowledge of its features, performance considerations, and best practices.
12. Advanced SQL skills for complex data transformation, modelling, and analytics in a data warehouse environment.
13. Proven experience using dbt (data build tool) to design, implement, and manage transformation workflows.
14. Proficiency in Python for data engineering tasks such as scripting, automation, and integration.
15. Demonstrated experience in data pipeline troubleshooting and infrastructure support, including diagnosing failures and optimising performance.
16. Familiarity with modern data stack tools such as Kafka and Kubernetes.
17. experience with data orchestration frameworks (for example, modern workflow orchestration tools) to schedule and manage pipelines.
18. Previous experience working in private equity, asset management, or fund administration, with exposure to related data and processes.
19. Strong understanding of financial data structures and reporting requirements within investment and fund environments.
20. experience in fast-paced, delivery-focused environments, with the ability to contribute immediately to ongoing projects.
21. Ability to work effectively as a hands-on individual contributor rather than in a purely architecture-focused capacity.
22. Strong communication skills to collaborate with distributed teams across the UK, US, and EU.
Additional Skills & Qualifications
23. experience with industry-specific systems such as Investran (PCS), Allvue, or Paxus.
24. Exposure to multiple concurrent data migration projects, particularly across different regions or business units.
25. Demonstrated problem-solving skills, with the ability to design pragmatic solutions under time constraints.
26. experience participating in or completing technical assessments that evaluate modelling approaches and coding ability.
27. Comfort working in a fully remote setting while maintaining strong communication and collaboration practices.
Why Work Here?
You will join a dynamic, delivery-focused organisation that values technical excellence and gives you the opportunity to work with a modern data stack centred on Snowflake and dbt. The environment offers significant exposure to high-impact, international projects in the private equity and fund administration space, allowing you to deepen your domain expertise while working with distributed teams across the UK, US, and EU. With fully remote working available and a strong emphasis on collaboration and problem-solving, you can enjoy flexibility while contributing meaningfully to critical data initiatives.
Work Environment
The role sits within a fast-paced delivery team handling four concurrent data migration projects across US and EU regions. You will work primarily with Snowflake, dbt, SQL, and Python, alongside modern data stack components such as Kafka, Kubernetes, and data orchestration frameworks. The position supports fully remote working, with a preference for UK-based candidates to facilitate communication and collaboration across time zones. The environment is highly collaborative, outcome-driven, and focused on delivering robust, well-engineered data solutions without a rigid dress code, as work is primarily performed remotely.
Location
Manchester, UK
Rate/Salary
- GBP Daily
Trading as TEKsystems. Allegis Group Limited, Maxis 2, Western Road, Bracknell, RG12 1RT, United Kingdom. No. 2876353. Allegis Group Limited operates as an Employment Business and Employment Agency as set out in the Conduct of Employment Agencies and Employment Businesses Regulations 2003. TEKsystems is a company within the Allegis Group network of companies (collectively referred to as "Allegis Group"). Aerotek, Aston Carter, EASi, Talentis Solutions, TEKsystems, Stamford Consultants and The Stamford Group are Allegis Group brands.