Finance Data Engineer

This is an opportunity to join Ascot Group - one of the world’s preeminent specialty risk underwriting organisations.

Designed as a modern-era company operating through an ecosystem of interconnected global operating platforms, we’re bound by a joint mission and purpose: One Ascot. Our greatest strength is a talented team that flourishes in a collaborative, inclusive, and entrepreneurial culture steeped in underwriting excellence, integrity, and a passion for finding a better way, The Ascot Way.

The Ascot Way guides our people and our organisation. Our underwriting platforms collaborate to find creative ways to deploy our capital in a true cross-product and cross-platform approach. These platforms work as one, deploying our capital creatively through our unique Fusion Model: Client Centric, Risk Centric, Technology Centric.

Built to be resilient, Ascot maximises client financial security while delivering bespoke products and world-class service — both pre- and post-claims. Ascot exists to solve for our clients’ brightest tomorrow through agility, collaboration, resilience, and discipline.

Ascot has a significant deployment of the Phinsys product set for its U.K. and Bermuda business, developed over several years. Ascot is bringing ongoing development and support of this capability in-house based out of the Ascot London office.

The Finance Support Engineer will be responsible for supporting and developing enhancements to Ascot’s financial applications.

The ideal candidate will have significant experience working in collaborative teams for delivery, implementation, maintenance and user support.

The role is based in Ascot’s office in the City of London and will be a hybrid home/office working model.

Essential Functions and Basic Duties

• Support, document, develop and enhance Phinsys applications utilising Tandem Data Warehouse, Inform, Rapport, Comply, and Postbox. 


• Conduct changes and configuration within Phinsys. 


• Package releases, including the preparation of release notes and run books. 


• Create and maintain comprehensive documentation for supported applications. 


• Implement monitoring and alerting systems to ensure application health and performance. 


• Perform system testing and quality assurance of financial applications and systems. 


• Collaborate with the Finance Product Owner, to align development and support activities with finance product objectives.

Experience

• Essential:
  
  
  
  • SQL Server and SQL Server Analysis Services from an application developer standpoint. 
  
  
  • Data warehouse design, SQL, ETL, stored procedures, performance tuning, UI design, and testing. 
  
  
  • Familiarity with using DevOps to manage requirements through development, testing & deployment 
  
  
  • Analytical Thinking: Ability to dissect complex problems and drive data-driven decisions. 
  
  
  • Technical Acumen: Strong grasp of technical concepts, allowing effective communication with data engineers, analysts, and architects. 
  
  
  • Attention to Detail: Ensuring data accuracy and integrity in all products overseen. 
  
  
  • Continuous Learner: Staying updated with the latest in BI tools, data trends, and industry-specific needs. 
  
  
  • Problem-solving: Ability to troubleshoot issues, foresee potential pitfalls, and proactively devise solutions. 
  
  

• Desirable:
  
  
  
  • Knowledge of insurance, accounting (GAAP), financial reporting, and Lloyd's market is highly beneficial.  
  
  


• Knowledge of S2000 would be advantageous 


• Experience of supporting and developing Phinsys products 


• DBA exposure is advantageous. 

Skills

• Essential:
  
  
  
  • SQL query language 
  
  
  • MDX query language 
  
  
  • Writing SQL-based stored procedures 
  
  
  • Demonstrated hands-on experience working with Business Intelligence (BI) concepts, data warehousing, and data modelling and an ability to debug, extend and improve the solution based on best practices and new requirements. 
  
  
  • Ability to work in a mature SDLC 
  
  
  • Experience with modern source control (e.g Git) 
  
  
  • Writing high-quality technical and business-facing documentation 
  
  
  • Excellent communication skills with the ability to work independently when required. 
  
  

• Desirable:
  
  
  
  • Utilising the Phinsys development environment 
  
  
  • Power BI report and semantic model development