Business Intelligence Developer

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 Innovisk and other RSUM teams.
• Develop and maintain SQL queries, stored procedures, and scripts in the data warehouse to support the functioning of our reporting suite.
• Develop and maintain data models in Azure Analysis Services 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 our SalesForce based underwriting system.
• 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.
• Work closely with ETL developers to validate data transformations and mappings.

Qualifications

• 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.
• Strong understanding of data warehousing 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.
• Experience with Power BI Service and DevOps/Git is a plus.
• Insurance experience is nice to have but not required.

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.