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 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 Business Intelligence Lead.
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
Relationships:
This role will involve regular communication with the business, the Group CTO, the Product Management function and the wider IT team.
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 GDPR
* 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
About the company
All around the world, Healix safeguards people's health and wellbeing.
Required Criteria
* 5+ years in a similar role
* 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
Desired Criteria
* PL-300 Microsoft Certified: Power BI Data Analyst Associate
* Familiarity with big data processing frameworks e.g. Pandas (python) and Spark
Skills you'll need
#J-18808-Ljbffr