Job summary An exciting opportunity has arisen to join the highly regarded Business Intelligence team at Stockport NHS FT as we continue to develop our data warehouse and Tableau business intelligence visualisations, transforming data into intelligence to support performance management, effective decision making, and service improvement.
The post of Senior Data Engineer is pivotal to drive the development and ongoing maintenance of the Trust-wide Data Warehouse and reporting/dashboard solutions.
Reporting to the Head of Data Engineering and working alongside other data warehouse developers you will play a key role in the development of the Trust data warehouse, experience of working with large relational datasets and implementing data warehousing solutions is critical.
You will build robust ETL processes that pull data from multiple clinical systems into thedata warehouse.
You will demonstrate extensive knowledge and experience of working with all aspects of SQL Server including advanced SQL, SSIS, SSRS & SSAS gained through working in a data management and information delivery environment.
Main duties of the job Along with advanced technical and analytical skills, you will ideally have experience in working with NHS data.
You will possess excellent communication skills, working with colleagues across clinical and operational teams to understand complex reporting requirements.
You will also be skilled in data visualisation, delivering insightful and impactful analytics using Tableau.
You will have excellent team leadership qualities, be highly motivated and will ensure tasks are delivered on time.
You will be proactive and innovative in your approach to problem solving and deliver tailored solutions.
About us We hold a unique position in the Stockport community as the provider of healthcare and we are one of its largest employers.
We believe that the best organisations are those that reflect the communities they serve.
We are therefore seeking to improve the diversity of our workforce to make it truly representative of our local population.
We actively encourage applications irrespective of race, age, disability, sex, gender reassignment, gender identity or expression, sexual orientation, religion or belief, marriage & civil partnership, or pregnancy or maternity.
Recognising those communities that are underrepresented within our workforce, we would particularly welcome applications from you.
If you require support with your application please contact a member of the recruitment team, who can discuss alternative application methods.
We recognise that flexible working is important.
We take requests for flexible working seriously, consider any request we receive and try to work with you, so we can explore if your request may fit with the needs of the service.
Benefits we offer to you: Between 27-33 days of annual leave plus bank holidays NHS pension scheme membership Salary sacrifice schemes for lease cars, home electronics and more, to make your salary go further NHS Staff discounts Cycle to work scheme Salary finance - for loans, savings, budget planning and tips on managing debt Stockport Credit Union- for local financial advice Job description Job responsibilities You will join a friendly, supportive and dedicated Business Intelligence team committed to delivering a high quality and responsive service to the Trust.
We are committed to providing a supportive work environment and promoting learning and development opportunities.
Please refer to the Job Description/Person Specification for full details of the role and responsibilities.
The Trust is committed to safeguarding and promoting the welfare of children, young people and vulnerable adults and expects all staff and volunteers to share this commitment and promote safeguarding by implementing the Trusts policies and procedures, acting promptly on concerns, communicating effectively and sharing information appropriately.
Person Specification Qualifications Essential Masters qualification and / or relevant experience Evidence of continuing professional development Desirable Microsoft SQL Server MCSA certification Experience Essential Experience in implementing, managing and administrating Data Warehouse solutions Experience of setting up, and maintaining old and new extracts into a Data Warehouse Able to demonstrate a track record of achievement in database and dashboard/report development Desirable Experience of Tableau Server administration Experience of using C#, JavaScript and Python Skills Essential Excellent communication, presentation and interpersonal skills Able to manage, motivate and develop staff Knowledge Essential Advanced knowledge and experience of using SQL server and the Microsoft BI stack (SSIS, SSAS, SSRS) Advanced knowledge and experience of T-SQL Substantial knowledge and experience of developing ETL solutions using SSIS to load and integrate data from disparate data sources Knowledge and experience of Tableau development (dashboards/reports)