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

    3 weeks 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
  • Applause IT

    Data Engineer

    2 weeks 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 ...

  • DWP Digital

    Data Engineer

    3 days ago

    DWP Digital Birmingham, United Kingdom Full time

    Digital with Purpose. · Are you ready to join a dynamic team at the forefront of digital transformation? · DWP Digital is seeking Data Engineers who are passionate about utilising cutting-edge technologies to deliver impactful data products. · DWP is the UK's largest department, ...

  • Harnham

    Data Engineer

    2 weeks 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 ...

  • Nigel Frank International

    Data Engineer

    2 days ago

    Nigel Frank International Birmingham, United Kingdom

    **BI Developer/ Data Engineer - Birmingham/Hybrid** · Are you a talented BI/Data Engineer with excellent SQL skills, looking for a new and exciting opportunity to work for a growing, ambitious, innovative, expanding company? My client is putting a huge focus on their Data and Rep ...

  • Xpertise Recruitment Ltd

    Data Engineer

    1 week ago

    Xpertise Recruitment Ltd Birmingham, United Kingdom

    Xpertise has partnered with a leading tech consultancy and an established and well-respected FTSE 100 aviation firm embarking on a vast data & IT greenfield project moving from legacy estates to AWS, waterfall to Agile methodologies, & a modern big datatech stack. The client is s ...

  • Harnham - Data & Analytics Recruitment

    Data Engineer

    1 day ago

    Harnham - Data & Analytics Recruitment Birmingham, United Kingdom

    **Data Engineer** · **Up to £60,000 per annum** · **Location - Warwickshire (Hybrid)** · Calling all Data Engineers We have a fantastic new opportunity for you at one of the world's most renowned automotive companies · **The Company** · This company works within an agile environm ...

  • Xpertise Recruitment Ltd

    Data Engineer

    14 hours ago

    Xpertise Recruitment Ltd Birmingham, United Kingdom

    Xpertise is looking for a Data Engineer to join one of our top tech consultancies working on an entirely serverless platform. Please see further details below: · **Day Rate**: £400.00 per day · **Inside** IR35 · **Location**: Remote + offices if you'd like to work on-site · **Len ...

  • Opus Recruitment Solutions Ltd

    Data Engineer

    2 weeks 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

    3 weeks 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

    2 weeks 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

    3 weeks 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 ...

  • Page Group

    Azure Data Engineer

    1 week ago

    Page Group Birmingham, United Kingdom

    Azure Data Engineer | Azure Synapse | Kimball | ETL | Healthcare | Birmingham, West Midlands | Contract | £400 per day · **Client Details** · A leading healthcare programme services provider · **Description** · - Migrating all legacy ETL processes to the new Azure Synapse platfor ...

  • Applause IT

    Senior Data Engineer

    1 week ago

    Applause IT Birmingham, United Kingdom

    **Senior Data Engineer** · **- Hybrid, Birmingham - £50,000 - £60,000 + Benefits** · ApplauseIT are looking for several experienced Senior Data Engineer(s) to join a large and still growing Software Technology and Digital Services Consultancy. The Senior Data Engineer will be res ...

  • Applause IT

    Senior Data Engineer

    1 week ago

    Applause IT Birmingham, United Kingdom

    **Senior Data Engineer** · **- Hybrid, Birmingham - £50,000 - £65,000 + Benefits** · ApplauseIT are looking for several experienced Senior Data Engineer(s) to join a large and still growing Software Technology and Digital Services Consultancy. The Senior Data Engineer will be res ...

  • Harnham

    Senior Data Engineer

    1 week ago

    Harnham Birmingham, United Kingdom

    **Senior Data Engineer** · **(This role does not offer sponsorship)** · **Up to £65,000 per annum** · **WFH: once a month - Leeds-based office** · We have a fantastic new opportunity for a data engineer at a large financial services company. · **The Company** · This company is a ...

  • Akkodis

    D365fo Data Engineer

    3 weeks 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. ...

  • Harnham

    Lead Data Engineer

    1 day ago

    Harnham Birmingham, United Kingdom

    **Lead Data Engineer** · **Up to £100,000 per annum** · **Location - Fully remote** · If you're a Senior/Lead level Data Engineer then congratulations We have a fantastic opportunity for a Lead Data Engineer · **The Company** · The company is a growing group of committed colleagu ...

  • Talk Staff

    Data Cabling Engineer

    1 day ago

    Talk Staff Birmingham, United Kingdom

    Here's a great role for an experienced Data Cabling Engineer to join a progressive IT Services Provider. This role, reporting out of the regional location of Birmingham will see you getting hands-on and delivering high class cabling work to some of the mostwell-known names within ...

  • Nigel Frank International

    Senior Azure Data Engineer

    2 weeks 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 ...

  • Jefferson Frank

    Talend/pentaho Data Engineer

    1 week ago

    Jefferson Frank Birmingham, United Kingdom

    **Talend/Pentaho Data Engineer** · **£55,000 - £75,000** · **Edinburgh/The Midlands/London - Primarily Remote** · My client are one of the biggest names in technology and modern cloud consulting, they boast a world class data and analytics centre and are looking to add to their t ...