Data engineer financial reporting

The customer is an established financial services provider offering solutions for individuals and organizations focused on long-term financial planning and investment. It combines industry expertise with modern technology to simplify financial processes and improve customer experience, operational efficiency, and access to services. The project is modernizing retail technology and building a secure, scalable, governed enterprise data and analytics platform to transform reporting, integrate data sources, and support regulatory and operational reporting, advanced analytics, data migration, and future strategic data products.

• Lead the design, development, and operationalization of scalable data engineering solutions for the Sunrise programme
• Contribute to the design and implementation of the new data platform, working with the client's architects and Principal Data Engineer
• Design and implement data ingestion pipelines from Sapiens, IRIS, and other enterprise source systems
• Develop ETL/ELT pipelines using Azure Data Factory, Azure Databricks, and Microsoft Fabric
• Build and maintain data solutions across Azure Data Lake and modern cloud data platforms
• Implement medallion architecture and reusable data engineering patterns, using Data Vault for Bronze/Silver and Kimball dimensional modeling for Gold/reporting
• Develop curated datasets, analytical data products, and trusted business views
• Implement data transformation, cleansing, validation, and reconciliation processes
• Support source-to-target integration as Sapiens replaces IRIS; this is new-build integration work, not migration of the existing data engineering framework
• Work with Business Analysts, Data Analysts, Data Architects, the client's Principal Data Engineer, and other engineering teams to translate requirements into production-ready solutions
• Ensure pipelines and data products meet scalability, reliability, performance, security, and data quality requirements
• Implement automated data quality and validation checks across pipelines and datasets
• Support regulatory and operational reporting, including reinsurance extracts and the valuation system feed, ensuring data is accurate, complete, and traceable
• Implement monitoring, logging, and operational controls for pipelines and platform services
• Contribute to CI/CD and Dev Ops practices using Azure Dev Ops
• Support pipeline and code-generation automation where appropriate; infrastructure-as-code is owned by a dedicated Platform Engineer
• Develop reusable frameworks, components, and engineering standards to accelerate programme delivery; redesign the current framework
• Contribute to data governance, lineage, metadata, and security requirements, including handling PII in a secured, obfuscated, access-controlled layer
• Work with platform and architecture teams to align solutions with enterprise architecture and governance standards
• Explore and implement AI-enabled approaches to data engineering and SDLC automation
• Support data foundations for future AI and agentic AI use cases; the client already runs a production LLM/data-agent on a separate dataset and wants similar capability here
• Participate in technical design, code reviews, troubleshooting, and production support
• Mentor other engineers and contribute to engineering best practices within the Data Team
• Set engineering patterns and standards

• 6+ Years of commercial Data Engineering experience
• Experience designing a similar greenfield data-platform framework
• Strong hands-on Azure Dev Ops experience, including YAML pipelines and CI/CD pipeline design
• Strong hands-on experience designing and developing enterprise-scale data pipelines and platforms
• Strong experience with Microsoft Azure data services
• Advanced hands-on experience with Azure…