BI/ MI Developer

2 months 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

  • MI/BI Developer

    6 hours ago

    Greater Cardiff Area, United Kingdom Identify Solutions Full time

    MI/BI DeveloperWant autonomy over MI/BI, new apps development & to play a key role in a major Cloud transformation for a respected business with 7.5m customers (...and 3m lines of data)? If you’re a SQL expert and want to work with Power BI, you'll love this MI/BI Developer role with my client in Cardiff!Salary £50-55k, 10% bonus, 10% pension...

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

  • 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

    2 months 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

    2 months 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, 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

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

  • BI/ MI Developer

    2 months 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

    2 weeks ago

    London, UK, UK, 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 Data Developer

    11 hours ago

    Horwich, Greater Manchester, United Kingdom ExamWorks UK Full time €40,000

    Reporting to the Head Of Data, the Power BI Developer is responsible for designing, developing and deploying interactive and insightful data visualisation, reports and dashboards on Microsoft Power BI. The Power BI Developer will work as part of the MI team, within the wider IT department, to develop and implement new MI data marts and warehouses, to...

  • BI/ MI Developer

    4 weeks ago

    London, Greater London, United Kingdom Aventum Group Full time

    Job Title: Power BI DeveloperAt Aventum Group, we are seeking a talented Power BI developer to join our Business Intelligence team. The ideal candidate will possess strong data visualization skills, combined with technical expertise in SQL, Power BI, Power Automate, and Microsoft Azure. The role involves designing, developing, testing, and delivering Power...

  • Power BI Developer

    11 hours ago

    Horwich, Greater Manchester, United Kingdom ExamWorks UK Full time €40,000

    What we are looking for: Reporting to the Head Of Data, the Power BI Developer is responsible for designing, developing and deploying interactive and insightful data visualisation, reports and dashboards on Microsoft Power BI. The Power BI Developer will work as part of the MI team, within the wider IT department, to develop and implement new MI data...

  • Data and Mi Specialist

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

  • Technical Tutor

    3 days ago

    London, Greater London, United Kingdom MI Skills Development Centre Full time

    We are looking for a highly motivated Technical Tutor to join our team at MI Skills Development Centre. As an IT tutor, you will be responsible for planning and delivering engaging IT sessions, inspiring learners to excel in the ever-evolving field of technology.Key ResponsibilitiesThe ideal candidate will have a strong background in IT, Computer Science, or...

  • MI and Reporting Solutions Architect

    4 weeks ago

    London, Greater London, United Kingdom Jas Gujral Full time

    **Job Summary**Jas Gujral is looking for a seasoned MI and Reporting Solutions Architect to design and implement data management solutions that meet the needs of our stakeholders. This 12-month full-time contract position offers a unique opportunity to work with a talented team.Your key responsibilities will include:Developing MI and Reports predominantly...

  • MIS System Coordinator

    3 weeks ago

    London, Greater London, United Kingdom Future Education Full time

    Data Manager Job Description:We are seeking a highly organized and detail-oriented Data Manager to join our team at FUTURE EDUCATION.As a Data Manager, you will be responsible for managing the school's data systems, including updating the MIS system, creating and managing timetables, and maintaining staff user accounts.Main Responsibilities:Ensure accurate...

  • Senior MI Business Analyst Lead

    1 day ago

    London, Greater London, United Kingdom Onyx-Conseil Full time

    Job Title: Senior MI Business Analyst LeadAbout the Role:We are seeking a highly skilled Senior MI Business Analyst to join our team at Onyx-Conseil. As a Senior MI Business Analyst, you will play a key role in helping our organisation review business and financial performance based on data and facts.Key Responsibilities:Develop technical and business...

  • BI Developer

    2 months ago

    London, United Kingdom Aventum Group Full time

    Job Title: MI/BI Developer Entity: Aventum Technology Location: London/ Hybrid 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’. Our employees collaborate in dynamic, service-focused teams. Together, we strive...

  • BI Developer

    2 months ago

    London, United Kingdom Aventum Group Full time

    Job Title: MI/BI Developer Entity: Aventum Technology Location: London/ Hybrid 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’. Our employees collaborate in dynamic, service-focused teams. Together, we strive...