Junior SQL Developer (Snowflake) Data & Reporting

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