Data Engineer, SQL, Home Based

2 weeks ago

Birmingham, United Kingdom Birmingham Community Healthcare NHS Foundation Trust Full time

An exciting opportunity has arisen to work in the information team at Birmingham Community Healthcare NHS foundation Trust, we are looking to build the very best data engineering solutions, data modelling and maintenance processes within the trust SQL data warehouse. This is a great opportunity to bring your own insight and knowledge to build upon current methodologies, designing and developing data solutions across significant volumes of data and provide insight to the business intelligence function and wider team.
You will be responsible for strategic design and development of the Trust's information data models and contribute extensively to the delivery of innovative data schemes to support the Business Intelligence function ensuring that information flows and datasets are available to support and improve healthcare delivery and enable the Trust to meet its corporate and clinical targets as well as the goals and targets established by outside agencies
Please ensure you check your TRAC account regularly as this is how we will communicate with you during the shortlisting and selection process.


~ Please particularly ensure that you provide full details of all referees including BUSINESS EMAIL ADDRESS , telephone contact details and postal address


Birmingham Community Healthcare NHS Foundation Trust (BCHC) has more than 5000 staff working across Birmingham and the West Midlands in a wide range of community nursing and specialist healthcare roles. BCHC delivers over 100 clinical services, in people's homes, health centres, clinics and inpatient facilities. We deliver a wide range of services for children, young people, parents and families as well as adults and community services, two community hospitals, services for people with learning disabilities, the internationally recognised West Midlands Rehabilitation Centre and one of Europe's leading Dental Hospitals and School of Dentistry. We deliver all of this with a commitment to integrated, personalised care that is rooted in our local communities. We have an ambition to deliver outstanding, integrated care as one of the key NHS providers in the West Midlands.


If you want to 'Be Part of Our Team' and work with a Foundation Trust which is continuously striving for better care and healthier communities, we want to hear from you.
As a Senior Data Engineer, you will be responsible for the development and deployment of the Trusts data within the data warehouse environment, which consists of multiple SQL Server databases that capture data from the Trusts multiple data sources including Electronic Patient Record systems, Electronic Staff Records, Finance, and other disparate internal and external data sources. The post holder will work alongside other members of the Information and DevOps Team, to provide an appropriate platform to support the delivery of the information strategy required to deliver and underpin the Trusts Strategic and operational objectives


Working with other data engineers, the post holder will be responsible for the development and implementation of data models for operational, contractual, statistical and information aspects of the Trust contributing to planning and formulation of strategies for Information.
The post holder is responsible for the development and delivery of a comprehensive dataset framework incorporating all Trust systems within the data warehouse, for relational database modelling, master data management, application design with associated business rules.
Be the technical lead on the delivery and development for the information service line agreement monitoring (SLAM) dataset framework, activity pricing models.
To assist the Senior Development Manager with the strategic development of the Data Engineering function. Developing coherent strategies for continual development of the trust data models and underwriting of the Trust Information Strategy
To take responsibility for the planning, creation, implementation, maintenance and on-going evolution of big data / data models / data marts / data cubes within the Trusts data warehouse, sourced from a wide variety of information systems including patient, staffing, financial and other disparate internal and external data sources.
To take responsibility for the maintenance and continued development of contract and commissioning datasets including SUS, CDS and CSDS files
Working with and assisting Data Base Administrators (DBAs) ,to design and develop the structure, procedures and functions of the Trusts data warehouse data models. Including data security, responsibility for the administration of permissions to the Trusts data warehouse datasets.
To enable, promote and support the effective use of data, information, knowledge and technology to support and improve healthcare delivery.
To develop automated data loading (ETL) and validation processes, at the same time maintaining efficient data warehouse metadata structures.
To develop and extend expertise in database design concepts and SQL server language, including T-SQL, ETL (SSIS and/or DTS), SSAS and SSRS.
To ensure high quality data warehouse security, putting in place robust security measures to allow adequate access for the required users whilst protecting sensitive patient-identifiable data

Qualifications / training
IT Professional Qualification
SQL Qualification, Microsoft data warehouse technologies or equivalent

Project management qualification (PRINCE)


Extensive experience of design & operation of large scale, complex data models & processing procedures
Extensive understanding of relational database theory and technology

Extensive experience of working within a heath care Informatics environment with NHS information and Data Standards
Experience of developing new data warehouses or of extensive data warehouse re-development

