Jobs
>
Birmingham

    Senior SQL SSIS Data Engineer - Birmingham, United Kingdom - Birmingham Community Healthcare NHS Foundation Trust

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

    1 week ago

    Default job background
    Description

    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
  • Harnham

    Data Engineer

    1 day ago

    Harnham Birmingham, United Kingdom

    **DATA ENGINEER** · **REMOTE (MUST BE UK BASED)** · **UP TO £85,000** · **THE COMPANY** · This company is one of the UK's largest telecommunication businesses. They are a very 'member focused' business, focusing on a great customer experience. Alongside this, they are also B Corp ...

  • Applause IT

    Data Engineer

    1 day ago

    Applause IT Birmingham, United Kingdom

    **Data Engineer** · **- Fully Remote - £70,000 - £80,000 + Benefits** · ApplauseIT are looking for an experienced Data Engineer with a strong understanding of ETL, Python and Cloud exposure is sought by a rapidly growing E-Commerce Marketplace. The environment for the successful ...

  • Opus Recruitment Solutions Ltd

    Data Engineer

    2 days ago

    Opus Recruitment Solutions Ltd West Midlands (Region), United Kingdom

    **Data Engineer |Up to £70,000 | Fully Remote** · **SQL | Python | Kafka | Kuberenetes | Spark | Cloud | ** · Interested in working with cross functional teams, working across Software, Data and DevOps? · A well-established software consultancy firm that're growing at a fast rate ...

  • Trust In Soda

    Data Engineer

    1 week ago

    Trust In Soda West Midlands (Region), United Kingdom

    Are you looking to work for a fast growing company that is looking to change how the real estate industry operates completely? They are looking to use data to change the real estate market completely and you can be a decisive part of that change. · Your responsibilities include: ...

  • Harnham

    Data Engineer Manager

    3 days ago

    Harnham Birmingham, United Kingdom

    **Data Engineering Manager** · **Up to £100,000 per annum** · **Location** - Fully remote · We have a fantastic new opportunity for a data engineering manager at a new and innovative food technology start-up company · **The Company** · This company is a start-up that uses technol ...

  • Harnham - Data & Analytics Recruitment

    Data Engineering Manager

    1 week ago

    Harnham - Data & Analytics Recruitment Birmingham, United Kingdom

    **DATA ENGINEERING MANAGER** · **REMOTE (1x MONTH IN OFFICE) - NORTH LONDON** · **UP TO £95,000** · **THE COMPANY** · This company is one of the world's leading aviation companies. They may be facing the biggest challenge in history, but they are confident that throughout the pan ...

  • Akkodis

    D365fo Data Engineer

    6 days ago

    Akkodis Birmingham, United Kingdom

    My end user client is looking for a D365FO Data Engineer to join their team on a permanent basis. They can offer a hybrid working model, and they've got offices in: London, Edinburgh, Newcastle, Bristol, Basingstoke OR Dundee and you can be part office basedin of these locations. ...

  • Nigel Frank International

    Senior Azure Data Engineer

    3 days ago

    Nigel Frank International Birmingham, United Kingdom

    **Senior Azure Data Engineer - Remote - £65-70k** · Our client is a market-leading Legal researching organisation. They are looking to add an experienced Azure Data Engineer to join a diverse, results-driven, and collaborative team. The purpose of the team is to support the ongoi ...

  • SR2

    Senior & Lead Data Engineers / / Tech

    1 week ago

    SR2 Birmingham, United Kingdom

    "A company of the 22nd century" · While they're not working on flying cars just yet, that's a quote on Glassdoor from an employee who reckons that the work/life balance, the professional & personal growth, the emphasis on environment, social responsibility & community engagement, ...

  • SR2

    Senior & Lead Data Engineers / / Tech

    2 days ago

    SR2 Birmingham, United Kingdom

    "A company of the 22nd century" · While they're not working on flying cars just yet, that's a quote on Glassdoor from an employee who reckons that the work/life balance, the professional & personal growth, the emphasis on environment, social responsibility & community engagement, ...

  • Experis LTD

    Lead Data Engineer Work From Home

    11 hours ago

    Experis LTD West Midlands (Region), United Kingdom

    **Lead Data Engineer** (work from home) · I am looking for a Data Engineer with strong experience in **SQL and Power BI**. You will work with customers on their **Azure / Dynamics / SQL platforms** through **pre-sales to implementation**. Must have the capability to **create, imp ...

  • Sanderson

    Senior Data Engineer- Start Up- Fully Remote

    6 days ago

    Sanderson West Midlands (Region), United Kingdom

    **Senior Data Engineer · - Start Up · - Fully Remote** · **£85k · - £95k + Fantastic Benefits** · I am working with a well-funded, SaaS Tech business that are looking to grow significantly over the next 12 months. · The Senior Data Engineer will help drive forward automation & in ...

  • Nigel Frank International

    Data Engineer

    11 hours ago

    Nigel Frank International Stafford, United Kingdom

    **Data Engineer - Hybrid - Up to £55,000** · I'm currently working with rapidly growing consultancy who work with clients in a range of industries including retail and finance, who are looking for experienced Data Engineer's to join their team. This is a fantastic opportunity to ...

  • Akkodis

    Data Engineer

    11 hours ago

    Akkodis Warwickshire, United Kingdom

    Data Engineer / BI / Business Intelligence / Developer / Consultant / Azure Synapse / SQL / Customer Data / Data Analytics / Data Science / Data Lead / Remote / Warwickshire / £ per day Inside IR35, 3-6 month contract. · One of our leading clients is looking to recruit a Data Eng ...

  • Harnham - Data & Analytics Recruitment

    Data Engineer

    1 week ago

    Harnham - Data & Analytics Recruitment Stratford-upon-Avon, United Kingdom

    **Data Engineer** · **Hybrid, 2x per week in office, Stratford-Upon-Avon** · **£60, 000-£65, 000** · **Permanent** · An exciting opportunity for a Data Engineer to join a major automotive company and join their innovative digital transformation team. · **The Company** · An amazin ...

  • Experis LTD

    Data Engineer

    6 days ago

    Experis LTD Staffordshire, United Kingdom

    **Data Engineer - ETL - SQL - PowerBI - Data Modelling - Microsoft Technologies - Azure -** · **SQL, SSRS, SSIS, SSAS, MS Technology Stack, ETL, Data Modelling, PowerBI, DAX, Data Marts & Data Models, T-SQL Data Warehouse Design.** · **West Midlands, Shropshire, Staffordshire** · ...

  • Homes England

    Data Engineer

    2 days ago

    Homes England Coventry, United Kingdom

    This is a hybrid role. Locations of work can be: Bristol, Coventry, Guildford, Leeds, Liverpool, Manchester, Newcastle or Northstowe · **What we offer...** We understand how important life is outside of work so, as well as competitive salary and 33 days annual leave, we are total ...

  • Talent

    Data Engineer

    5 days ago

    Talent Birmingham, United Kingdom

    Permanent Data Opportunity working within a critical public service organisation · Hybrid working in the West Midlands · Salary starting at £40,005 per a year · Talent is proud to be working with Government client to manage the Data Engineering capabilities, developing and implem ...

  • Xpertise Recruitment

    Data Engineer

    1 week ago

    Xpertise Recruitment Birmingham, United Kingdom

    Job Description · Xpertise is seeking a series of Data Engineers with cloud experience to join a fledgling team in Birmingham. As part of our client's growing engineering division, you will play a pivotal role in leading the data engineering capabilities, working closely with Pla ...

  • Lorien

    Data Engineer

    6 days ago

    Lorien Birmingham, United Kingdom

    Job Description · Senior Data Engineer- Fast growing SaaS Scale up · West Midlands- hybrid working · Up to £86K base with bonus and benefits · The client · SaaS Software business platform which is revolutionising financial management for their customers. · Responsibility: · Wor ...