SQL Analyst SQL Analyst

4 weeks ago

Exeter Devon, United Kingdom Devon Partnership NHS Trust Full time

Our professional responsibility is to reduce the risk of infection to others as far as possible. The Trust will provide advice, guidance and support on vaccinations and access to vaccinations where requested.
The Data and Analytics Team
We provide dataanalysis and business intelligence reporting services to Devon Partnership Trust,responding to requests which can originate within the Trust or from externalsources. This post is based within our Central Team of analysts, working todeliver routine and ad-hoc reports by interpreting requests, analysinginformation and producing products that meet the business needs.
We are looking for a motivated and capabledata analyst with knowledge of relational databases and ideally, experience of SQL querywriting as well as advanced Excel spreadsheet design to gain experience withnew reporting technology. Proficiency in Power BI would be an advantage buttraining would be provided. Writing SQL queries with an understanding of structured data and relational databases
Provide reports to support business needs, both routine and on an ad-hoc basis
Provide data for national returns, for exampleNHS Benchmarking, working with others to ensure accuracy and assurance
Utilising other appropriate software to enhancethe way we communicate our data
We provide mental health, learning disability and neurodiversity services, as well as a range of specialist & secure services for the wider south west region & nationally. We are passionate about promoting good mental health & wellbeing. We strive to use the expertise & resources within our organisation, and through our partnerships, to deliver high quality services that are safe & focused on people's recovery.
These include such attributes as showing a commitment to quality of care, improving lives of others, giving respect, dignity & compassion. We are committed to being an inclusive employer & applications are encouraged & welcomed from all sections of the community, regardless of any protected characteristics as governed by the Equality Act 2010. Part time & flexible working applications will be considered & supported, where possible. We particularly encourage applicants with lived experience of mental health conditions, neurodiversity or learning disabilities. We are a Disability Confident Leader.
To develop, administrate the control and production process for the Trusts key performance indicators, regular reports and ad-hoc requests for information in relation to Trusts information needs.
To work directly with clinical staff to support their understanding of information, analytics and associated performance measures.
To support development of Business Intelligence reporting and rich data visualisation using industry standard tools.
This post requires excellent planning and time management skills.
The post holder will draw upon well-developed communication skills and planning skills to ensure that the allocated workload is completed and that deadlines are met to agreed quality standards.
To assist provision of an information analysis service to support operational management, measure performance and to provide returns required by the Health Authority and other statutory bodies. These post requirements will aid senior managers in the planning of local services and patient care.
Data analysis, interpretation and presentation are key elements of the role and the post holder will be required to work from a variety of information sources producing regular and ad hoc information reports. This is achieved by analysis, review and reporting of information held in systems which include the Trusts clinical systems and other internal Trust systems as well as external sources of information such as NHSI Model Hospital, NHS Benchmarking and the Mental Health Service Dataset (MHSDS).
To provide analysis and commentary around data, highlighting insights and summarising performance to various audiences in order to support decision making and performance management of services. The post holder will work under the supervision of the Information Manager to produce information on the regular report schedule, and to respond to ad-hoc requests for information.
The post holder will work with staff in the organisation to ensure that the data is of a consistently high standard, investigating how information is recorded to ensure accurate reporting. This will involve identifying data quality issues and providing information, guidance and support to teams to assist with the correction of errors.
The post holder will be responsible for assimilation, validation and submission of data for central NHS organisations and other statutory bodies.
The post holder will use their skills in SQL scripting and spreadsheets alongside their knowledge of relational databases and advanced excel skills to understand, provide, and
They will be required to design new spreadsheets and to write SQL code to query the SQL server database.
The post holder will be expected to lead on specific projects that relate to informatics, data reporting and performance frameworks.
The post holder will work closely with the Senior Information Analysts in other departments to cross cover their work.
The post holder will be expected to be familiar with the rationale and usage of Key Performance Indicators (KPI) and will use and maintain the KPI register.
The post holder may be required to administer routine data collections and surveys as necessary.
Be able to interpret results from the analysis, apply the results to the given problem and suggest conclusions to be drawn
IT skills particularly use of Microsoft Office and use of the Intranet, Internet and email
Understanding of a wide range of data quality issues and the application of the appropriate data validation techniques
Experience of SQL query writing.
Experience of creating Power BI dashboards.
Experience of R or Python.
Considerable experience working as an Information Analyst or equivalent experience in a role which is focused on data analysis and reporting
Ability to manage a small team and prioritise own and staffs work in line with organisational policies
Experience of working on projects to deliver quality outcomes to deadline and identifying risks
Good general education to GCE/GCSE level to include English Language and Mathematics

  • Lead Data Analyst

    12 hours ago

    Devon, United Kingdom Staffworx Full time

    Lead Data Analyst – South West, to £70K + bonus, full bensLeading software company, looking for experienced senior / lead data analyst to lead the evolution of data infrastructure and analytics as they build and develop next generation of self-service data tools for customers and transition to new Azure Cloud platform.You will lead a small team of skilled...

  • Lead Data Analyst

    6 hours ago

    Devon, United Kingdom Staffworx Full time

    Lead Data Analyst – South West, to £70K + bonus, full bensLeading software company, looking for experienced senior / lead data analyst to lead the evolution of data infrastructure and analytics as they build and develop next generation of self-service data tools for customers and transition to new Azure Cloud platform.You will lead a small team of skilled...

  • Lead Data Analyst

    6 hours ago

    Devon, United Kingdom Staffworx Full time

    Lead Data Analyst – South West, to £70K + bonus, full bens Leading software company, looking for experienced senior / lead data analyst to lead the evolution of data infrastructure and analytics as they build and develop next generation of self-service data tools for customers and transition to new Azure Cloud platform. You will lead a small team of...

  • ILS Functional Analyst

    4 weeks ago

    Plymouth, Devon, United Kingdom Endeavour Recruitment Solutions Full time

    Technologies: ILS Functional Analyst SQL Scrum Our Defence client based in Plymouth requires an ILS Functional Analyst to join them on a 6-month basis. Your team will support the delivery and maintenance of a variety of COTS and internally developed applications, which support a variety of business functions. About the role As an ILS Functional Analyst,...

  • Business Systems Analyst

    3 weeks ago

    Exeter, United Kingdom Informed Recruitment Limited Full time

    Are you an experienced Business SystemsAnalyst, Application Analyst or Software specialist? Do you havespecific experience of working on ERP style softwareimplementations and/or upgrades? Let Informed Recruitment help youto achieve your potential with an exciting opportunity for aBusiness Systems Analyst to take a key role in the implementationof new...

  • DB Pensions Analyst

    3 days ago

    East Devon, Devon, United Kingdom RC Fornax Full time

    We're looking for a Senior Analyst to lead and manage our customers UK analysis team. To validate equipment and products throughout their lifecycle in accordance with contracted requirements and to influence their design in a timely manner to ensure they are more generally fit for purpose. Key Responsiblities: * Manage Analysis team and associated...

  • Backend Developer Java

    4 days ago

    Exeter, United Kingdom Rise Technical Recruitment Limited Full time

    £40'000-£55'000 + Pension + Holidays + Technical progression + Learning opportunities Remote or Hybrid working Are you interested in working on the cloud based server-side of systems where you will process large data sets and implement bespoke functionality for products in the NetZero industry? This a great opportunity to make a huge impact within the...

  • Senior Business Intelligence Analyst

    4 weeks ago

    Exeter, Devon, United Kingdom Hays Full time

    The BI function is responsible for providing insights and intelligence relating to the whole organisation, in the context of activity, cost, quality and performance data. This role will provide an expert high quality business intelligence service to the organisation with an emphasis on the development of Power BI reporting. Provide timely, efficient, and...

  • Senior Business Intelligence Analyst

    4 weeks ago

    Exeter, Devon, United Kingdom Hays Full time

    The BI function is responsible for providing insights and intelligence relating to the whole organisation, in the context of activity, cost, quality and performance data. This role will provide an expert high quality business intelligence service to the organisation with an emphasis on the development of Power BI reporting. Provide timely, efficient, and...

  • Data analyst

    4 weeks ago

    Newton Abbot, Devon, United Kingdom Abs Data Full time

    Data Analyst Smart Recruitment Solutions Data Analyst, £16,860 Part Time 18.5 hrs, Newton Abbot, Excellent benefits package Part time office based position for an experienced Data Analyst offering fantastic Company benefits – Healthcare, Employee Assistance, training opportunities, gym membership, flexible working etc. Do you love numbers, data and...

  • Performance Analyst Internship

    4 weeks ago

    Exeter, Devon, United Kingdom Comunidadlift Full time

    Job Description Department: Academy Salary Details: £8000 The Opportunity: Are you a university student eager to apply your knowledge in a dynamic, real-world setting? Exeter City FC is thrilled to offer two full-time positions for Performance Analysts to join our esteemed team. This is your chance to immerse yourself in the world of elite football...

  • Test Analyst

    4 weeks ago

    Exeter, Devon, United Kingdom LV= Full time

    You’ll be working as a test analyst as part of a larger team on a major transformation programme in the Protection business, supporting the team with testing across digital, business and migration. The job holder will contribute to a high performing and dynamic change team by coordinating and supporting the project to identify and define required test...

  • Senior Developer, C# SQL

    4 weeks ago

    Plymouth, Devon, United Kingdom Searchability® Full time

    NET Developer • Opportunity for a . NET Developer to work for a market leading SaaS company • Hybrid working arrangements out of our Plymouth HQ We are a marketing leading SaaS company that are a cloud based software platform. We help companies manage their compliance and currently have over 10,000 users across over 30 countries. You will be an...

  • Senior Developer, C# SQL

    4 weeks ago

    Plymouth, Devon, United Kingdom Searchability® Full time

    NET Developer • Opportunity for a . NET Developer to work for a market leading SaaS company • Hybrid working arrangements out of our Plymouth HQ We are a marketing leading SaaS company that are a cloud based software platform. We help companies manage their compliance and currently have over 10,000 users across over 30 countries. You will be an...

  • Digital Rights Data Analyst

    6 hours ago

    Exeter, Devon, United Kingdom Refinitiv Full time

    Digital Rights Data Analyst page is loaded Digital Rights Data Analyst Apply locations GBR-Exeter-The Senate time type Full time posted on Posted Yesterday job requisition id R0084462 Role PurposeLSEG is digitising the contractual rights and duties associated with third-party content provided by our suppliers. As a member of the Digital Rights Data team,...

  • Business Analyst

    4 weeks ago

    Exeter, United Kingdom BJSS Full time

    **About Us** We’re an innovative tech consultancy - a team of problem solvers. Since 1993 we’ve been finding better ways to solve complex technology problems for some of the world’s leading organisations and?delivered solutions that millions of people use every day. We bring together experts from diverse backgrounds and experiences in a collaborative...

  • Business Analyst

    3 weeks ago

    Devon, United Kingdom Venn Group Full time

    We're looking for a Business Analyst to come on board with a South West Local Authority. Business Analysts understand and analyse user and business needs. They are responsible for all business analysis deliverables on assigned projects, from scoping and requirements elicitation through to operating model definition and implementation within the business....

  • Business Analyst

    3 weeks ago

    Devon, United Kingdom Venn Group Full time

    We’re looking for a Business Analyst to come on board with a South West Local Authority. Business Analysts understand and analyse user and business needs. They are responsible for all business analysis deliverables on assigned projects, from scoping and requirements elicitation through to operating model definition and implementation within the...

  • Support Desk Analyst

    6 days ago

    Exeter, United Kingdom Broadreach Recruitment Ltd. Full time

    Service Desk Analyst Exeter £22,552 We are looking for a Support Desk Analyst to join our reputable company based in Exeter. The client is a successful Telecoms provider and the Service Desk is essential to the business. You will be supporting clients with any technical issues and providing 1st line support. - You will have excellent customer service...

  • Data Digital Analyst

    4 weeks ago

    Exeter, Devon, United Kingdom Refinitiv Full time

    Digital Rights Data Analyst page is loaded Digital Rights Data Analyst Apply locations GBR-Exeter-The Senate time type Full time posted on Posted Yesterday job requisition id R0085690 LSEG is digitising the contractual rights and duties associated with third-party content provided by our suppliers. As a member of the new Digital Rights Data Quality team,...