In depth and thorough knowledge of Microsoft data warehouse technologies
Good working knowledge of Data Warehouse technology and report writing, analysis methodologies.
Competent in the use of Knowledge of Microsoft Analysis Services, SQL-T
Knowledge of Sequel Server Integration Services (SSIS), Sequel Server Analysis Services (SSAS), Sequel Server Reporting Services (SSRS)
Proficient in the use of Microsoft applications, particularly Word And Excel

Knowledge of Project Management methodologies i.AGILE
Personal qualities
Self-motivating with a flexible approach to work and ability to work independently

Birmingham Community Healthcare NHS FT

  • Experienced SQL Data Engineer – Prestigious Client

    2 weeks ago

    Birmingham, United Kingdom Integrity Recruitment Solutions Limited Full time

    Experienced SQL Data Engineer – Prestigious ClientAn innovative client, making a significant impact within their sector, my client is going through a major business / systems transformation programme with a core focus of that being centred around their Data and BI / Reporting.The client is a reputable global brand and this role is integral to the success...

  • Experienced SQL Data Engineer – Prestigious Client

    4 days ago

    Birmingham, Birmingham, United Kingdom Integrity Recruitment Solutions Limited Full time

    Experienced SQL Data Engineer – Prestigious ClientAn innovative client, making a significant impact within their sector, my client is going through a major business / systems transformation programme with a core focus of that being centred around their Data and BI / Reporting.The client is a reputable global brand and this role is integral to the success...

  • Data Engineer SQL

    18 hours ago

    Birmingham, United Kingdom Synechron Full time

    We're Synechron, a global consultancy Laser-focused on accelerating digital initiatives in financial services with over 14,500 members of staff across 19 countries and a unique mix of end-to-end digital, business and technology services, we help clients solve complex challenges with modern and innovative solutions. Our clients come to us with problems that...

  • SQL BI

    2 weeks ago

    Birmingham, United Kingdom Integrity Recruitment Solutions Limited Full time

    SQL BI / Datawarehouse Lead Developer – Home / Prestigious ClientPrestigious across their sector, my client has an excellent market image and continues to make a significant impact.They are heavily involved in an ambitious business / systems transformation and we have an excellent opportunity for an established SQL / BI Developer to join their team.The...

  • Customer Data

    2 weeks ago

    Birmingham, United Kingdom DataTech Analytics Full time

    Description Customer Data & Insight Analyst - SQL £Negotiable dependant on experience Hybrid working from either London (Euston) or Central Birmingham offices Reference J12774 Are you a data professional with an interest in customer behaviour? Do you want to be the person who translates customer data into meaningful understanding that we can use to...

  • Customer Data

    2 weeks ago

    Birmingham, United Kingdom Datatech Full time

    Customer Data & Insight Analyst - SQL£Negotiable dependant on experienceHybrid working from either London (Euston) or Central Birmingham officesReference J12774Are you a data professional with an interest in customer behaviour? Do you want to be the person who translates customer data into meaningful understanding that we can use to improve the customer...

  • Customer Data

    2 weeks ago

    Birmingham, United Kingdom Datatech Analytics Full time

    Customer Data & Insight Analyst - SQL £Negotiable dependant on experience Hybrid working from either London (Euston) or Central Birmingham offices Reference J12774 Are you a data professional with an interest in customer behaviour? Do you want to be the person who translates customer data into meaningful understanding that we can use to improve the...

  • Senior Engineer, Data Engineering

    2 weeks ago

    Birmingham, United Kingdom Lorien Full time

    Data Engineer ~ Hybrid, West- Midlands ~£56k + bonus & great benefits Our client are a fast growing SaaS scale-up, revolutionising supply chain ecosystems and increasing revenue for their customers. You'll contribute to the organisation's high-quality data engineering practices, participating in technical design, implementation, testing,...

  • Senior Engineer, Data Engineering

    10 hours ago

    Birmingham, United Kingdom Lorien Full time

    Job Description Data Engineer ~ Hybrid, West- Midlands ~£56k + bonus & great benefits Our client are a fast growing SaaS scale-up, revolutionising supply chain ecosystems and increasing revenue for their customers. You'll contribute to the organisation's high-quality data engineering practices, participating in technical design, implementation,...

  • Senior Engineer, Data Engineering

    2 weeks ago

    Birmingham, United Kingdom Lorien Full time

    Data Engineer ~ Hybrid, West- Midlands ~£56k + bonus & great benefits Our client are a fast growing SaaS scale-up, revolutionising supply chain ecosystems and increasing revenue for their customers. You'll contribute to the organisation's high-quality data engineering practices, participating in technical design, implementation, testing,...

  • Data Integration Engineer

    1 week ago

    Birmingham, United Kingdom Lorien Full time

    Data Integration Engineer - £58K + bonus ~ West Midlands-hybrid working (3 days in office) SaaS Software business platform which is revolutionising financial management for their customers. Working with Customer Success to configure data integration's. Create custom SQL exports for customers. Provide advice to on-boarding teams around customer...

  • Data Product Owner

    6 days ago

    Birmingham, United Kingdom Harnham - Data & Analytics Recruitment Full time

    **PRODUCT DATA OWNER** **£65,000 - 75,000** **REMOTE** Be influential in the growth of the SAAS data product within a globally renowned brand! **THE COMPANY** A global leader in their market, this brand is looking to grow their capabilities through a data driven automated product. They support flexible working, development and offer limitless...

  • 1st/2nd Line Application Support Engineer

    11 hours ago

    Birmingham, United Kingdom Mentmore Full time

    Job Description 1st/2nd Line Application Support Engineer - SQL £Birmingham - Hybrid working Model (3 days from home a week) - Some UK travel (fully expensed) A leading national meat production company, are looking for a Application support specialist to assist with all 1st/2nd line Application queries. You will need to show knowledge and hands on...

  • Application Support, SQL Saas}

    4 weeks ago

    Birmingham, United Kingdom Ernest Gordon Recruitment Limited Full time

    **Application Support, SQL {**SaaS**}**_Redditch_ **£30,000** to **£40,000** + Progression Opportunities + Training + Company Benefits - Are you an experienced Application Support with SQL experience who is looking to join a global software company with offices located in places like Australia, Brazil, Dubai and the US?_ On offer is the chance to join a...

  • Senior Technical Data Consultant

    4 weeks ago

    Birmingham, United Kingdom MSA Data Analytics Ltd Full time

    This is an exceptional opportunity for a senior GIS/Analytics professional to join an innovative data led solutions provider at a time of significant growth. You will be responsible for driving forward key data/modelling projects and designing innovative GIS & Geospatial whilst supporting the development of cutting edge data products. For success in this...

  • Senior Data Engineer

    4 weeks ago

    Birmingham, United Kingdom VIQU Limited Full time

    **Senior Data Engineer - £45-86k - UK Remote Working - Must have SC Clearance** Our client, a leading consultancy business is looking for outstanding talent to join their vibrant and growing team.With cutting-edge resources, are you the next hire to join their passionate team. **Main responsibilities of the Senior Data Engineer**: As a Senior Data...

  • Azure Data Engineer

    3 days ago

    Birmingham, United Kingdom Change-it Professional Services Ltd Full time

    Data Engineer / Azure Data Engineer £48-70k dependent on experience Birmingham, West Midlands – hybrid A Data Engineer is needed at this established software company in Birmingham as it continues a period of growth and expansion. This is a critical role in ensuring that the business is making the most of their data and turning it into commercial...

  • Data Entry Administrator

    4 weeks ago

    Birmingham, United Kingdom TribePost Full time

    **Why do we want you?** You are an experienced Data Entry Clerk / Administrator ready for a new opportunity that offers flexibility with home working and part time hours. You maintain a high level of accuracy when working with a high volume of data and enjoy working to deadlines. **About us** Smee & Ford (Part of MiExact who are in Wilmington’s I&D...

  • Specialist Data Analyst

    4 weeks ago

    Birmingham, United Kingdom Lorien Full time

    Data Integration Engineer - £58K + bonus ~ West Midlands-hybrid working (3 days in office) SaaS Software business platform which is revolutionising financial management for their customers. Working with Customer Success to configure data integration's. Create custom SQL exports for customers. Create custom Javascript imports for customers. ...

  • Specialist Data Analyst

    4 weeks ago

    Birmingham, United Kingdom Lorien Full time

    Data Integration Engineer - £58K + bonus ~ West Midlands-hybrid working (3 days in office) SaaS Software business platform which is revolutionising financial management for their customers. Working with Customer Success to configure data integration's. Create custom SQL exports for customers. Create custom Javascript imports for customers. ...