описание
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