Analytics Engineer

• Develop analytics engineering and reporting solutions that help business users access trusted insight and make informed decisions
• Work with business stakeholders, Product Owners, Business Analysts and other Data colleagues to understand information needs and translate them into clear, deliverable requirements
• Design, build and maintain semantic models, datasets and reporting solutions using Power BI, paginated reports and Databricks
• Improve report and dataset performance by reviewing data models, DAX calculations, queries and refresh approaches
• Apply data validation, reconciliation and testing to ensure analytics outputs are accurate and reliable
• Document data sources, logic, refresh schedules, access requirements and support considerations
• Follow standards for modelling, naming, testing, deployment and version control
• Support rationalisation and redevelopment of legacy reporting solutions for migration onto modern platforms
• Communicate analytics outputs, assumptions, risks and limitations to technical and non-technical audiences
• Plan and manage assigned work items, estimates, dependencies, risks and blockers
• Participate in peer review, knowledge sharing and team ceremonies
• Use analytics engineering practices, automation and AI-assisted tools to improve delivery quality and efficiency
• Keep abreast of developments in data, analytics and reporting technology
• Manage own task list and agreed priorities
• Undertake other ad-hoc duties as required

Requirements

• Hands-on development experience with Power BI, including DAX, tabular/semantic models and paginated reports
• Good understanding of analytics engineering principles, semantic/dimensional modelling and cloud-based data platforms
• Experience building clear, reliable and user-friendly reports and dashboards that support business decision making
• Good SQL skills for querying, analysing and transforming data
• Familiarity with Azure DevOps, Git and development lifecycle practices, including peer review, testing and deployment processes
• Experience working in an Agile or Scrum environment and contributing effectively within cross-functional teams
• Analytical and problem-solving skills with good attention to detail and a continuous improvement mindset
• Good communication skills, with the ability to explain analysis, assumptions and solution choices clearly to technical and non-technical audiences
• Experience with AI-assisted development tools and copilots to improve productivity and delivery outcomes is advantageous
• Familiarity with Tabular Editor and Databricks is desirable
• Familiarity with specialty (re)insurance or Lloyd’s market data such as bordereaux, delegated authority, underwriting and claims is advantageous

Core Competencies

Demonstrates expertise in developing analytics engineering solutions and reporting tools, particularly with Power BI and DAX, while ensuring data accuracy and reliability through validation and testing. Proficient in collaborating with cross-functional teams to translate business needs into actionable insights and user-friendly reports.

Highest-signal resume keywords

• Power BI Development
• DAX Calculations
• SQL Querying
• Agile Methodologies
• Analytics Engineering Principles

Hard Skills

• Power BI
• DAX
• SQL
• Semantic Modelling
• Data Validation
• Reporting Solutions
• Data Analysis
• Automation Tools
• AI-Assisted Development
• Tabular Models

Soft Skills

• Analytical Skills
• Problem-Solving
• Attention to Detail
• Communication Skills
• Continuous Improvement Mindset

Industry Keywords

• Analytics Engineering
• Cross-Functional Teams
• Lloyd's Market Data
• Underwriting
• Claims

Tools & Technologies

• Azure DevOps
• Git
• Databricks
• Tabular Editor
• Paginated Reports