Data Analyst

Swanton Care and Community; Coventry; Remote; GBP 35,000 - 50,000; Full time

Job summary

A leading organization in health and social care seeks a detail-oriented Data Analyst to enhance their Digital Services team. The successful candidate will leverage expertise in SQL and Power BI to build data pipelines, analyze trends, and create dashboards that inform strategic decisions across the organization.

Benefits

Referral scheme: earn £400 per successful referral

Recognition with vouchers and surprises

Long service awards

Employee benefits app with discounts

Cycle to work scheme

Auto-enrolled pension scheme

Life cover benefits

Funded qualifications and career pathways

Training at Swanton Educates

Confidential Employee Assistance Programme

Qualifications

• Proficient in SQL, Power BI, and ETL processes.
• Strong analytical and problem-solving skills.
• Bachelor's degree or equivalent in a related field.

Responsibilities

• Design and maintain data pipelines and ETL processes.
• Develop dashboards and reports using Power BI.
• Perform data analysis to derive insights and trends.

Skills

Data Analysis

SQL

Power BI

Data Manipulation

Analytical Skills

Education

Bachelor’s degree in Data Science, Computer Science, Statistics, Engineering or related field

Tools

ETL tools

Python

APIs

Azure

Snowflake

BigQuery

Job description

About The Role

Job Title: Data Analyst

Location: Remote

Job Type: Full Time Permanent

Department: Digital Services

Reports To: Digital Services Director

Role Overview

We are seeking a detail-oriented Data Analyst with expertise in Data and Power BI to join our Digital Services team. You will design data pipelines, transform raw data into insights, and develop dashboards to support strategic decisions. Collaboration with cross-functional teams will ensure data integrity and usability within the social care sector.

Key Responsibilities

• Design, build, and maintain scalable data pipelines and ETL processes.
• Collect, clean, and validate data from various sources.
• Develop and optimize data models for reporting and analysis.
• Create dashboards and reports using Power BI, meeting stakeholder needs.
• Work with business units to understand and translate data requirements.
• Perform data analysis to identify trends and insights.
• Ensure data quality, consistency, and governance.
• Support KPI development aligned with business goals.
• Document data processes and workflows.

Skills & Qualifications

• Bachelor’s degree in Data Science, Computer Science, Statistics, Engineering, or related field.
• Proficiency in SQL and Power BI.
• Strong skills in Excel and data manipulation.
• Experience with data engineering tools (ETL, data pipelines, modeling).
• Experience with APIs as data sources.
• Strong analytical and problem-solving skills.
• Familiarity with Python scripting.
• Excellent communication skills.
• Ability to work independently and in teams.

Preferred Qualifications

• Experience with cloud platforms (Azure, AWS, GCP).
• Knowledge of data lake and warehousing tools (Azure, Snowflake, BigQuery).
• Understanding of data governance and security.
• Experience with DAX and Power Query in Power BI.
• Background in health or social care data is highly desirable.
• Knowledge of statistical analysis and predictive modeling.

What we offer

• Referral scheme: earn £400 per successful referral.
• Recognition for going the extra mile with vouchers and surprises.
• Long service awards.
• Employee benefits app with discounts and development info.
• Cycle to work scheme.
• Auto-enrolled pension scheme.
• Life cover benefits.
• Funded qualifications and career pathways, including apprenticeships.
• Training at Swanton Educates.
• Trained mental health first aiders.
• Confidential Employee Assistance Programme.
• Regular Employee Voice events for feedback.

*Subject to eligibility and criteria.

About The Service

We are a national health and social care organization supporting children and adults across various settings, promoting safety, happiness, and potential.