Automation & Data Analytics Specialist

Exposed Solutions; Swinton; On-site; GBP 30,000 - 32,000; Full time

Job summary

Exposed Solutions is seeking a proactive Automation Engineer to design macros for data extraction, validation, and reporting. You will develop automation across Power Automate, Power Query, Power BI, and API scripts, improving workflows and data quality.

Ideal candidates have strong VBA/macro experience, scripting basics, API familiarity, and a passion for automation in a collaborative team. UK-based role with onsite work and benefits.

Qualifications

• Solid experience with macro development (e.g., Excel VBA).
• Basic scripting experience (Python/PowerShell).
• Understanding of data validation and transformation processes.
• Strong problem-solving and attention to detail.
• Ability to collaborate with technical/non-technical teams.

Responsibilities

• Design and implement macros to extract, validate, and report data.
• Develop automation alternatives (Power Automate, Power Query, Power BI, API scripts).
• Create and optimize macros.
• Enhance software to improve automation.
• Support data workflows and QA.

Skills

Macro development

Scripting (Python/PowerShell)

Data validation & transformation

Problem solving

Cross-functional collaboration

Learning in fast-paced env

Housing/property data familiarity

APIs/integrations

Automation tools

Tools

Excel

Power BI

Power Query

PowerShell

Python

VBA

Fabric

API

Exposed

Job description

Exposed Solutions is seeking a proactive Automation Engineer to design macros for data extraction, validation, and reporting. You will develop automation across Power Automate, Power Query, Power BI, and API scripts, improving workflows and data quality.

Ideal candidates have strong VBA/macro experience, scripting basics, API familiarity, and a passion for automation in a collaborative team. UK-based role with onsite work and benefits.