BI Analyst
Teddington
£40,000 - £45,000 per annum
My client who is a global leader within their field is looking for a BI Analyst. As the successful BI Analyst you will be involved the introduction of the companies new ERP systems and the development of a new Microsoft SQL database reporting platform.
Responsibilities
-Develop & maintain the current ETL package to reflect new business requirements
-Monitor ETL package activity
-Development and maintenance of the data warehouse preferably using the Kimble method
-Contribute to effective use of Business Intelligence through engagement with key stakeholders, providing excellent insight to drive correct working behaviours.
-Partner with all the various business units to understand their KPI’s and to deliver accurate reporting and generate insight to enable informed decisions
-Design and implement reports within excel
-Assist with the development & implementation of a New reporting infrastructure
-Drive better understanding of the value of data with the stakeholders and users and contribute to improvements in data management and data quality
-Gather, analyse and document reporting requirements from the business
-Take an active role in all BI initiatives through project and change management
Required
-SQL, SSIS, Excel & VBA
-Experience in working with SQL query building is essential.
-Strong knowledge of MS Excel with a sound understanding of VBA
-Working experience in SSIS (ETL Package)
-Experience driving data quality and process improvements
-Ability to comprehend and interpret contractual requirements
Desirable
-Experience with visualisation tools such as - Power BI –Tableau – Qlik
-Data Analysis Expressions (DAX)
-Power Query M
-Been involved in the introduction/maintenance of reporting platforms within a business
-Although not essential a knowledge of a programming language such as R or Python could prove to be advantageous