Salary: £? - ? per year Requirements: We need advanced hands-on experience with Microsoft Fabric, including end-to-end implementations. We need strong experience designing and implementing ETL and ELT pipelines. We need expertise in Power BI architecture and semantic model optimisation. We need a strong understanding of modern enterprise data architecture principles. We need experience with data lake technologies, ideally Databricks. We need strong integration and interface management experience. We need experience operating within enterprise-scale analytics environments. We need advanced SQL and T-SQL skills. We need Python experience for data engineering, automation, and transformation. We need DAX experience for Power BI semantic modelling. PySpark or Spark experience is highly desirable. We need Microsoft Azure ecosystem knowledge. We need strong communication skills across technical and non-technical audiences. We need a collaborative, relationship-driven approach. We need a passion for quality, governance, and best practice. We need an adaptable, problem-solving mindset. We need a desire to mentor others and stay current with emerging technologies. Responsibilities: We will assess and improve our current analytics and data environment. We will review our Microsoft Fabric architecture. We will review our enterprise data warehouse structures. We will review our ETL and ELT pipelines and data flows. We will review our semantic models. We will review and optimise our Power BI reporting architecture. We will provide clear, prioritised recommendations following the review. We will lead improvements focused on scalability and maintainability. We will drive improvements in performance and reliability. We will reduce technical debt across our data landscape. We will optimise operational and platform costs. We will shape architecture while remaining hands-on with implementation. We will work proactively in a dynamic and evolving environment. We will communicate effectively with technical and non-technical stakeholders. We will collaborate closely with our teams and build strong working relationships. We will support governance, quality, and best practice across our data solutions. We will mentor others and help develop our wider technology capability. Technologies: Architect Azure Data Warehouse Databricks DAX ETL Fabric Support Power BI Python PySpark SQL Spark Cloud More: We are partnering with a well-established organisation in the construction and infrastructure sector to appoint a highly capable Senior Data Architect into our growing technology function. This is a key hire as we continue to modernise and optimise our data landscape. The role is a hands-on technical position with hybrid working from a site near Euston Station, requiring three days per week on site. It is an initial contract running until 30/07/2027 and is inside IR35. We are looking for someone who can operate at both strategic and technical depth, helping us deliver scalable, high-performing, and cost-efficient data solutions across the organisation. last updated 23 week of 2026