Business & Data Analyst

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