Business Intelligence Developer

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

Job summary

A leading insurance organization in London is seeking an Application Developer to enhance BI solutions. You will work closely with stakeholders on data needs, develop data pipelines, and ensure data accuracy. Candidates should have strong SQL, Power BI, and databricks experience, along with the ability to translate business needs into technical solutions. This role offers a collaborative team environment and values diverse perspectives.

Qualifications

• Experience with data validation, manipulation, and optimization.
• Experience in report development and data modelling.
• Familiarity with insurance industry is a plus.

Responsibilities

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

Skills

Hands-on experience with SQL server/Azure SQL and T-SQL

Proficiency in Power BI (desktop) and SSRS

Experience using databricks for BI solutions

Strong analytical and problem-solving skills

Ability to work collaboratively in a cross-functional team

Tools

Power BI

SSRS

DevOps/Git

Databricks

Job description

Overview

Position Summary: This position will analyze requirements and transform them into technical designs. Also, this role will plan, develop, test, implement, document, and maintain applications. The application developer will design and develop application components to external and third-party systems. The application developer is required to work with the business teams to determine and implement efficiencies and new functions for all necessary business operations.

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 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.