directly contribute to the development of the Firmwide BI and Data Platform, currently comprising a SQL Server 2022 Data Warehouse, Microsoft Fabric, Power BI Semantic Models and an SSRS/Power BI reporting layer. The Data Warehouse services c.500 reports, which are used across the Firm for reporting, analysis … Warehouse - Development of the SSRS/Power BI Paginated reporting solutions - Development of Power BI/Analysis Services data models, which act as a semanticlayer for the front-end reporting tools - Debugging and fixing failed SQL Server Agent Jobs and relating to Data Warehouse/model loading more »
Architects on the implementation of scalable and secure data pipelines. Design frameworks that integrate data governance principles and manage the data lifecycle effectively. Support semanticlayer design to ensure data structures align with business objectives. Reporting & Analytics : Lead the development of reports and dashboards to deliver key business more »
data streams to our Data Platform. Own and manage the ETL/ELT for the Data Platform end-to-end, including our dimensionally modelled semantic layer. Define and embed data quality measures within data pipelines. Ensure data integrity, monitoring, and alerting are integrated into all solutions. Create and manage more »