SQL Developer

Alternative Futures Group ,
Prescot, Merseyside
More Details
Salary: £33,293 per annum - 37.5 hours p/w + perks/benefits

Overview

Alternative Futures Group is the North West’s largest Mental Health and Learning Disability charity. With a strong track record of over 25 years, we work locally in the community and through our Treatment and Recovery Centres to provide a wide range of innovative and bespoke care services. We have a vision to create a world where people control their lives. Here at AFG, we pride ourselves on helping the people we support to design, develop and ‘own’ the support they receive by planning this with them; we support people to make informed choices and increase their own independence; and we support people to maintain their own health, wellbeing and living environment. These principles are really important to us. As a ‘values based’ employer, the people that work for us genuinely care about the people they support, and we are seeking likeminded people to join our AFG family. If you are passionate about working in Health and Social Care and have a real desire to make a positive difference to the lives of the people we support then we would love to hear from you. At AFG we also recognise the contribution and value that our staff make. We would not be able to provide the life changing support that we do without people like you In return for your contribution we will support you throughout your career and we provide a wide range of employee benefits, career development and lifestyle support services to ensure that you too feel supported, fulfilled and valued from day one of your employment with us. Join our Business Systems team at a key point in our Data and Reporting overhaul. Be a pivotal lead in designing and implementing our data warehouse to support the launch of PowerBI. Lead in transforming our self-serve reporting capabilities and support the implementation of new Finance, Compliance and Operational systems through data migration and configured integrations. From Queries, Stored Procedures and SQL Server Agent jobs, to creating inspiring visualizations and reports to inform business direction, the role will keep you on your toes and give you the opportunity to utilize all your skills. JOB DESCRIPTION Title: SQL Developer Reports to: Business Systems Manager Job Purpose To develop MS-SQL queries and procedures, create SSRS reports, optimise queries, stored procedures and functions to enhance organisational productivity. Key Accountabilities Understand the business structure, processes and procedures. Understand the complex database schemas for each of the core systems. Write complex SQL queries and utilise reporting tools like SSRS or Power BI to present meaningful MI to the organisation. Create tables, views, functions, triggers, stored procedures etc. in SSMS. Develop, implement and optimise queries, stored procedures and functions. Analyse existing SQL queries for performance improvements. Write and implement any necessary data cleanses. Review and interpret ongoing business reporting requirements & develop the associated reports. Manage reporting requirements / issues logged via the support desk and work to tight SLAs. Document existing SQL code in non-technical jargon. Support / implement the more complex system configuration requirements. Assist in the planning and implementation of a Data Warehouse. Test quality of own development work, prior to passing over to QA and UAT. Develop and maintain best practice policies, procedures, standards and system level documentation. Escalate any concerns e.g. around underlying data quality with the IT Management Team and Business System Owners. Responsibilities common to all Employees Demonstrating good judgment and sound decision making by reflecting an appropriate situational awareness, understanding of context and making informed choice when reaching decisions. Leading and promoting initiatives that support our organisational aim to be socially and environmentally responsible. Leading and supporting initiatives/projects that promote AFG as a digitally enabled organisation. Establishing, maintaining and developing professional working relationships with colleagues and external partners. Contributing generally to the development of quality services. Upholding the values, mission and vision of AFG at all times. Adhering to AFG policies and procedures and to operate within the law at all times. Demonstrating continuous professional development, encouraging others to do the same and to operate within the AFG performance management framework. Working with Corporate teams effectively to ensure the best outcome for the people supported. Complying with Equality and Diversity policy. Complying with Code of Conduct. Working flexibly in accordance with organisational need. Travelling within the operational and business area of AFG. Acting with integrity, transparency and openness at all times. You can view the full Person Specification for this role here . Infection Control All employees are required to be familiar with and comply with infection prevention and control policies relevant to their area of work. Health & Safety: You have a legal responsibility not to endanger yourself, your fellow employees and others by your individual acts or omissions. The postholder is required to comply with the requirements of any policy or procedure issued in respect of minimizing the risk of injury or disease. All accidents must be reported to your Manager and in line with the general philosophy of the organisation. This job description is a guideline and is in no way restrictive or definitive and non-contractual. It is subject to annual review with the post holder to meet the changing needs of Alternative Futures Group. This job was originally posted as www.totaljobs.com/job/89791487

People also viewed