Insight Automation & Analytics Engineer

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.

• 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