Salary: £39,600 - 50,400 per year Requirements: Strong experience designing and managing analytical assets such as semantic models, Lakehouses, and warehouses. Background in data modelling, cloud data environments, and deployment pipelines. Demonstrable experience delivering analytics solutions using Power BI / Microsoft Analytics stack. Skilled in preparing, enriching, and maintaining data assets, including documentation. Experience building dashboards, reports, and cubes (SQL, DAX, MDX, Power BI or similar tools). Experience developing RPA solutions with Blue Prism. Ability to gather business requirements and collaborate effectively with developers, analysts, data scientists, and wider stakeholders. Strong communication, presentation and interpersonal skills. Ability to self-manage in a dynamic, fast-moving environment. Strong problem-solving capabilities and ability to manage conflicting priorities. Responsibilities: Develop Robotic Process Automation (RPA) solutions using Blue Prism to streamline operational processes and improve efficiency. Design and document data preparation processes, semantic models, Lakehouses, and data warehouse structures to support analytics and reporting. Ingest, prepare and transform data using pipelines, dataflows, notebooks, and automation technologies including AI/ML, Power Automate, and Power Apps. Build user-facing visualisations and dashboards, combining multiple data sets to create actionable insights for stakeholders. Design and implement enterprise data storage solutions, ensuring consistent use of reusable semantic models and a single source of truth. Engage with technical and non-technical stakeholders to understand requirements, assess risks, and communicate insights clearly. Lead testing and UAT activities to ensure accuracy, quality and sign-off of analytical products. Collaborate across governance, data, cloud, and infrastructure teams to develop sustainable and controlled analytics solutions. Represent the analytics function at stakeholder meetings and contribute to solution design and decision-making processes. Technologies: AI Business Intelligence Cloud Data Warehouse DAX Support Power BI RPA SQL DevOps More: We are an established public-sector organization seeking a Strategic Insight Automation & Analytics Engineer to join our Corporate Development / Business Intelligence function. In this role, you will be pivotal in transforming raw data into meaningful insights, supporting automation initiatives, and enabling data-driven decision-making across multiple departments. You will work with modern data platforms, automation tools, and cloud technologies while mentoring junior developers and collaborating with cross-functional teams. last updated 12 week of 2026