Business Intelligence Developer

Ryan Specialty; Greater London; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading insurance firm in Greater London is seeking a BI Developer to transform data into meaningful insights. The ideal candidate will have strong SQL and Power BI skills, with experience in developing data pipelines and ensuring data integrity. This position offers the opportunity to work collaboratively within a dynamic team and contribute to impactful BI solutions in a fast-paced environment.

Qualifications

• Hands-on experience with SQL server/Azure SQL and T-SQL.
• Proficiency in Power BI (desktop) and SSRS.
• Strong understanding of data warehousing and data modelling.

Responsibilities

• Collaborate with stakeholders to gather reporting requirements.
• Develop and maintain data pipelines in Databricks.
• Implement data quality checks and validation rules.

Skills

SQL

Power BI

Data Analysis

Data Quality Assurance

Problem-Solving

Collaboration

Tools

Azure SQL

Databricks

SSRS

DevOps/Git

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.