Job Description
Title: Business Intelligence & Insight Manager
Reporting to: Head of Data
Location: Hybrid - 2/3 days in our London Office
Job description
This newly created Business Intelligence & Insight Manager role aims to effectively lead and coordinate a team of MI analysts, Data analysts and BI Developers to generate, analyse and present information for key operational and business activities to deliver insightful analysis and reporting to support Business Managers. And may also supervise other support staff members along with serving as the liaison for external contractors or service providers.
The Strategy
* Responsible for owning the MI, BI and Analytics relationship and working closely with operational leaders to ensure all reporting meets the business requirements.
* Importantly, this role must ensure that these functions are carried out in line with controlled policies, procedures, and legislative and regulatory requirements while providing exceptional internal customer service and driving business growth.
* Play a key role in developing the roadmap for the data platform and reporting solutions.
* Act as a key curator of data within the team, responsible for the collection, governance, storage, security, and accessibility of all our data, from raw data to transformed business-facing data.
* Responsible for creating an MI and BI Framework that will be followed by the team to ensure a common way of working and avoiding data quality issues.
* Responsible for the comprehensive efforts related to designing, implementing, and operating BI data analysis systems. Take a lead role in driving the BI strategy and ensuring the department meets organizational goals. May also perform BI analyst tasks in addition to their supervisory duties.
* Responsible for BI/MI lifecycle management, the design, development and management approach to BI that incorporates business users into the design process and focuses on generating the data models, database objects, data integration mappings and front-end semantic layers directly from the business user input.
* Overall responsibility for management, prioritisation, and delivery of data-driven initiatives within the organisation.
* Recognise and assist in delivering the broader business benefits which result from continuous incremental improvements through business change initiatives and small enhancements.
* Optimise commercial and enterprise data within the organisation (Products / Sales / Transactional / Financial / Claims).
* Ensure that data is well structured and of sufficient quality to be leveraged to provide meaningful insights.
* Help define a data and analytics strategy that optimises business data according to industry best practices.
* Utilise knowledge of insurance industry processes combined with the effective use of data to aid decision-making (Policies / Underwriting / Claims Handling / Bordereaux).
* Collaborate with stakeholders across the organisation to understand their data requirements (wants and needs), identify applicable data sources and solutions, and ensure data quality and integrity.
* Facilitate the generation of Dashboards, Reporting Packs and other visualisations for summarising key business information to senior management (KPIs, metrics, patterns, trends, etc.).
* Keen to showcase and keep up to date with developments in enterprise BI tools, especially Microsoft Power BI
* People management and motivation experience, specifically data management and analysis, would be advantageous.
* Maintaining productive working relationships with all functions within the business
Operations
* Implementation of policies and procedures as well as documentation & governance
* Create a Centre of Excellence for Insight and analysis for the whole Aventum Group
* Identify data quality issues and support the data governance initiative by developing exceptions.
* Model business logic, extract key performance 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)
* Support Data munging such as reshaping, aggregating, joining disparate sources, etc...small-scale ETL, API interaction, and automation e.g. Python
* Support the data normalisation and modelling as part of the transform step of ETL/ELT pipelines.
* Dive deep to create trustable and understandable data for our DA to create insights on how well Aventum is taking care of the customer as it relates to customer experience and satisfaction and more.
Qualifications
* Degree-level education in relevant subjects (e.g. finance, maths, physics, etc.)
* Other beneficial qualifications (e.g. MBA, CFA, etc.)
* 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, and Logical Modelling Skills.
* Strong Business Analyst skills, including process mapping, requirements gathering, and stakeholder management
* Previous experience and good understanding of Azure data tools
* Proficient in Power BI
* Proven ability to motivate and influence small and/or large technical teams
* Experience in working to define strategies and goals, taking ownership of the strategy
* Project Management and experience with software development methodologies such as Agile
* Excellent Microsoft Office skills – Excel (data manipulation, lookups, pivot tables, macros) and PowerPoint (Clear, concise, well-formatted reporting).
* Managerial and communication skills - ability to communicate technical issues to non-technical audiences
* Business-focused and able to establish and maintain stakeholder relationships
* Problem-solving
* 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), Azure Service Bus, Apache Airflow, Apache Iceberg, Apache Spark, Apache Hudi, Apache Kafka, Power BI, BigQuery, DeltaLake, Azure DevOps, Azure Monitor, Azure Data Factory, SQL Server, Azure DataLake Storage, Azure App Service, Azure ML is a plus
Languages: Python, SQL, T-SQL, SSIS
DB: Azure SQL Database, Cosmos DB, NoSQL,
Methodologies: Agile and DevOps must have
Concepts: ELT/ETL, DWH, APIs (RESTful), Spark APIs, FTP protocols, SSL, SFTP, PKI (Public Key Infrastructure) and Integration testing
#J-18808-Ljbffr