Business & Data Analyst

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

Salary: £30,000 - 32,000 per year

Requirements

• Solid experience with macro development, such as Excel VBA or similar tools.
• Basic experience with scripting languages, such as Python or PowerShell.
• Understanding of data validation and transformation processes.
• Strong problem-solving skills and attention to detail.
• Ability to work collaboratively with technical and non-technical teams.
• Eagerness to learn and grow in a fast-paced environment.
• Familiarity with housing or property data.
• Experience working with APIs or integrating systems.
• Exposure to survey or asset management software.
• Knowledge of automation tools such as Power Query, Power Automate, Power BI, or custom scripts for API or Python.

Responsibilities

• Design and implement macros to simplify and accelerate data extraction, validation, and reporting processes.
• Develop other automation alternatives to improve workflows, including Power Automate, Power Query, Microsoft Fabric, Power BI, or API scripts.
• Create and optimize macros.
• Enhance software to improve automation.
• Support data workflows.
• Collaborate with cross-functional teams.
• Test solutions and support quality assurance.
• Document work and provide training.

Technologies

• API
• Excel
• Fabric
• Support
• Power BI
• Power Query
• PowerShell
• Python
• VBA
• Exposed

More

We are seeking a proactive and technically skilled Automation Engineer to join our growing team. This role is ideal for someone with a passion for automation, data workflows, and software enhancement. We offer an auto-enrolment pension scheme with company match up to 5% after 3 months of employment, 30 days annual leave including public holidays plus 3 additional days over the Christmas/New Year period, healthcare cover upon successful completion of probation, a death-in-service benefit of 2x salary upon successful completion of probation, and an on-site gym with restaurant. The role is based in a team environment focused on improving automation and data processes, and applicants must be free to work in the UK.

last updated 36 week of 2026