Business Intelligence Analyst

  • Window Systems Division
  • Telford TF3, UK
  • 27/07/2022
Full time Data Engineering Business Intelligence Statistics DevOps

Job Description

Job details

Job type

Full Job Description

Job Purpose:
To work closely with all areas of the business to measure everything we do and through an in-depth understanding of our business model, deliver BI that informs internal stakeholders not just on performance but on future opportunities.
Bring together multiple data sources to assist the business on an ongoing basis in understanding its end-to-end view of its business processes, tracking progress, managing obstacles, and supporting business growth.
The core of the role will be to understand in detail the business model, provide in depth analysis of data and deliver appropriate dashboards and reports.
Key Accountabilities:
Document and deliver effective scoping, planning, testing, and on time delivery of BI solutions.
Ownership and delivery of effective and relevant data analysis by creating and implementing visual dashboards and reports using BI tools, as well as maintaining and reviewing currently active reports.
Develop a close working relationship with stakeholders across all levels maintaining regular contact with stakeholders to ensure necessary requirements and expectations are being met.
Run workshops with teams to test dashboard solution models. Developing an understanding of the functional requirements, end-user frustrations, and how analysis supports the end user’s needs.
Responsible in ensuring data integrity of all sources of data through thorough data reconciliation back to source.
Assist in the enhancement of divisional data warehouse.
Assist in automating the delivery of reports.
Key Experiences and Skills Required:
Tableau Desktop and Tableau Server or equivalent BI tools
Demonstrable experience of producing meaningful BI reports and dashboards according to known best practice
Strong SQL skills (SQL Server 2012 & above SSIS, SSAS, SSRS)
Knowledge of dimensional modelling
Query Writing - Transact SQL (T-SQL)
Advanced Microsoft Excel skills
Strong analytical skills
Desirables Skills, Qualifications and Experience Required:
Bachelor’s degree in an IT, Mathematics, Science or Statistical Analysis based subject.
Capable of leveraging the full functionality of Tableau
Experience of setting up Tableau data sources
Personal Attributes:
Delete if not required
Leadership – strong, consistent, clear, inspire others, integrity, ability to drive through change
Empowering Others – Delegation of trust, correct controls, feedback, communicate accountability and responsibility
Action orientated – Able to deal with problems in appropriate time frames
Driven by results – Decisive, confident addressing problems and opportunities, challenging activities to improve performance, demonstrate willingness to challenge accepted methods and standards
Effective communication – Clear concise written and spoken, ability at all levels, customer, supplier and internal
Strategic agility – recognition of a changing need and speed of response, rapid reaction to challenges
High Standards – demonstrating a motivation to improve standards and thereby making a real difference, challenging inadequate solutions
Integrity and trust – demonstrating a sense of commitment to openness, honesty, loyalty and high standards in undertaking the role
People management – demonstrating commitment to working and engaging constructively with internal and external stakeholders