Insight Automation & Analytics Engineer
About the Role An established public‑sector organisation is seeking a Strategic Insight Automation & Analytics Engineer to join their Corporate Development / Business Intelligence function. This role plays a key part in transforming raw data into meaningful insight, supporting automation initiatives, and enabling data‑driven decision‑making across multiple departments. You will work with modern data platforms, automation tools, and cloud technologies to deliver high‑quality analytics products. This position also includes responsibility for mentoring junior developers and supporting cross‑functional teams. Key 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. Essential Skills & Experience * 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