Business Intelligence Lead (MS BI Stack)
Salary – 60k – Full benefits package
This is a brand new position that will have overall responsibility for the hands-on provision of BI & reporting services for this pharmaceutical company who have been making health and beauty products for over 100 years.
You will lead a small internal BI function, you as the lead and one developer to provide secure, accurate and actionable information Group-wide, and continuous development and maintenance of the data warehouse.
You will provide leadership, coaching and direction whilst ensure cost-effective delivery of services to exceed business expectations, and respond with agility to changing business priorities.
You will report directly into the Director of IT and will help develop and implement how BI works within the IT Strategy and roadmap.
Critically, you will work across the business to enable cost-effective and innovative shared BI solutions in achievement of business goals. You will design, develop, operate and support of BI systems that meet the needs of the business, throughout the full application lifecycle whilst creating and managing relationships with vendors to maximise performance.
This is a combined hands-on Business Intelligence and leadership role, you will be responsible for working with key business stakeholders to define, design and develop end user reporting, KPIs, and business analytics as well as documenting high-level requirements to create detailed technical designs to align with standard architecture.
You and the Developer will Develop, automate, train and support reports & dashboards using SQL stored procedures, reporting services, relational & multidimensional database queries, VB script, Power Pivot, and Power BI.
You will develop complex TSQL solutions & Microsoft BI Stack (SSIS, SSAS, and SSRS). Additionally, you will implement BI / Data Warehouse concepts and methodology including full application lifecycle, data modelling and ETL development.
25 Days holiday + 8 BH
Lifestyle benefits – £200 pa on personnel development (Gym membership for example)
Savers Club Scheme
Pension – 5% contribution, 8% by the company
BUPA Healthcare – Family
Travel – Easy to drive each day, city center location – 5 minute walk from Watford Train station (Metropolitan line)