Data & Automation Specialist

MCS Group | Your Specialist Recruitment Consultancy; Ballymena; On-site; GBP 40,000 - 45,000; Full time

Job summary

MCS Group | Your Specialist Recruitment Consultancy is seeking a Data & Automation Specialist in County Antrim to improve operational efficiency through data analysis, automation and reporting.

You will work with multiple teams to reduce manual tasks, develop automated workflows using Power Automate, and build dashboards in Power BI, leveraging Excel, SQL and data sources for insights.

Qualifications

• Experience building Power BI reports and dashboards.
• Experience creating automated workflows using Power Automate.
• Strong Excel and data manipulation skills.
• Familiarity with SQL databases and data integration.

Responsibilities

• Develop and maintain automated workflows using Power Automate.
• Build, maintain and enhance Power BI reports and dashboards.
• Integrate data from sources including Excel, SQL, PDFs, server folders and accounting systems.
• Collaborate with departments to identify automation opportunities and implement solutions.
• Support data exports, transformation and preparation for analysis.
• Maintain and improve existing reporting and automation processes.
• Contribute to continuous improvement projects across the business.

Skills

Power BI

Power Automate

Excel

SQL databases

Analytical thinking

Automation

AI tooling (Copilot)

Team collaboration

Education

STEM degree beneficial

Tools

Power BI

Power Automate

SQL

Job description

Data & Automation Specialist

Location: County Antrim

Salary: £40,000-£45,000 for more experienced hires

Hours: Monday to Friday, 9am-5pm

The Role

We are seeking a Data & Automation Specialist to improve operational efficiency and business reporting through data analysis, automation and process improvement for well known organisation in County Antrim. You will work with teams across the business to identify opportunities to reduce manual tasks, develop automated workflows and provide useful insights through reporting and dashboards.

Key Responsibilities

• Develop and maintain automated workflows using Power Automate.


• Build, maintain and enhance Power BI reports and dashboards.


• Integrate data from sources including Excel, SQL, PDFs, server folders and accounting systems.


• Work with departments to identify automation opportunities and implement practical solutions.


• Support data exports, transformation and preparation for analysis.


• Maintain and improve existing reporting and automation processes.


• Contribute to continuous improvement projects across the business.

Skills & Experience

• Proficiency in Excel and Power BI.


• Experience using Power Automate or similar automation tools.


• Strong numerical and analytical skills, with an understanding of formulas, basic scripting or coding logic.


• A practical approach to problem solving and the ability to learn new tools independently.


• Comfortable using AI tools such as Copilot to support coding and automation.


• Exposure to project management.


• Strong communication skills, attention to detail and the ability to collaborate with different teams.


• Experience with SQL databases and data integration.


• Previous experience delivering reporting or automation in a commercial environment.


• A STEM degree, such as Mathematics, Physics or Engineering, is beneficial but not essential.