Data Analyst
(Maternity Cover) – 12-month Fixed Term contract
Full Time
Chichester based - Fully onsite
Responsible To: Business System Manager
Purpose of Role:
As a Data Analyst, you will be involved in building and delivering BI, data, and reporting solutions. Ensure readily accessible management information for all users through the identification, design, and implementation of business system and process improvements. Provide the business & stakeholders with high-quality data visualisations and analysis to help answer key institutional questions and enable evidence-based decision-making. Act as the database administrator for MS SQL Server-based systems, including the planning, development, and overall ownership of the database infrastructure. Ensure the data across the company remains consistent, accurate, secure, and available to all users.
Key Responsibilities
* The identification, design, and implementation of business system and process improvements.
* Provide the business & stakeholders with high-quality data visualisations and analysis to help answer key institutional questions and enable evidence-based decision-making.
* Act as the database administrator for MS SQL Server-based systems, including the planning, development, and overall ownership of the database infrastructure.
* Develop and test new application functions and features for existing business systems.
* Interpret data and analyse results using statistical techniques and provide ongoing BI reports.
* Develop and implement databases, data collection systems, data analytics, and other strategies that optimise statistical efficiency and quality.
* Conduct system testing and user acceptance testing (UAT).
* Evaluate business processes, anticipate requirements, uncover areas for improvement, and develop and implement solutions.
* Design and implement tables, stored procedures, functions, models, security, and jobs within all SQL applications.
* Assist with reconfiguration, translation, and migration of data in systems.
Skills & Experiences
* Previous experience in a Data Analyst, Business Data Analyst, or BI Analyst role is essential.
* Strong knowledge of and experience with reporting packages (Business Objects, etc.), databases (SQL, etc.).
* Highly proficient in querying and modifying in SQL Server, including general DBA tasks.
* Knowledge of statistics and experience using statistical packages for analysing datasets (Excel, SPSS, SAS, etc.).
* Experience with visualisation tools (Qlik, Power BI, Tableau, Crystal Reports, etc.).
* Management of an organisation’s data and metadata.
* Strong experience in installing, administering, and troubleshooting SQL environments to resolve critical database issues, including SQL Server 2008, 2012, and 2016.
* Knowledge of database design and programming (T-SQL).
* Excel and advanced formulas.
* VBA or similar scripting knowledge.
* Understand how each department/site fits into the structure.
* Ensure all duties are carried out in accordance with Health and Safety regulations as given in company Risk Assessments.
* This Job Description is not exhaustive, and the post holder may be required to undertake other appropriate duties from time to time.
Other Duties
* Understand how each department/site fits into the structure.
* Ensure all duties are carried out in accordance with Health and Safety regulations as given in company Risk Assessments.
* Represent the client’s brand at all times and communicate the client’s values.
* Take responsibility for personal development.
* This Job Description is not exhaustive, and the post holder may be required to undertake other appropriate duties from time to time.
Desirable
* Data Warehousing (WhereScape or similar).
* Good understanding of fundamental dimensional modelling techniques.
* Technical experience working with business intelligence solutions.
* ETL experience.
#J-18808-Ljbffr