Business Intelligence (BI) Developer

Ascot Group; Camden Town; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading specialty risk underwriting organization seeks a skilled BI developer to enhance Business Intelligence solutions. This hybrid role involves collaborating with stakeholders to create actionable insights through dashboards and analytics tools. The ideal candidate has strong expertise in BI, the insurance industry, and relevant programming skills, ensuring data quality and effectiveness across the organization.

Qualifications

• Proven record in delivering BI solutions.
• Firsthand experience with BI concepts, data warehousing, data modelling and visualisation.
• Experience in defining, designing, building, testing, and deploying BI solutions.

Responsibilities

• Collaborate with stakeholders to identify challenges and opportunities.
• Develop dashboards, reports, and analytics tools.
• Ensure data quality, integrity, and security.

Skills

Experience in insurance industry, preferably Lloyd's/London market

Delivery of BI solutions

Experience with BI concepts and data warehousing

Proficient in Power BI, DAX, SQL Server, SSIS, SSRS

Excellent interpersonal skills

Proficiency in SQL & Python

Experience with Microsoft Azure

Understanding of Data Quality and Master Data Management

Agile and Scrum familiarity

Knowledge of machine learning and AI applications in BI

Education

Degree or equivalent in Computer Science or related field

Job description

The role is pivotal to leveraging Business Intelligence (BI) and analytics across Ascot's Syndicate and Bermuda entities. Focused on building innovative and effective BI solutions to harness the power of data to gain a competitive edge. As a BI developer, your responsible is to collaborate with stakeholders to identify business challenges and opportunities, develop dashboards, reports and analytics tools that provide clear, actionable insights. The role is based in Ascot's office in the City of London and will be a hybrid home/office working model.

Detailed Duties

• Understand BI needs, challenges, and requirements.
• Delivers new insights and capabilities.
• Ownership of stakeholder relationships and solutions.
• Solving business problems using BI.
• Developing the BI offering aligned with business requirements.
• Consult with third party vendors.
• Ensuring BI is being effectively managed.
• Ensure data quality, integrity, and security.
• Promote the importance of BI.

Must have

• Experience: insurance industry, preferably Lloyd's/London market.
• Delivery: Proven record in delivering BI solutions
• Education: a degree or equivalent in Computer Science or a related field.
• BI and Data Warehousing: Firsthand experience with BI concepts, data warehousing, data modelling and visualisation.
• Microsoft BI Stack: Proficient experience with Power BI, DAX, SQL Server, SSIS and SSRS.
• Stakeholders: Excellent interpersonal skills and relationship management.
• Programming Expertise: Proficiency in programming languages like SQL & Python.
• Cloud Platforms: Experience with Microsoft Azure, particularly Azure Data Factory, Azure SQL Database, and Azure Synapse Analytics.
• Software Development Life Cycle: Experience in defining, designing, building, testing, and deploying BI solutions.

Desirable

• Data Governance: Knowledge of Data Quality and Master Data Management methodologies and systems.
• Agile and Scrum: Experience working in Agile environments using DevOps and familiarity with Scrum methodologies, especially in a data context.
• Integration: Experience integrating BI solutions with other enterprise systems and bespoke industry-specific software.
• Documentation: Able to produce high quality supporting materials.
• Advance Analytics: Knowledge of machine learning and AI applications in BI.

Skills/Attributes

• Analytical Thinking: Ability to dissect complex problems and drive data-driven decisions.
• Technical Acumen: Strong grasp of technical concepts, allowing effective communication with data engineers, analysts, and architects.
• Diligence: Ensuring data accuracy and integrity in all products overseen.
• Continuous Innovation: Commitment to staying ahead of BI trends and driving innovation across the function.
• Problem-Solving: Ability to troubleshoot issues, foresee potential pitfalls, and proactively devise solutions.
• Business Focused: Understands the importance of transforming data into invaluable insights to enable better business decisions.
• Adaptability: Flexibility to adapt to changing business needs.

This is an opportunity to join Ascot Group - one of the world's preeminent specialty risk underwriting organizations. Designed as a modern-era company operating through an ecosystem of interconnected global operating platforms, we're bound by a common mission and purpose: One Ascot. Our greatest strength is a talented team who flourish in a collaborative, inclusive, and entrepreneurial culture, steeped in underwriting excellence, integrity, and a passion to find a better way, The Ascot Way. The Ascot Way guides our people and our organization. Our underwriting platforms collaborate to find creative ways to deploy our capital in a true cross-product and cross-platform approach. These platforms work as one, deploying our capital creatively through our unique Fusion Model: Client Centric, Risk Centric, Technology Centric. Built to be resilient, Ascot maximizes client financial security while delivering bespoke products and world class service - both pre- and post-claims. Ascot exists to solve for our clients' brightest tomorrow, through agility, collaboration, resilience, and discipline.