Data Engineer

Your new company

Sussex Community Foundation Trust, the largest provider of community healthcare services in Sussex, is seeking to recruit two Data Engineers to join an established team of Data professionals in Digital Technology, based in Brighton, East Sussex.

Your new role

Working under the remit of the Head of Data Engineering as part of the Digital Directorate, the Data Engineers will be key members of the Data Engineering team working primarily on day to day ETL operations, as-well as working with the wider Performance Team and Digital Team to meet the data management needs of the Trust.

As a Data Engineer you will be fundamental in developing and constructing data models for our services data warehousing needs as-well as integrating them into systems and business processes to support self-serve reporting, compliance reporting and third-party data integrations.

You will provide specialist advice across a range of IM&T areas eg applications, information interpretation, data analysis, information reporting, information governance.

What you'll need to succeed

As an experienced Data professional with proven skills of managing and maintaining a data warehouse within a large organisation, you will have expertise in writing ETL scripts and code and ensuring that the ETL process performs optimally. The role requirement will involve implementing data flows to connect operational systems, data for analytics and Business Intelligence (BI) systems.

A key responsibility will be to re-engineer manual data flows to enable scaling and repeatable use in an automated way and to support the build of data streaming systems. You should have a thorough understanding of the concepts and principles of Datamodelling and metadata management and you will need to be able to design, code and execute test scripts to support ETL processes defined within our platforms. You should possess strong in-depth knowledge of Database Administration with MSSQL Server and expert knowledge of Microsoft Azure/AWS Platforms (Specifically Cloud Storage, Compute and Databases).

Applicants should have demonstrable experience in the following essential and desirable skills:

Essential:

• Python 3.x with pandas, numpy, sqlalchemy, argparse and logging as a minimum
  MS SQL Server (2019 and later)

Desirable:

• Linux server technologies (Redhat 8+, Ubuntu 22.04+)
• Qlik Data Movement Gateway (linux based)
• Airflow orchestration across multiple technologies (eg powershell, python, T-SQL) and server types (windows and linux, plus SQL server databases)
• Airbyte data movement, including API driven data loading pipelines to dynamically construct the airbyte flows based on metadata concerning the data sources and destinations
• Qlik Data Movement Gateway (linux based)
• Qlik Cloud/Qlik Sense Data Architecture certification

What you'll get in return

This role is available for hybrid working and when a hospital office presence is required for technical workshops and other face-to face purposes, it will include working in Brighton and Hove particularly, and other NHS premises across East and West Sussex. Being close to the sea and the South Downs, with close links to London, it is a vibrant, thriving part of the country in which to work and enjoy that all-important work-life balance through the generous annual leave and flexible working arrangements available. Amongst the unrivalled range of employee benefits includes membership of the renowned and industry respected NHS Pension scheme, and a choice of salary sacrifice discounts to supplement the competitive salary available for this role.

To find out more, click on the 'apply now' button to be considered for this exciting career opportunity with NHS Sussex Community Foundation Trust.