Data engineer

The Royal College of Surgeons of England; Greater London; Ibrido; GBP 42.000 - 52.000; Tempo pieno

Vantaggi offerti da questo lavoro

Flexible working

Hybrid working

Office in Holborn

20% in-office time required

Pension scheme

27 days holiday + bank holidays

Learning and development opportunities

Descrizione del lavoro

The Royal College of Surgeons of England is seeking a Data Engineer to join its Business Intelligence Unit and help develop a modern Microsoft Fabric data platform. You will work across the full data lifecycle, building trusted, scalable and secure solutions that turn data from multiple source systems into reliable insight for colleagues across the College.

Design, build and maintain Fabric Lakehouses, Data Pipelines, Notebooks and Semantic Models.

Competenze

• Experience designing, developing and supporting data engineering or BI solutions using Microsoft Fabric or an equivalent cloud data platform.
• Strong SQL skills and experience designing and maintaining ETL/ELT pipelines and data models.
• Experience with data governance, security and access controls, and Power BI.
• Ability to manage priorities, meet deadlines and communicate complex concepts clearly.

Mansioni

• Design, build and maintain Microsoft Fabric solutions including Lakehouses, Data Pipelines, Notebooks and Semantic Models.
• Develop and enhance data architecture and scalable ETL/ELT pipelines for enterprise reporting and analytics.
• Integrate data from multiple sources, implement validation, monitoring and data quality controls.
• Create reusable engineering patterns, automation and technical documentation; develop semantic models and BI reports.

Conoscenze

SQL

ETL/ELT pipelines

Data modelling

Power BI

Microsoft Fabric

Data governance & security

Analytical thinking

Communication skills

Strumenti

Fabric Lakehouses

Pipelines

Notebooks

PySpark

Spark SQL

DAX

Power Query/M

Python

APIs

DevOps

Descrizione del lavoro

Описание

The Royal College of Surgeons of England is looking for a Data Engineer to join its Business Intelligence Unit and help develop and support our modern Microsoft Fabric data platform. You will work across the full data lifecycle, building trusted, scalable and secure solutions that turn data from multiple source systems into reliable insight for colleagues across the College.

Задачи

Design, build and maintain Microsoft Fabric solutions, including Lakehouses, Data Pipelines, Notebooks and Semantic Models. Develop and enhance our medallion architecture and create scalable, maintainable ETL/ELT pipelines for enterprise reporting and analytics. Integrate data from multiple source systems, implementing validation, monitoring, reconciliation and data quality controls. Troubleshoot data platform and integration issues, while developing reusable engineering patterns, automation and clear technical documentation. Develop and support semantic models, Power BI reports and dashboards, applying strong data modelling and performance best practice. Work with colleagues across the College to translate business requirements into practical technical solutions and explain complex concepts clearly to non-technical audiences.

Требования

Experience designing, developing and supporting data engineering, analytics or business intelligence solutions using Microsoft Fabric or an equivalent cloud data platform. Strong SQL skills and practical experience designing and maintaining ETL/ELT pipelines, data integration processes, and relational or dimensional data models. Experience working with large, complex datasets and resolving data quality, reconciliation and integration issues. Experience with semantic models and Power BI, together with an understanding of data governance, security and access-control principles. Strong analytical and problem-solving skills, excellent attention to detail, and the ability to manage competing priorities and deliver to agreed deadlines. A collaborative and proactive communicator who can build productive relationships, explain technical concepts to different audiences, share knowledge and promote data-driven decision making.

Будет плюсом: Experience with Fabric Lakehouses, Pipelines and Notebooks, PySpark, Spark SQL, DAX, Power Query/M, Python, APIs, source control or DevOps would be advantageous

Условия

• from £47,000 per annum Permanent, full-time (35 hours)
• We fully support flexible working, from our superb offices in Holborn and from home.
• We do require staff to spend 20% of their time in the office. This is subject to role requirements.
• 27 days paid holiday + bank holidays and up to 4 college closure days over the festive period & other leave entitlements (carers leave, fertility treatment leave, etc.)
• Hybrid and flexible working.
• We require staff to spend a minimum of 20% of their time in the office, subject to role requirements.
• Opportunity to work from outside the UK (up to 2 weeks) (dependant on eligibility)
• Enhanced contributory pension scheme
• Equal access to enhanced parenthood leave
• A range of staff and peer networks
• Employee health and wellbeing committed (Healthcare cash plan, menopause friendly, disability confident employer, mental health first aiders, EAP etc.)
• Retail discount platform
• Sabbatical and volunteering opportunities
• Variety of learning and development opportunities