High Level Summary Quite a back-end focused role, you'll be one of two Senior Engineers tasked with maintaining & developing the SQL Enterprise Data Warehouse. As part of a small function, you'll have complete freedom to shape how the data strategy is implemented. You'll be encouraged to decide on your own remit in terms of what areas of data operations you'd like to focus on & where you think improvements could be made - either to processes or the tech stack. Currently EDW is based on-premises but will transition over time to cloud-based - this process is another aspect you can get as deeply involved in as you wish. Job Detail Reporting to the Head of Data Operations, the Senior Data Engineer will be responsible for the ongoing maintenance and development of the SQL Enterprise data warehouse (EDW). Youll be part of a Data Management & Support (DMS) team tasked with maintaining and improving the IPB Data Strategy. Youll also be in charge of ongoing maintenance, enhancement of the data assets, associated infrastructure and tools in conjunction with other IT resources. Youll also be liaising with Business Departments to understand their reporting requirements and making the necessary changes in the warehouse environment to deliver on those requirements. Your Main Responsibilities End to End EDW Change Management establishing and clarifying requirements, analysis of the EDW to establish what changes need to be made and where, to the Operational Data Store, Data Warehouse, Tabular models and Data Integration Framework. Providing work estimates to effect those changes, updating the necessary stored procedures, creating/amending tables & views, validating and testing these changes. A big part of your role will also be liaising with the Business to verify the changes and aligning with the deployment process to implement these into a live environment. Planning for fortnightly deployments. Proposal of high-level data architecture enhancements to meet requirements for changes to source systems that flow into the EDW. Design, build and support of the components of data warehouse (EDW) such as ETL processes, databases, reports and reporting environments. Design dimensional models with conformed dimensions, following the business processes. Development and automation of ETL processes including error & reconciliation handling. Review and ensure data loaded into EDW is accurate (Ensure the integrity, validity, and reproducibility of all data in the EDW). Contribute to delivery of Governance & Management framework (Data Life Cycle, Data Quality, Access Control, Documentation Data dictionary, model etc). Contributing to the ongoing development of the IPB data strategy technologically and procedurally and supporting the business in delivering quality MI. The role will not be responsible for the design or content of Business reports, this responsibility will continue to lie with the business. Strong experience with a focus on Data Engineering, Data Analysis, Warehouse Design and development, and Business Intelligence. In depth knowledge and experience of the end-to-end Change and Release Management process for delivering Enterprise Data Warehouse change requests. Technical background to include proficiency in Data warehousing skills, Data Integration & Manipulation techniques, database design, ETL and SQL Reporting Services, SQL Database & Schema planning, design, and optimisation. Excellent knowledge of and proven experience in the following technologies: MS SQL SSMS, Visual Studio, Azure DevOps, Source Control (Git) and SSAS. Proficient working technical knowledge of SQL development & SQL Server (All Editions). Nice to haves: Desirable: Experience with on-premises and/or cloud-based SQL Warehouse implementation, including migrations. Data Base Administration (DBA) skills would be a definite advantage. Good knowledge of DAX, PowerBI, Power Platform, Power Pivot for supporting End user self-service. Remuneration Salary is open depending on experience. Benefits include - Bonus 16.5% | Pension 11% | Healthcare | 25 days annual leave with the option to acquire more Skills: Data Engineering EDW SQL