Get AI-powered advice on this job and more exclusive features.
(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. Database administrator for MS SQL Server based systems. To include the planning, development and overall ownership of the database infrastructure. Ensuring the data across the company remains consistent, accurate, secure and available to all users.
Key Responsibilities
1. The identification, design and implementation of business system and process improvements.
2. Provide the business & stakeholders with high quality data visualisations and analysis to help answer key institutional questions and enable evidence-based decision making.
3. Act as the database administrator for MS SQL Server based systems, including the planning, development and overall ownership of the database infrastructure.
4. Develop and test new application functions and features for existing business systems.
5. Interpret data and analyse results using statistical techniques and provide ongoing BI reports.
6. Develop and implement databases, data collection systems, data analytics and other strategies that optimise statistical efficiency and quality.
7. Conduct system testing and user acceptance testing (UAT).
8. Evaluate business processes, anticipate requirements, uncover areas for improvement, and develop and implement solutions.
9. Design and implement tables, stored procedures, functions, models, security and jobs within all SQL applications.
10. Assist with reconfiguration, translation and migration of data in systems.
Skills & Experiences
1. Previous experience in a Data Analyst, Business Data Analyst or BI Analyst role is essential.
2. Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc).
3. Highly proficient in querying and modifying in SQL Server including general DBA tasks.
4. Knowledge of statistics and experience using statistical packages for analysing datasets (Excel, SPSS, SAS etc).
5. Experience of visualisation tools (Qlik, Power BI, Tableau, Crystal reports etc.).
6. Management of an organisation’s data and metadata.
7. Strong experience of installing, administering and troubleshooting SQL environments to resolve critical database issues including SQL Server 2008, 2012 and 2016.
8. Knowledge of database design and programming (T-SQL).
9. Excel and advanced formulas.
10. VBA or similar scripting knowledge.
11. Understand how each department/site fits into the structure.
12. Ensure all duties are carried out in accordance with Health and Safety regulations as given in company Risk Assessments.
Other Duties
1. Understand how each department/site fits into the structure.
2. Ensure all duties are carried out in accordance with Health and Safety regulations as given in company Risk Assessments.
3. Represent the client’s brand at all times and communicate the client’s values.
4. Take responsibility for personal development.
5. This Job Description is not exhaustive, and the post holder may be required to undertake other appropriate duties from time to time.
6. Data Warehousing (WhereScape or similar).
7. Good understanding of fundamental dimensional modelling techniques.
8. Technical experience working with business intelligence solutions.
9. ETL experience.
Seniority level
Associate
Employment type
Full-time
Job function
Information Technology
Industries
Data Infrastructure and Analytics
#J-18808-Ljbffr