Business Intelligence Analyst
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
What you will need
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
Desired criteria
- PL-300 Microsoft Certified: Power BI Data Analyst Associate
- Familiarity with big data processing frameworks e.g. Pandas (python) and Spark
Healix
All around the world, Healix safeguards people's health and wellbeing.
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.
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.
Our benefits
Commitment to career development We are committed to helping our people build and develop successful careers. Our employees are given direct responsibility and opportunity to develop and grow whilst working on challenging and worthwhile projects in a rewarding and supportive environment. We invest in the continuous development of our team, offering on-going training and professional enhancement opportunities for those wishing to diversify or take additional responsibilities.
Health insurance
Vacation, Paid time off
Retirement plan and/or pension
Office perks
Employee development programs
Employee discounts
Gym membership or wellness programs
Opportunity to travel
Casual dress
Cycle to work
Free work laptop
Referral bonus
Open office
Competitive salary
Life insurance
Employee Assistance Scheme
Wellbeing Scheme
Social Opportunities
Hybrid Working
Business Intelligence Analyst
All around the world, Healix safeguards people's health and wellbeing.