Business & Data Analyst

Role Overview 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. A key part of this role involves designing and implementing macros to simplify and accelerate data extraction, validation, and reporting processes. Candidates must have a firm knowledge of macro development, particularly in Excel (VBA) or other relevant environments. Development of the role will include other alternatives to macros to improve automation. These may include Power Automate, Power Query, Microsoft Fabric, Power BI or API scripts. Key Responsibilities • Automation Development: • Macro Creation & Optimization: • Software Enhancement: • Data Workflow Support: • Cross-Functional Collaboration: • Testing & Quality Assurance: • Documentation & Training: Skills & Experience Essential: • Solid experience with macro development (e.g., Excel VBA or similar tools). • Basic experience with scripting languages (e.g., Python, PowerShell, or similar). • 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. Desirable: • Familiarity with housing or property data. • Experience working with APIs or integrating systems. • Exposure to survey or asset management software. • Knowledge of automation tools (e.g., Power Query, Power Automate, Power BI or custom scripts for API or Python). What We Offer • 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 • Death-in-service benefit of 2× salary upon successful completion of probation • On-site gym (£15/month membership) and restaurant ALL APPLICANTS MUST BE FREE TO WORK IN THE UK Exposed Solutions is acting as an employment agency to this client. Please note that no terminology in this advert is intended to discriminate on any grounds, and we confirm that we will gladly accept applications from any person for this role