BI/ MI Developer

2 weeks ago

Greater London, United Kingdom Aventum Group Full time

Job Title: MI/BI Developer

Entity: Aventum

Department: Technology

Location: London/ Hybrid


Who We Are


Since its inception, Aventum Group has sought to take a different approach to insurance. We are on a mission to be ‘the most inspiring specialty (re)insurance group in the world’.


At the heart of Aventum are our people. Our employees collaborate in dynamic, service-focused teams. Together, we strive daily to achieve our goals and objectives with a shared dedication to revolutionising the insurance industry for the better.


The Company offers a competitive benefits package via a flexible benefits platform. In addition to core benefits, employees can tailor their benefits according to their individual needs.


Employee development is key to the ongoing development of Aventum on the whole. We invest in our people, empowering them to grow their careers and advance within the Group. Our dynamic culture is rooted in the continuous desire of our people to learn and challenge themselves.


Role Summary


We are seeking a talented Power BI developer to join our Business Intelligence team. The ideal candidate will possess both strong data visualisation skills to delight our customers combined with technical expertise in SQL, Power BI, Power Automate and Microsoft Azure with a strong background in report development, data modelling, data warehousing, strong stakeholder management relationship, good communication and collaboration skills.


Role Accountabilities


Strategy

  • Design, develop, test and deliver Power BI reports and dashboards that provide insightful and actionable business intelligence in line with agreed architecture and design standards.
  • Collaborate with cross functional stakeholders to understand business needs and translate business requirements into technical specifications offering data driven solutions.
  • Connect to various data sources, import, and transform data for business intelligence.
  • Develop calculated measures and columns with DAX in Power BI
  • Optimise BI dashboards with a focus on usability, performance, flexibility, scalability and standardisation.
  • Follow Data Governance Framework and collaborate towards its enforcement
  • Translating requirements and business opportunities into easy-to-understand reports on Power BI.
  • Produce consistent technical documentation for accessibility and understanding.
  • Optimise table design, data models and semantic models for onward consumption by content creators across the firm.
  • Observe configuration management and change control methods.
  • Offer technical support and training for other team members and end-users.
  • Ensure the appropriate configuration, backup and restoration of BI tools and systems.
  • Continuous learning mindset to remain current on new BI technologies, capabilities and best practices.
  • Developing optimised solutions to deliver accurate outputs in a timely manner.
  • Maintaining productive working relationships with all functions within the business.
  • Curious to identify patterns in data and how they relate to the business outcomes.


Operations

  • Work with cross-functional teams to gather, document, and approve business requirements for deep data analysis and reporting projects. Including; developing and updating technical documentation.
  • Create interfaces and mechanisms for the data flow and access of information.
  • Clean the data, removing duplicates, and conforming data to specific data model. Store the normalised data in the data warehouse or in a relational database.
  • Data normalisation and modelling as part of the transform step of ETL/ELT pipelines.
  • Model business logic, extract key performances metrics, and create reusable data structures.
  • Maintain data so that it remains available and usable e.g. SQL (Basic, Advanced modelling, Efficient, Big Data and Programmatic).
  • Data managing such as reshaping, aggregating, joining disparate sources, etc. small-scale ETL, API interaction, and automation e.g. Python.
  • Interface with cross-functional teams to build centralised tools that will allow for rapid defect detection and repair.
  • Analyse and synthesize large data streams across multiple inputs.
  • Any additional duties as assigned.


Role Requirements

  • Degree level education in relevant subject (e.g. finance, maths, physics etc.)
  • Other beneficial qualifications (e.g. MBA, CFA, etc.)
  • Previous experience and good understanding of Azure/Fabric data tools
  • Project Management and experience with software development methodologies such as Agile


Skills and Abilities

  • Proficient in Structured Query Language (SQL), Critical Thinking, R or Python-Statistical Programming, Data Visualization, Presentation Skills, Machine Learning & Data Science techniques, Econometrics.
  • Strong Data Mapping skills, knowledge of Data Warehousing Concepts, conceptual to Logical to physical Modelling Skills.
  • Strong Business Analyst skills including process mapping, requirements gathering, stakeholder management.
  • Proficient in Power BI.
  • Proven ability to motivate and influence small and/or large technical teams.
  • Excellent Microsoft Office skills – Excel (data manipulation, lookups, pivot tables, macros) and PowerPoint (clear, concise, well formatted reporting).
  • Business focused and able to establish and maintain stakeholder relationships.
  • Understanding of project management, change management and systems processes.
  • Strong interpersonal and presentation skills with the ability to influence others.
  • Platforms & Tools: Cloud Computing platforms (ADLS Gen2), Microsoft Stack (Synapse, DataBricks, Fabric, Profisee, Purview, Power BI).
  • Languages: Python, SQL, T-SQL, SSIS.
  • DB: Azure SQL Database, Cosmos DB, NoSQL.
  • Methodologies: Agile, DevOps.


