Business Intelligence Developer

Ryan Specialty Group; City Of London; On-site; GBP 45,000 - 65,000; Full time

Job summary

A leading insurance services provider is seeking a BI Developer to transform data into insights. You'll work with SQL, Power BI, and databricks to create centralized BI solutions. The ideal candidate has hands-on experience with data validation and is proficient in report development. This role offers the chance to work in a dynamic team environment focused on data accuracy and integrity.

Qualifications

• Hands-on experience with SQL server/Azure SQL including data validation.
• Proficiency in Power BI desktop and SSRS for report development.
• Experience using databricks for BI solutions.
• Strong analytical and problem-solving skills.

Responsibilities

• Collaborate with stakeholders to gather reporting requirements.
• Develop and maintain data pipelines in databricks.
• Create visualizations in Power BI and SSRS.
• Provide support for BI solutions and troubleshoot issues.
• Ensure data models align with underwriting systems.

Skills

SQL server/Azure SQL

Power BI

SSRS

databricks

data warehousing

data modelling

DAX

DevOps/Git

analytical skills

problem-solving skills

Job description

Position Summary:

As a BI Developer at Ryan Specialty Underwriting Managers International (RSUMI), you will play a pivotal role in transforming data into meaningful insights. Leveraging your expertise in SQL, Power BI, Databricks and other BI tools, you will collaborate closely with cross-functional teams to develop and maintain centralised BI solutions that meet the needs of our stakeholders. This is an exciting opportunity for a motivated individual to further develop their skills in a fast-paced and collaborative environment.

Location:

London - UK

What will your job entail?

Key Responsibilities

• Collaborate with key stakeholders to gather reporting requirements, understand data needs and deliver on report change requests across RSUMI teams.
• Develop and maintain all aspects of data pipelines in databricks to support the functioning of our reporting suite.
• Develop and maintain semantic data models to visualize key metrics and insights in high performance reporting, hosted in both Power BI and SSRS.
• Provide technical support and troubleshooting for BI solutions, addressing issues in a timely manner.
• Work closely with Product Managers in the Tech team to ensure BI data models and definitions are aligned with underwriting systems.
• Perform data profiling and analysis to identify anomalies and inconsistencies in the data.
• Implement and maintain data quality checks and validation rules in collaboration with stakeholders, to ensure data accuracy and integrity.

Qualifications

• Hands‑on experience with SQL server/Azure SQL and T‑SQL, including data validation, manipulation, and optimization.
• Proficiency in Power BI (desktop) and SSRS, including report development, data modelling and DAX.
• Experience with Power BI Service and DevOps/Git (or similar).
• Experience using databricks for BI solutions.
• Strong understanding of data warehousing and data modelling concepts and methodologies.
• Strong analytical and problem‑solving skills, with the ability to translate business requirements into technical solutions.
• Ability to work collaboratively in a cross‑functional team environment.
• Insurance experience is a plus.

Disclaimer

Ryan Specialty is an Equal Opportunity Employer. We are committed to building and sustaining a diverse workforce throughout the organization. Our vision is an inclusive and equitable workplace where all employees are valued for and evaluated on their performance and contributions. Differences in race, creed, color, religious beliefs, physical or mental capabilities, gender identity or expression, sexual orientation, and many other characteristics bring together varied perspectives and add value to the service we provide our clients, trading partners, and communities. This policy extends to all aspects of our employment practices, including but not limited to, recruiting, hiring, discipline, firing, promoting, transferring, compensation, benefits, training, leaves of absence, and other terms, conditions, and benefits of employment.