Power BI Lead

The PowerBI Lead will lead, design and facilitate Data Analytics, Date Interpretation and Data Visualization for the relevant Divisions as well as facilitating full integration of key MI data points into PowerBI including BI Risk capture in order to deliver accurate and timely MI for business performance monitoring and customer reporting.

This is an exciting time to be joining the team, which is currently designing and rolling out its MI Suite.

Key Responsibilities:

This role will require both creative and collaborative working with IT and the wider business. It will involve evangelising effective data management practices and promoting better understanding of data and analytics. Working with the Senior Data Steward, key business stakeholders, IT experts and subject-matter experts to plan and deliver optimal analytics and data science solutions.

You will be expected to analyse and verify all financial data against new entities going through the Ingestion process as well as doing regular checks on the financial reports, to confirm their veracity

You will be expected to produce reporting and analysis of our current book, to allow the business to review, identify and monitor placement of insurance policies so that we are maximising the revenue/ discounting potential for the unit

Drive Automation through effective metadata management: responsible for using innovative and modern tools, techniques and architectures to partially or completely automate the most-common, repeatable and tedious data preparation and integration tasks.

Collaborate across departments: Strong collaboration skills in order to work with varied stakeholders within the PIB Group. Work closely with the Heads of MI fulfil the business MI objectives.

Conduct Rules and Fitness & Propriety

All PIB employees are expected to conduct themselves with integrity and professionalism, placing the customer at the centre of all we do and is central to our culture. You must adhere to the FCA’s Conduct Rules set out below.

Individual Conduct Rules:

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.

Compliance with the FCA Conduct Rules is required and will be evidenced through annual performance reviews.

Fitness & Propriety

You will be assessed on a regular basis in line with PIB’s requirements to ensure that you:

1. Maintain your ‘fitness’ at an appropriate level to undertake the function you perform in a sound and prudent manner at all times-this relates to your experience, knowledge, skills and professional qualifications (where appropriate) and associated CPD.

2. Maintain your ‘propriety’ at all times-this relates to good repute, honesty, integrity and financial soundness. This includes advising the firm of any changes in circumstances and conflicts of interest that could materially affect your fitness or propriety.

3. Have undertaken or are undertaking all relevant training.

Compliance of Fitness & Propriety will be evidenced through PIB’s annual checks on Fitness & Propriety (e.g., financial soundness), through annual performance reviews and through completion of your Fitness & Propriety Declaration.

Person specification

Essential

Desirable

Qualifications

Expertise in either computer science, statistics, analytics, applied mathematics, data management, information systems, information science or a related quantitative field

Experience

A strong background in Analytics and Interpretation

Experience working in cross-functional teams

Previous experience of Data Analytics within a Commercial fast-paced environment (over 3 years)

Knowledge

Experience of the following:

Strong Excel Skills

An understanding of the Design, build and management of data pipelines for data structures encompassing data transformation, data models, schemas, metadata and workload management using MS Azure Data Factory, Azure Data Lake Storage and Azure DataBricks.

Experience working with:

Data discovery, analytics and BI software tools like SAS, Power BI, Tableau, QlikView

Experience working with:

Database programming languages including SQL and T-SQL for relational databases.

Python

Skills

6-10 years of professional experience as a BI developer and 4+ years of professional experience working with Power BI

Must have strong working experience in Power BI in various capacities – developer, report designer & administrator

Should have understanding of prevalent cloud ecosystems and experience in one of the cloud platforms – AWS / Azure / GCP

Must have strong data analytics skills in general

Must have working experience with MS power platform and services like Power automate, Power app, Power query etc.

Must have experience working with Agile methodologies, Test Driven Development, and implementing CI/CD pipelines for Power BI using one of leading services – GITLab / Azure DevOps / Jenkins / AWS Code Pipeline / Google Cloud Build

Must have strong experience with SQL databases (SQL Server, Oracle, Postgres etc.)

Must have stakeholder management experience and very good communication skills

Must have working experience on end-to-end project delivery including requirement gathering, design, development, testing, deployment, and warranty support

Must have working experience with various testing levels, such as, unit testing, integration testing and system testing

General insurance / banking / finance domain understanding would be a plus

Attitude

Ability to cope with change/Positive/Focussed and dedicated

Job Types: Full-time, Permanent

Pay: ₹1,443,916.93 - ₹1,878,547.55 per year

Benefits:

• Health insurance
• Leave encashment
• Paid sick time
• Paid time off
• Provident Fund

Schedule:

• Day shift
• Fixed shift
• Monday to Friday
• Weekend availability

Supplemental Pay:

• Overtime pay
• Performance bonus
• Yearly bonus

Work Location: In person

Expected Start Date: 03/07/2025