Deliver scalable data infrastructure for automated workflows, design data warehouse schemas, and create dashboards for stakeholders in finance.
Delivering scalable data infrastructure that transforms manual financial and actuarial processes into automated, auditable workflows. To deliver robust, scalable backend systems and data infrastructure that power automated data pipelines and dashboards for our global life reinsurance client in Bermuda.
Hands on Experience:
- Designing and implementing data warehouse schemas in cloud environments (BigQuery preferred)
- Building reconciliation and data quality frameworks for financial data
- Creating dashboards and data visualisations for business stakeholders
- Working with financial instrument identifiers (ISIN, CUSIP), rating agencies, and cross-system data mapping
Requirements
Must Have Experience:
- 4+ years experience in data engineering or data architecture roles
- Strong SQL skills with experience designing data warehouse schemas (BigQuery, Snowflake, or similar)
- Proven experience with dbt for data transformation workflows
- Asset management or financial markets experience (e.g. investment accounting, fund administration, portfolio management)
- Experience building reconciliation logic and data quality frameworks
- Proficiency with BI tools (Looker, Looker Studio, or similar)
Bonus (the nice to haves):
- Insurance or reinsurance industry experience
- Knowledge of Clearwater, Aladdin, and other finance systems
- Familiarity with regulatory reporting (IFRS 17, BSCR, Solvency II)
- Python proficiency for data processing and automation
- Experience with GCP services (Cloud Storage, Pub/Sub, Cloud Run)
Required Behaviours/Characteristics:
- Curious: Proactively explores problems and technologies; asks good questions
- Hard-working: Delivers reliably and takes ownership of outcomes
- Adaptable: Comfortable with ambiguity and evolving requirements; learns new domains quickly
- Collaborative: Works effectively with data engineers, analysts, and client stakeholders
- Quality-focused: Writes clean, tested, maintainable code
Benefits
- Fully Remote
- Outside IR35
- Long term contract
- £600 - £650/Day
Top Skills
BigQuery
Dbt
GCP
Looker
Python
SQL
Similar Jobs
Fintech • Software • Financial Services
As a Senior Data Engineer at Pennylane, you will model data, design ETL pipelines, and contribute to data governance and analytics platforms to support decision-making across the company.
Top Skills:
Data Analytics PlatformData GovernanceData ModelingData WarehousingETLSQL
Fintech • Financial Services
The Data Engineer will focus on data engineering tasks, applying software development principles and improving data products, while collaborating with teams and enhancing application performance.
Top Skills:
Apache HdfsSparkAWSCloudGitJavaKafkaPysparkPythonScala
Marketing Tech
As a Senior Data Engineer, you will build and optimize data pipelines, enhance AWS infrastructure, and ensure data quality for business insights.
Top Skills:
Apache IcebergAthenaAWSDbtGluePolarsPysparkPythonS3SQL
What you need to know about the Edinburgh Tech Scene
From traditional pubs and centuries-old universities to sleek shopping malls and glass-paneled office buildings, Edinburgh's architecture reflects its unique blend of history and modernity. But the fusion of past and future isn't just visible in its buildings; it's also shaping the city's economy. Named the United Kingdom's leading technology ecosystem outside of London, Edinburgh plays host to major global companies like Apple and Adobe, as well as a growing number of innovative startups in fields like cybersecurity, finance and healthcare.
