The creative mind behind every project.
Put your skills to the test to build solutions that continue to shape the world we live in!
About Us
Ascent has recently been acquired by Acuity Analytics. This is both a significant milestone for us and a tremendous opportunity for you. Acuity Analytics is a business with a strong global reputation, an impressive client base and ambitious growth plans. We deliver deep insights and domain-led digital transformation to high-growth and heavily regulated organisations. To our customers, we bring a partnership that provides the talent, technology and capability to enhance performance and operational efficiency.
About the Role
We are seeking a Senior Data Engineer – Power BI & Azure Databricks to support a global reinsurance client in transforming their claims reporting landscape.
You will play a key role in building and operating a centralized reporting platform, contributing to the development of a single source of truth for claims data on Azure Databricks.
This role combines strong Power BI expertise with hands-on data engineering skills, enabling you to design scalable data models, deliver high-quality dashboards, and ensure robust, performant, and business-aligned reporting solutions. You will work closely with stakeholders across business and technology to translate complex reporting needs into impactful analytics products.
Power BI & Analytics
- Design, develop, and maintain Power BI datasets, semantic models, and reports for global claims reporting
- Implement best-practice data modelling (star schema, claim-centric fact tables, conformed dimensions)
- Develop complex DAX measures for claims KPIs (e.g. incurred, paid, reserves, ultimates, movements)
- Optimise report performance (model size, DAX efficiency, incremental refresh)
- Ensure consistency of KPIs and definitions through a centralized data model
Databricks & Data Engineering
- Work with Azure Databricks (Delta Lake) as the primary reporting data source
- Contribute to the design and implementation of curated data layers (e.g. silver/gold)
- Develop and maintain SQL / Spark-based transformations aligned with reporting requirements
- Support data quality, reconciliation, and traceability from source systems to reporting outputs
- Collaborate with data product teams and follow platform standards and governance
Collaboration & Delivery
- Work closely with Product Owners, stakeholders, and cross-functional teams
- Translate business reporting requirements into scalable technical solutions
- Contribute to agile delivery (backlog refinement, sprint execution, documentation)
- Promote knowledge sharing and best practices within the team
- Strong hands-on experience with Power BI (data modelling, DAX, performance optimisation)
- Proven experience building enterprise-grade dashboards and semantic models
- Practical experience with Azure Databricks (PySpark and/or Spark SQL)
- Solid understanding of Delta Lake and medallion architecture
- Strong grounding in data warehousing and BI architecture principles
- Experience working with large, complex datasets in a reporting environment
- Ability to work independently in a multi-stakeholder, international setting
- Experience in insurance or reinsurance reporting
- Familiarity with claims data (losses, reserves, payments, ultimates, movements)
- Knowledge of data governance, data products, or data mesh concepts
- Experience with financial or actuarial reporting
- Exposure to DevOps / CI-CD for Power BI or Databricks
- Understanding of regulatory or management reporting in insurance
Why join us
People are at the Heart of our Business. By investing in people, we achieve exceptional results for our clients and create new opportunities for our teams to thrive. Check out this page for more details.
Skills Required
- Strong hands-on experience with Power BI
- Proven experience building enterprise-grade dashboards
- Practical experience with Azure Databricks
- Solid understanding of Delta Lake
- Experience working with large, complex datasets
What We Do
Ascent is a design-led software, data and cloud business that specialises in advanced analytics and AI. We design, build and manage cloud-native products, solutions, platforms and experiences on Azure. Our community of engineers, architects, data scientists, experience designers and consultants is here to help customers do something new, or do something better. Ascent is home to 450+ technology specialists across 5 key European locations (UK, Germany, Portugal, Malta and Bulgaria). Our talented, consultative teams deliver a range of solutions, from digital product and service design to mobile app development, API integrations, data engineering, AI and data science. Our modern app, data and infrastructure platforms help businesses leave legacy behind and enable rapid, efficient innovation
