This job is now closed
Job Description
- Req#: L0042-24-0591?language=en&page=462&sort=publicationDateDesc
- Design, develop, and maintain complex SQL queries for data extraction, transformation, and reporting
- Collaborate with stakeholders to understand data requirements and translate them into effective database solutions
- Optimize database performance by fine-tuning SQL queries and data storage strategies
- Troubleshoot and resolve database-related issues promptly
- Implement and maintain data security measures to protect sensitive information
- Create and update database documentation, including data dictionaries and schema diagrams
- Stay up-to-date with industry trends and best practices in SQL development
- Proven experience as an SQL Developer
- Strong Proficiency in SQL query writing and optimization
- Familiarity with relational database management systems e.g., SQL Server
- Experience with Snowflake
- Knowledge of database design principles and normalisation
- Experience with data modelling and schema design
- Excellent problem-solving and analytical skills
- Strong communication and teamwork abilities
- Certification in SQL development
- Experience with ELT/ETL processes
- Familiarity with data warehousing/OLAP data modelling patterns
- Experience writing Java or JavaScript
- Knowledge of version control systems (e.g., Git)
- Understanding of database security best practices
- 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 £1000 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
- Design, develop, and maintain complex SQL queries for data extraction, transformation, and reporting
- Collaborate with stakeholders to understand data requirements and translate them into effective database solutions
- Optimize database performance by fine-tuning SQL queries and data storage strategies
- Troubleshoot and resolve database-related issues promptly
- Implement and maintain data security measures to protect sensitive information
- Create and update database documentation, including data dictionaries and schema diagrams
- Stay up-to-date with industry trends and best practices in SQL development
- Proven experience as an SQL Developer
- Strong Proficiency in SQL query writing and optimization
- Familiarity with relational database management systems e.g., SQL Server
- Experience with Snowflake
- Knowledge of database design principles and normalisation
- Experience with data modelling and schema design
- Excellent problem-solving and analytical skills
- Strong communication and teamwork abilities
- Certification in SQL development
- Experience with ELT/ETL processes
- Familiarity with data warehousing/OLAP data modelling patterns
- Experience writing Java or JavaScript
- Knowledge of version control systems (e.g., Git)
- Understanding of database security best practices
- 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 £1000 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
- Proven experience as an SQL Developer
- Strong Proficiency in SQL query writing and optimization
- Familiarity with relational database management systems e.g., SQL Server
- Proven experience as an SQL Developer
- Strong Proficiency in SQL query writing and optimization
- Familiarity with relational database management systems e.g., SQL Server
Job summary
Come and join one of the UKslargest independent providers in neuro and mental healthcare. We proudly employ over 4000+ people -no matter what your experience, we have jobs for everyone. The Active Care Group are dedicated to harnessing the power of data to drive informed decision-making. We are seeking a talented SQL Developer to join our dynamic team and assist our efforts in data visualisation and reporting.
Main duties of the job
As a SQL/Snowflake Developer, you will play a crucial role in developing and optimizing our data warehouse by ensuring data integrity and developing efficient SQL queries and scripts.
About us
Active Care Group are a pioneering national provider of complex care services, delivering pathways and better outcomes for people. We have a collaborative and holistic approach to care underpinned by proven clinical and therapeutic expertise. We specialise in supporting young people and adults with complex needs to make positive progress and lead happier, more independent lives.
Date posted
23 December 2024
Pay scheme
Other
Salary
£40,000 a year
Contract
Permanent
Working pattern
Full-time, Home or remote working
Reference number
007967
Job locations
Remote - Head Office
Remote
Remote
SE1 8UL
Job descriptionJob description
Job responsibilities
What you'll be doing:
What you'll have:
We also want to ensure that individuals with disabilities are provided reasonable facilities to participate in job applications or interviews to perform essential job functions. To support this, we are a Disability Confident committed employer.
What to look forward to:
If you are a knowledgeable SQL Developer with a passion for data, we encourage you to apply for the SQL/Snowflake Developer role at The Active Care Group. Join us in our mission to transform data into actionable insights and drive our business to new heights.
ACGSP
Job responsibilities
What you'll be doing:
What you'll have:
We also want to ensure that individuals with disabilities are provided reasonable facilities to participate in job applications or interviews to perform essential job functions. To support this, we are a Disability Confident committed employer.
What to look forward to:
If you are a knowledgeable SQL Developer with a passion for data, we encourage you to apply for the SQL/Snowflake Developer role at The Active Care Group. Join us in our mission to transform data into actionable insights and drive our business to new heights.
ACGSP
Person SpecificationPerson Specification
Experience
Essential
Experience
Essential
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.
Employer details
Employer name
Active Care Group
Address
Remote - Head Office
Remote
Remote
SE1 8UL
Employer's website
Employer details
Employer name
Active Care Group
Address
Remote - Head Office
Remote
Remote
SE1 8UL
Employer's website
About the company
National Health Service (NHS) is the umbrella term for the publicly-funded healthcare systems of the United Kingdom (UK). The founding principles were that services should be comprehensive, universal and free at the point of delivery—a health service based on clinical need, not ability to pay. Each service provides a comprehensive range of health services, free at the point of use for people ordinarily resident in the United Kingdom apart from dental treatment and optical care.