Come and join one of the UK’s largest providers in complex care. We proudly employ over 4000+ people - no matter what your experience, we have jobs for everyone.
We’re looking for a Junior SQL Developer to support our reporting and analytics function, working primarily within a Snowflake-based data warehouse environment. This role will focus on maintaining and developing SQL queries, supporting Power BI reporting requirements, and working with our medallion architecture data warehouse (Bronze / Silver / Gold layers).
This is a great opportunity for someone with at least 1 year of hands-on SQL experience (commercial or personal projects)
What you'll be working:
This role is full time, 37.5 hours per week. Working Monday - Friday, 09.00-17.30
What you'll be doing:
* Develop, maintain, and optimise SQL queries and transformations within Snowflake
* Support the Power BI reporting team by preparing and validating datasets for reporting and dashboards
* Work within a medallionised data warehouse architecture, ensuring data quality and consistency across Bronze, Silver, and Gold layers
* Assist with troubleshooting data issues and resolving discrepancies in reporting outputs s
* Collaborate with data engineers, analysts, and business stakeholders to understand reporting requirements
* Contribute to documentation of data models, SQL logic, and reporting processes
* Support ongoing improvements to data pipelines and reporting performance
* Create reports using Power BI
What you'll have:
* Around 1 year of commercial or practical experience writing SQL
* Experience with Snowflake or another modern cloud data warehouse (e.g., Redshift, BigQuery, Synapse)
* Understanding of relational databases and data warehousing concepts
* Familiarity with Power BI or supporting BI/reporting functions
* Basic understanding of ETL/ELT processes and data transformation
* Strong attention to detail and problem-solving skills
* Good communication skills and willingness to learn
* Exposure/experience with Power BI is greatly desirable.
Desirable Skills
* Experience working with medallion/layered data warehouse architectures
* Exposure to data modelling concepts
* Understanding of performance optimisation in SQL
* Knowledge of cloud data environments or orchestration tools is beneficial
What We’re Looking For
* Someone proactive and eager to develop technically
* A team player who enjoys solving data problems
* Comfortable working in a collaborative reporting and analytics environment
* Interested in building a long-term career in data engineering, analytics, or BI
Tech Stack
* Snowflake
* SQL
* Power BI
* Cloud Data Warehouse Architecture
* Medallion Data Model (Bronze / Silver / Gold)
What to look forward to:
* 25 days plus bank holidays
* Birthday off
* Join the Active Learning Hub and benefit from a wide range of e learning and face to face training and development opportunities
* Active Reward App giving discounts and savings on your weekly shop
* Free 24 hour confidential Employee Assistance Programme Helpline & App to support with legal, health, wellbeing, relationship and consumer advice
* A Nest Personal Pension account
* Access to join a Medicash Health Plan for you and your family to save money on everyday health essentials – like going to the dentist or opticians
* We recognise outstanding Active Behaviours via the Active Awards programme
* Enhanced Sick & Maternity Pay benefits
* Refer a Friend Scheme and earn yourself up to £1500 by recommending someone you know
* ……and, of course, the support and guidance of our qualified clinical and business leadership teams so that you can really develop your career with Active Care Group
Take a look around the company