Management Duties

  • No


We are an equal opportunity employer, and we are proud to share that 93% of our employees say they can be themselves at work. We aim to hire our industry's finest people because the best people drive the best outcomes. And we forever challenge the status quo because we know there are always ways to improve things. Because together, we're limitless.


We value applicants from all backgrounds and foster a culture of inclusivity. We understand the need for flexibility, so work in a hybrid model. Please let us know if you require any reasonable adjustments during the recruitment process.


FCA Conduct Rules

Under the Senior Managers and Certification Regime the FCA and Aventum expects that:

  1. You must act with integrity
  2. You must act with due skill, care and diligence
  3. You must be open and cooperative with the FCA, the PRA and other regulators.
  4. You must pay due regard to the interests of customers and treat them fairly.
  5. You must observe proper standards of market conduct
  6. You must act to deliver good outcomes for retail customers

  • BI/ MI Developer

    3 weeks ago

    Greater London, United Kingdom Aventum Group Full time

    Job Title: MI/BI DeveloperEntity: AventumDepartment: TechnologyLocation: London/ HybridWho We AreSince its inception, Aventum Group has sought to take a different approach to insurance. We are on a mission to be ‘the most inspiring specialty (re)insurance group in the world’.At the heart of Aventum are our people. Our employees collaborate in dynamic,...

  • BI/ MI Developer

    3 weeks ago

    Greater London, United Kingdom Aventum Group Full time

    Job Title: MI/BI DeveloperEntity: AventumDepartment: TechnologyLocation: London/ Hybrid Who We AreSince its inception, Aventum Group has sought to take a different approach to insurance. We are on a mission to be ‘the most inspiring specialty (re)insurance group in the world’. At the heart of Aventum are our people. Our employees collaborate in dynamic,...

  • BI/ MI Developer

    3 weeks ago

    Greater London, United Kingdom Aventum Group Full time

    Job Title: MI/BI DeveloperEntity: AventumDepartment: TechnologyLocation: London/ Hybrid Who We AreSince its inception, Aventum Group has sought to take a different approach to insurance. We are on a mission to be ‘the most inspiring specialty (re)insurance group in the world’. At the heart of Aventum are our people. Our employees collaborate in dynamic,...

  • BI/ MI Developer

    3 weeks ago

    Greater London, United Kingdom Aventum Group Full time

    Job Title: MI/BI DeveloperEntity: AventumDepartment: TechnologyLocation: London/ Hybrid Who We AreSince its inception, Aventum Group has sought to take a different approach to insurance. We are on a mission to be ‘the most inspiring specialty (re)insurance group in the world’. At the heart of Aventum are our people. Our employees collaborate in dynamic,...

  • BI/ MI Developer

    3 weeks ago

    Greater London, United Kingdom Aventum Group Full time

    Job Title: MI/BI DeveloperEntity: AventumDepartment: TechnologyLocation: London/ HybridWho We AreSince its inception, Aventum Group has sought to take a different approach to insurance. We are on a mission to be ‘the most inspiring specialty (re)insurance group in the world’.At the heart of Aventum are our people. Our employees collaborate in dynamic,...

  • BI/ MI Developer

    3 weeks ago

    Greater London, United Kingdom Aventum Group Full time

    Job Title: MI/BI DeveloperEntity: AventumDepartment: TechnologyLocation: London/ HybridWho We AreSince its inception, Aventum Group has sought to take a different approach to insurance. We are on a mission to be ‘the most inspiring specialty (re)insurance group in the world’.At the heart of Aventum are our people. Our employees collaborate in dynamic,...

  • BI/MI Developer

    3 weeks ago

    London, Greater London, United Kingdom Aventum Group Full time

    Job Title: MI/BI DeveloperAventum Group is seeking a talented Power BI developer to join our Business Intelligence team. The ideal candidate will possess both strong data visualisation skills to delight our customers combined with technical expertise in SQL, Power BI, Power Automate and Microsoft Azure with a strong background in report development, data...

  • BI/ MI Developer

    3 weeks ago

    London, United Kingdom Aventum Group Full time

    Job Title: MI/BI Developer Entity: Aventum Department: Technology Location: London/ Hybrid Who We Are Since its inception, Aventum Group has sought to take a different approach to insurance. We are on a mission to be ‘the most inspiring specialty (re)insurance group in the world’. At the heart of Aventum are our people. Our employees...

  • BI/ MI Developer

    3 weeks ago

    London, United Kingdom Aventum Group Full time

    Job Title: MI/BI Developer Entity: Aventum Department: Technology Location: London/ Hybrid Who We Are Since its inception, Aventum Group has sought to take a different approach to insurance. We are on a mission to be ‘the most inspiring specialty (re)insurance group in the world’. At the heart of Aventum are our people. Our employees...

  • BI/ MI Developer

    7 days ago

    London, United Kingdom Aventum Group Full time

    Job Title: MI/BI Developer Entity: Aventum Department: Technology Location: London/ Hybrid Who We Are Since its inception, Aventum Group has sought to take a different approach to insurance. We are on a mission to be ‘the most inspiring specialty (re)insurance group in the world’. At the heart of Aventum are our people. Our...

  • MI Analyst

    3 weeks ago

    London, United Kingdom Eames Consulting Full time

    Job DescriptionEames is currently partnered with a leading specialities insurer who is on the search for an Portfolio MI analyst to join their team.The Management Information department serves as a crucial support function for my client, providing vital information and insights to facilitate decision-making across the business. As the backbone of data-driven...

  • Data and Mi Specialist

    5 months ago

    London, United Kingdom Deltra Full time

    **Job title**:Data and MI Specialist **Job type**:Permanent **Location**:London - Hybrid working - 2 days in the office Are you a passionate Data and Management Information (MI) Specialist with expertise in underwriting within the insurance domain. Analysing and ensuring data quality, managing quality migrations, and handling policy and premium...

  • MI Analyst

    3 months ago

    London, United Kingdom Eames Consulting Full time

    Eames is currently partnered with a leading specialities insurer who is on the search for an Portfolio MI analyst to join their team.The Management Information department serves as a crucial support function for my client, providing vital information and insights to facilitate decision-making across the business. As the backbone of data-driven business...

  • MI Analyst

    3 months ago

    London,, UK, United Kingdom Eames Consulting Full time

    Eames is currently partnered with a leading specialities insurer who is on the search for an Portfolio MI analyst to join their team.The Management Information department serves as a crucial support function for my client, providing vital information and insights to facilitate decision-making across the business. As the backbone of data-driven business...

  • MI Analyst

    3 months ago

    London, United Kingdom Eames Consulting Full time

    Eames is currently partnered with a leading specialities insurer who is on the search for an Portfolio MI analyst to join their team.The Management Information department serves as a crucial support function for my client, providing vital information and insights to facilitate decision-making across the business. As the backbone of data-driven business...

  • MI Analyst

    3 months ago

    London Area, United Kingdom Eames Consulting Full time

    Eames is currently partnered with a leading specialities insurer who is on the search for an Portfolio MI analyst to join their team.The Management Information department serves as a crucial support function for my client, providing vital information and insights to facilitate decision-making across the business. As the backbone of data-driven business...

  • Senior MIS Developer

    4 weeks ago

    London, Greater London, United Kingdom Hawk 3 Talent Solutions Full time

    Hawk 3 Talent Solutions is seeking a Senior MIS Developer to lead a team of developers in designing, developing, testing, and implementing MIS solutions. The successful candidate will report to the MIS Manager and be responsible for ensuring quality, timely deliveries of MIS solutions in accordance with expectations.The ideal candidate will have at least 5...

  • Senior MIS Developer

    4 weeks ago

    London, Greater London, United Kingdom Hawk 3 Talent Solutions Full time

    Senior MIS Developer OpportunityHawk 3 Talent Solutions is seeking a highly skilled Senior MIS Developer to join our client's team in Warrington. As a Senior MIS Developer, you will lead a team of developers in designing, developing, testing, and implementing MIS solutions. You will work closely with the MIS Manager and other stakeholders to ensure timely...

  • Senior MIS Developer

    1 month ago

    London, Greater London, United Kingdom JAM Full time

    Senior MIS Developer OpportunityWe are seeking a highly skilled Senior MIS Developer to lead our team in designing, developing, and implementing MIS solutions for our clients.About the RoleAs a Senior MIS Developer, you will be responsible for:Leading a team of MIS developers in designing, developing, and testing MIS solutionsLiaising with developers,...

  • Senior MIS Developer

    1 month ago

    London, Greater London, United Kingdom JAM Full time

    Senior MIS Developer OpportunityWe are seeking a highly skilled Senior MIS Developer to lead our team in designing, developing, and implementing MIS solutions for our clients.About the RoleAs a Senior MIS Developer, you will be responsible for:Leading a team of MIS developers in designing, developing, and testing MIS solutionsLiaising with developers,...