At a Glance
- Tasks: Design and build a data warehouse, develop integration pipelines, and create Power BI reports.
- Company: Join a large-scale public sector programme with a focus on impactful data solutions.
- Benefits: Competitive contract rate, flexible working arrangements, and the chance to work on critical projects.
- Other info: Opportunity to work in a dynamic environment with potential for future contracts.
- Why this job: Make a difference by delivering essential data solutions for a mission-critical system.
- Qualifications: Experience in data warehousing, Azure Data Factory, and Power BI required.
The predicted salary is between 50000 - 60000 £ per year.
A large-scale data warehouse programme has completed its discovery and requirements definition phase. This engagement will focus on end-to-end delivery, including building the data warehouse, developing integration pipelines, creating the semantic layer, and delivering Power BI reporting aligned to established architecture and design. The source system is a mission-critical, always-on, globally connected Case Management System. The solution must support nightly data ingestion with zero disruption to system availability.
Key Responsibilities
- Design and build a star schema data warehouse and associated data marts, including fact and dimension tables (e.g., Fact Cases, FactCaseEvents, Date, Case, Status, User, Organisation)
- Implement Slowly Changing Dimensions (SCD) where appropriate
- Develop and optimise Azure Data Factory (ADF) pipelines to ingest data from the core system, ensuring efficiency across global time zones and 24/7 operations
- Build Power BI tabular models and datasets to form the semantic layer, including robust row-level security (RLS)
Data Warehouse Engineer (SC Enhanced) employer: Tenth Revolution Group
As a leading player in the public sector, our company offers an exceptional work environment for Data Warehouse Engineers, where innovation meets purpose. With a strong commitment to employee development, we provide extensive training opportunities and a collaborative culture that values diverse perspectives. Located in a dynamic area, our team enjoys the benefits of flexible working arrangements and the chance to contribute to impactful projects that enhance public services.
