Job summary
We are recruiting highly motivated and committed individuals who are interested in being at the forefront of developing pioneering projects to help transform British mental healthcare.
Our service is increasingly sought after by patients seeking fast access, high-quality mental health assessment and treatment, both privately and via the NHS Right to Choose scheme. We are recruiting highly focused, suitably experienced candidates to help us meet these demands.
Main duties of the job
As a Data Analyst, you will be a key part of a team transforming data and developing Data Visualisation and Reporting solutions for internal Technical and Business Partners. Reporting into the Senior Data Analyst, the role is a great opportunity for an experienced data analyst to contribute to the ongoing development of the data management team in a fast paced environment at a very exciting time in the companys growth.
The role will be home based but could be required to attend various meeting locations as and when required. The role will also adhere to the flexitime principles for PUK.
You will be rewarded and recognised for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role, as well as providing development for other roles you may be interested in.
About us
Founded in 2012, Psychiatry UK has become the largest specialist psychiatry service in the UK. Through innovation, forward thinking and determination, we are helping to shape the future of British mental healthcare, enabling rapid access to high-quality specialist medical diagnosis and treatment online, and onward referral to accredited and medically managed counselling and coaching services.
Why work with us?
Our workplace culture is person-centred, supportive and neurodivergent friendly. In addition to comprehensive training and mentor support/CPD, we offer the following benefits:
- Competitive/generous salary.
- Additional work-from-home bonus of £1000 per annum (pro-rata).
- Holiday Allowance.
- Family discount.
- Employee Assistance Programme (EAP)
- Strong social network with online events; some face to face events.
Equality
P-UK is strongly committed to valuing and promoting equality, diversity and inclusion in all of our activities. We welcome and celebrate the diversity of our team and our patients, and are committed to offering equal opportunities and access for all people and groups in society.
Job description
Job responsibilities
Work with both internal and external stakeholders to identify optimal report visualisation e.g., dashboard, chart, report, tabular, filters, selection options and subsequently build.
Present information contained in reports and visualisations to stakeholders in easily accessible language.
Assisting with the design and development of ETL processes to enable smooth and efficient information flows for reporting.
Developing and maintaining semantic data models based around star schema design principles.
Crafting and executing queries upon request for data creation and build out of operational insight reports.
Assist in the development and maintenance of technical documentation relating to data definitions and organisation data dictionary.
Support ongoing work to improve the data quality across the organisation.
Highlight potential areas where automation and efficiency gains could improve information flow.
Update domain knowledge by continuously researching and evaluating market solutions and tools, participating in educational opportunities; reading professional publications; maintaining personal networks.
Apply design and data analysis techniques to organize the presentation of data in impactful ways in order to make it easier to understand, insightful, and actionable by end users.
Plan own workload to ensure that tasks are met.
Prioritise workload with consideration to issues arising and responding to shifting priorities appropriately.
Actively participate in regular supervision with line manager and the PUK PDR process for maintaining and developing personal skills and meeting agreed objectives.
The post holder will attend online training as relevant to the post including mandatory training courses i.e. Information Governance, safeguarding, Health and Safety courses etc
Working conditions/effort
The postholder may:
- Be required to concentrate for long periods of time.
- Deal with frequent interruptions.
- Be flexible and adaptable to change.
- Frequent and long periods of PC usage.
- Be required to work alone.
- Be regularly presented with problems requiring resolution.
Job description
Job responsibilities
Work with both internal and external stakeholders to identify optimal report visualisation e.g., dashboard, chart, report, tabular, filters, selection options and subsequently build.
Present information contained in reports and visualisations to stakeholders in easily accessible language.
Assisting with the design and development of ETL processes to enable smooth and efficient information flows for reporting.
Developing and maintaining semantic data models based around star schema design principles.
Crafting and executing queries upon request for data creation and build out of operational insight reports.
Assist in the development and maintenance of technical documentation relating to data definitions and organisation data dictionary.
Support ongoing work to improve the data quality across the organisation.
Highlight potential areas where automation and efficiency gains could improve information flow.
Update domain knowledge by continuously researching and evaluating market solutions and tools, participating in educational opportunities; reading professional publications; maintaining personal networks.
Apply design and data analysis techniques to organize the presentation of data in impactful ways in order to make it easier to understand, insightful, and actionable by end users.
Plan own workload to ensure that tasks are met.
Prioritise workload with consideration to issues arising and responding to shifting priorities appropriately.
Actively participate in regular supervision with line manager and the PUK PDR process for maintaining and developing personal skills and meeting agreed objectives.
The post holder will attend online training as relevant to the post including mandatory training courses i.e. Information Governance, safeguarding, Health and Safety courses etc
Working conditions/effort
The postholder may:
- Be required to concentrate for long periods of time.
- Deal with frequent interruptions.
- Be flexible and adaptable to change.
- Frequent and long periods of PC usage.
- Be required to work alone.
- Be regularly presented with problems requiring resolution.
Person Specification
Qualifications
Essential
- Degree/Professional qualification in a Data related field.
Experience
Essential
- Experience with designing, developing, and implementing reporting solutions.
- Hands on experience and skills working with reporting solutions and technologies: MySQL and Power BI.
- Experience creating database objects such as views, stored procedures and custom functions to process data flows pre-presentation in the reporting layer.
- Experience optimising queries and data models.
- Experience with version control of code objects and documentation, GitHub preferred.
Desirable
- Experience of NHS data flows preferred but not essential.
- Experience developing or maintaining technical data documentation such as data dictionary, data definition or calculation specifications.
- Exposure to Python programming for data acquisition and transformation
- Redash experience would be beneficial but not essential.
Knowledge and skills
Essential
- Ability to proactively research solutions and best practices.
- Ability to work autonomously and remain calm under pressure.
- Ability to accurately follow instructions, but also use initiative.
- Meticulous attention to detail.
- Excellent time management skills and the ability to plan and prioritise work.
- A problem-solving mindset.
- Ability to work across several projects at the same time.
- Must maintain confidentiality of data and information, and act with integrity at all times.
Person Specification
Qualifications
Essential
- Degree/Professional qualification in a Data related field.
Experience
Essential
- Experience with designing, developing, and implementing reporting solutions.
- Hands on experience and skills working with reporting solutions and technologies: MySQL and Power BI.
- Experience creating database objects such as views, stored procedures and custom functions to process data flows pre-presentation in the reporting layer.
- Experience optimising queries and data models.
- Experience with version control of code objects and documentation, GitHub preferred.
Desirable
- Experience of NHS data flows preferred but not essential.
- Experience developing or maintaining technical data documentation such as data dictionary, data definition or calculation specifications.
- Exposure to Python programming for data acquisition and transformation
- Redash experience would be beneficial but not essential.
Knowledge and skills
Essential
- Ability to proactively research solutions and best practices.
- Ability to work autonomously and remain calm under pressure.
- Ability to accurately follow instructions, but also use initiative.
- Meticulous attention to detail.
- Excellent time management skills and the ability to plan and prioritise work.
- A problem-solving mindset.
- Ability to work across several projects at the same time.
- Must maintain confidentiality of data and information, and act with integrity at all times.
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
