Business Intelligence Analyst

The Ardonagh Group; Mullingar; On-site; EUR 60,000 - 90,000; Full time

Job summary

The Ardonagh Analytics Lab in Mullingar is seeking a Business Intelligence Specialist to design, develop and optimise Power BI reporting solutions that empower leaders to make informed decisions. You will create trusted dashboards and semantic models, collaborating across The Ardonagh Group to turn data into clear business insights.

You will work with Power BI, Microsoft Fabric, DAX and SQL to improve performance, governance and documentation, supporting stakeholders through end-to-end reporting

Qualifications

• Proven experience developing and supporting Power BI solutions in a commercial environment.
• Strong expertise in: Power BI Desktop, Power BI Service, DAX, Power Query, T-SQL, semantic data modelling and dashboard performance optimisation.
• Advanced T-SQL development experience including CTEs, window functions, temporary tables, table-valued functions, complex query design and optimisation, stored procedures and SQL views.

Responsibilities

• Design and develop intuitive, visually engaging, high-performing Power BI dashboards and reports.
• Translate business requirements, KPIs and stakeholder needs into impactful reporting solutions.
• Create drill-through experiences, interactive visuals, filters and navigation features that enhance user experience.
• Partner with UX/UI colleagues to apply established branding, design standards and best practices.

Skills

Power BI Desktop

Power BI Service

DAX

Power Query

T-SQL

Semantic data modelling

Dashboard performance optimisation

Tools

Microsoft Fabric

Job description

What You'll Be Doing

Help Shape the Future of Data-Driven Insurance

The Ardonagh Analytics Lab is an innovative centre of excellence established by The Ardonagh Group in Mullingar, Co. Westmeath. Our mission is to unlock the power of data, delivering actionable insights that support colleagues, clients and insurer partners across a global insurance network of more than 12,000 professionals.

By combining advanced analytics, business intelligence and deep industry expertise, we help organisations better understand risk, predict future outcomes and make smarter decisions in an increasingly complex world.

As we continue to grow, we're looking for a talented Business Intelligence Specialist to join our Business Intelligence team. This is an exciting opportunity for a data-driven professional who is passionate about transforming complex information into meaningful insights through world-class reporting and visualisation solutions.

The Opportunity

As a Business Intelligence Specialist, you will design, develop and optimise Power BI reporting solutions that enable business leaders to make informed decisions with confidence. Working at the intersection of data, technology, design and business strategy, you'll create trusted dashboards, semantic models and reporting assets that support key stakeholders across The Ardonagh Group.

You will play a key role in shaping how data is consumed across the organisation while working with modern Microsoft technologies, including Power BI and Microsoft Fabric.

Reporting & Dashboard Development

• Design and develop intuitive, visually engaging, high-performing Power BI dashboards and reports.
• Translate business requirements, KPIs and stakeholder needs into impactful reporting solutions.
• Create drill-through experiences, interactive visuals, filters and navigation features that enhance user experience.
• Partner with UX/UI colleagues to apply established branding, design standards and best practices.

Data Modelling & Analytics

• Design, maintain and optimise Power BI semantic models.
• Develop robust DAX measures and calculations using industry best practices.
• Ensure reporting solutions are accurate, scalable and easy to maintain.
• Analyse and improve dashboard performance, load times and model efficiency.

Microsoft Fabric & Governance

• Work within Microsoft Fabric and Power BI Service environments, supporting workspaces, datasets, deployments and refresh processes.
• Implement security controls including workspace permissions, audience management and Row-Level Security (RLS).
• Support controlled deployment and governance practices across reporting environments.

Documentation & Support

• Produce clear documentation covering dashboards, semantic models, data sources and business logic.
• Support UAT processes, change requests and post-implementation enhancements.
• Monitor reporting operations, refresh schedules and user access requests.
• Contribute to continuous improvement initiatives across the Analytics Lab.

About You

You'll be a technically strong BI professional with a passion for delivering solutions that create real business value. You'll be comfortable working with multiple stakeholders, translating complex requirements into intuitive reporting experiences and balancing project delivery with ongoing support activities.

Skills & Experience

• Proven experience developing and supporting Power BI solutions in a commercial environment.
• Strong expertise in:
  • Power BI Desktop
  • Power BI Service
  • DAX
  • Power Query
  • T-SQL
  • Semantic data modelling
  • Dashboard performance optimisation
• Advanced T-SQL development experience, including:
  • CTEs
  • Window functions
  • Temporary tables
  • Table-valued functions
  • Complex query design and optimisation
  • Stored procedures and SQL views
• Experience translating business requirements into scalable BI and reporting solutions.
• Strong understanding of dimensional modelling, reporting layers and data platform concepts.
• Experience managing stakeholder relationships and competing priorities.

Desirable

• Experience working with Microsoft Fabric.
• Knowledge of Fabric Data Factory pipelines and Spark notebooks.
• Understanding of data ingestion, transformation and orchestration processes.
• Exposure to metadata-driven ETL frameworks and reusable data platform architectures.
• Experience within insurance, financial services or a data analytics function.

What We're Looking For

• Detail-oriented and quality-focused
• Comfortable working independently while collaborating across teams
• Passionate about turning data into business value
• A strong communicator who can explain technical concepts to non-technical audiences
• Proactive in identifying improvements and solving problems

Why Join Ardonagh Analytics Lab?

At Ardonagh Analytics Lab, you'll work with cutting-edge technology, complex and meaningful data sets, and a highly collaborative team committed to innovation. You'll have the opportunity to influence decision-making across a global organisation while developing your expertise in one of the most exciting areas of modern analytics.

The Company

In an industry that never stands still, neither do we. The Ardonagh Group was founded in 2017 and has grown to become the UK’s largest independent insurance distribution platform and a top 20 broker globally.

Our best-in-class entrepreneurial and specialist brands span a network of 150+ locations worldwide and have a combined workforce of more than c.12,000 people. Across our portfolio, we offer a highly diversified range of insurance-related products and services across the full insurance value chain in the UK, Ireland and broader international markets.

From complex multinational corporations to individuals purchasing personal insurance policies, our understanding of the communities we serve, together with our scale and breadth, allows us to deliver a broad range of product and risk solutions to meet the needs of a rapidly evolving market.

If you approach life with a sense of adventure you might just find what you need at Ardonagh to bring your ambition to life.

Find out more about Ardonagh’s world of opportunity on LinkedIn or visit www.ardonagh.com.

#AAL