Job Summary:
Extensive PostrgreSQL and Python skills required
Return
Data Engineer
Job Description:
Senior Application Developer
London – Hybrid working (1 – 2 day per week office visit required)
6 months contract – £570 per day – Outside IR35
About the Role
We are looking for a Senior Application Developer to design and build a robust PostgreSQL-based data platform that will underpin our investment reporting, risk analytics, regulatory disclosures and performance measurement.
This is a genuinely high-impact, greenfield opportunity. You will have real ownership of the platform design and lead the migration away from Databricks and Excel-driven processes — leaving a lasting mark on infrastructure that sits at the heart of our investment operations.
What You’ll Be Doing
You will lead the design and build of a scalable, secure PostgreSQL data platform to support:
Key Responsibilities
London – Hybrid working (1 – 2 day per week office visit required)
6 months contract – £570 per day – Outside IR35
About the Role
We are looking for a Senior Application Developer to design and build a robust PostgreSQL-based data platform that will underpin our investment reporting, risk analytics, regulatory disclosures and performance measurement.
This is a genuinely high-impact, greenfield opportunity. You will have real ownership of the platform design and lead the migration away from Databricks and Excel-driven processes — leaving a lasting mark on infrastructure that sits at the heart of our investment operations.
What You’ll Be Doing
You will lead the design and build of a scalable, secure PostgreSQL data platform to support:
- Portfolio holdings and valuations
- Performance and attribution reporting
- Risk analytics
- Regulatory and trustee reporting
- Operational data governance
Key Responsibilities
- Architect and implement a secure PostgreSQL-based data platform
- Lead migration from Databricks and spreadsheet-based reporting processes
- Design dimensional models for investment, holdings, pricing and performance data
- Develop robust ETL/ELT pipelines using Python
- Implement data validation, reconciliation and audit controls
- Optimise performance for reporting and analytics workloads
- Ensure compliance with FCA and TPR regulatory expectations
- Implement role-based access controls and data security standards
- Establish monitoring, backup and disaster recovery processes
- Work closely with investment, risk and finance stakeholders
- 5+ years in data engineering, application development or data platform roles
- Strong PostgreSQL expertise, including performance tuning, indexing and partitioning
- Experience building financial or investment data platforms
- Strong SQL and Python skills
- Experience migrating data from cloud analytics platforms such as Databricks
- Solid understanding of data modelling, including star schema and SCD handling
- Experience working in regulated financial services environments
- Background in pensions, asset management or institutional investments
- Familiarity with performance measurement and attribution concepts
- Experience with Airflow or dbt
- Cloud infrastructure knowledge (AWS or Azure)
- Understanding of data governance frameworks
- Detail-oriented with a strong data quality mindset
- Comfortable working in highly regulated environments
- A clear communicator who can engage confidently with non-technical stakeholders
- Proactive and pragmatic — you solve problems rather than just flag them
- A rare chance to modernise core investment data infrastructure from scratch
- A high-visibility role working directly with senior stakeholders across investment, risk and finance
- A stable, purpose-driven organisation with a long-term outlook
- Flexible hybrid working with only occasional London office visits required
