Business Intelligence Analyst

Job Description

We have an exciting opportunity for an experienced Business Intelligence Analyst to join our growing IT team in Esher.

The Business Intelligence Analyst will The role will work closely with the business to understand the data, proactively produce new visualisations to support self-serve business data interrogation and ensure the entire data pipeline is fit for purpose. Advanced technical skills will be needed to ensure the data warehouse, as well as the pipelines and transformations are fit for purpose. The person in this role needs to be proficient in query optimisation to provide efficient and reliable ETL and reports.

The Business Intelligence Analyst is expected to work from the Esher office 3 days a week and work 2 days from home. They will be dealing directly with the business whilst working closely with the IT Data Warehouse Lead.

Relationships:

This role will involve regular communication with the business, the Group CTO, the Product Management function and the wider IT team. The priority is to work with stakeholders to gain an understanding of the business and act as the intermediary between the business and the Data Warehouse Lead. Our successful candidate will have a proven track record of understanding the business they work in and using that to drive our data analysis.

What we are looking for:

 Essential requirements and skills:

• Excellent written and spoken English in a commercial environment

• 5+ years in a similar role

• Data visualization with PowerBI, Excel and SSRS

• DAX

• Business Analysis

• PowerBI data flows

• Deployment pipelines

• Proficiency in Python, PowerShell, bash or other relevant data manipulation and automation languages

• Advanced SQL

• ETL processes

• Statistical Analysis

 Desirable skills:

• PL-300 Microsoft Certified: Power BI Data Analyst Associate

• Familiarity with big data processing frameworks e.g. Pandas (python) and Spark

 We are looking for candidates with a Degree level education or equivalent. In addition, we are looking for someone who is:

• An excellent communicator

• Diplomatic leader who can quickly get people on side

• Delivery focused

• A self-motivated and personable individual able to work with minimal supervision and take responsibility for the running of the systems and services that support the business.

• Quick to build relationships and earn respect through sound judgement and a positive attitude

• Committed to getting the job done

and has:

• The ability to be proactive but also to take direction

• A methodical and structured approach to analysing problems and producing solutions

• The ability to influence decisions through reasoned argument 

• Excellent documentation and presentation skills

About The Role

Key responsibilities:

• Building data warehouses suitable for PowerBI self-serve business use

• Liaising with the business to understand their requirements and motivations

• Understanding the data of the business models to a high degree

• Proactively producing new and better ways to enable the Business to turn data into useful information

• Designing and implementing data models representing business entities and relationships

• Building and maintaining data warehouses to support analytics and reporting

• Implementation and ongoing awareness of data security measures that ensure compliance with regulations like GDPR2

• Developing and managing ETL pipelines using tools like Azure Data Factory and SSIS

• Performing performance tuning and monitoring

• Database administration

• Cleaning and transforming data to prepare it for analysis

Skills Needed

About The Company

We offer UK employee healthcare benefits, and travel, medical and security assistance in every corner of the globe. Our purpose is to help people in difficult situations – whether that’s a cancer diagnosis, a need for medical assistance when they’re far from home, or being caught up in conflict or natural disaster. We talk to them, support them, and make sure they get the help they need. If necessary, we’ll pull them out and bring them home.

We’re co-ordinators and problem-solvers: experts at navigating the global health and security landscape. Our teams of doctors, nurses, travel and medical co-ordinators and security experts make sure that your people will be looked after, whatever happens supported by technology designed help individuals, not slot them into a predetermined solution.

We work with governments, broadcasters, NGOs, international corporations, major insurers and more. No two clients are the same: we adapt our services to their needs.

More importantly, we adapt to the practical and human needs of the individuals we protect. Most of us are on the front line; we keep our back office lean. We don’t use scripts, and we don’t time calls. We never lose sight of the fact that we’re dealing with real people.

Company Culture

Instead, we focus on ensuring our highly trained specialists have the space and time they need to be effective. We let them use their initiative to get the job done, because the situations they face often throw up unexpected challenges – and no protocol survives contact with the real world.

Our clients have thousands of employees and customers, at home and abroad, so they need a business big enough to handle any situation. But they chose Healix because they also need an organisation that’s personal enough to care.

Our people are driven to do things in the best way, not the way they have always been done. We work hard, and our efforts are rewarded with great development opportunities and a supportive team spirit. 

We want to nurture this friendly and dynamic company culture so that we can continue to attract diverse talent with a breadth of knowledge and world-class skills. As a part of Healix, you can expect a range of excellent benefits and an environment where people really do care.

Desired Criteria

• PL-300 Microsoft Certified: Power BI Data Analyst Associate
• Familiarity with big data processing frameworks e.g. Pandas (python) and Spark

Required Criteria

• Data visualization with PowerBI, Excel and SSRS
• DAX
• Proficiency in Python, PowerShell, bash or other relevant data manipulation and automation languages
• At least 3 days per week office presence in Esher
• 5+ years in a Business Analyst or similar role

Closing DateFriday 18th April, 2025