Business Data Analyst - Ref: V313

Total Integrated Solutions Ltd; East Midlands; On-site; GBP 40,000 - 45,000; Full time

Job summary

A leading company in security and communications is seeking a Business Data Analyst to join their Finance/Operations Team. The role involves designing Power BI dashboards, interpreting SQL-based data, and supporting operational decision-making. Ideal candidates will have strong analytical skills and experience with data visualization tools.

Benefits

Annual inflation salary increase

Salary Sacrifice Pension Scheme

Holiday Buy Scheme

Life and Accident Insurance

Medical Cash Plan

Cycle to Work

23 days holiday increasing to 27 days plus 8 bank holidays

Birthday holiday

Employee Assistance Program

Qualifications

• Practical experience with Power BI dashboard development.
• Strong working knowledge of DAX and Power Query.
• Proficiency in VBA for process automation.

Responsibilities

• Design, build, and maintain Power BI dashboards.
• Gather and interpret business requirements for reporting.
• Build and maintain automation scripts using VBA.

Skills

Analytical thinking

Attention to detail

Communication skills

Team player

Flexibility

Tools

Power BI

VBA

SQL

Job description

TIS is a forward thinking and nationally renowned Security and Communications Company who are NSI Gold and BAFE accredited. We specialise in the design, installation, service and maintenance of integrated security systems and manufacture specialist equipment. TIS work with a wide range of public and private sector businesses and have achieved a reputation for quality, care, and reliability, which is second to none.

Our absolute ambition is to provide and maintain a premium service in the industry with staff wellbeing, safety, and environmental considerations at the forefront of our services. Our strategy is to achieve a premium service and a commitment to employees, customers, and all stakeholders. We provide an environment of quality and care helping employees engage with our customers, putting them at the heart of what we do.

Due to the Company’s continued success, we are looking to expand the Finance/Operations Team in the Mansfield area and are seeking an enthusiastic and dedicated Business Data Analyst. This is an excellent opportunity for someone looking to develop their career and become a valued member of the team. You should be positive and enthusiastic having the ability to provide the client with a premium service and the capability to work independently or within a team when required. The Business Data Analyst will support the business by delivering high-quality, actionable insights through Power BI dashboards. The role focuses on interpreting data from SQL-based sources and presenting it in meaningful ways to support operational and strategic decision-making. Supporting internal reporting automation using tools such as VBA, Power Query, and other scripting-based process improvements.

The role involves:

• Design, build, and maintain Power BI dashboards for business users
• Use DAX to develop calculated fields, KPIs, and metrics
• Understand and navigate SQL-based data structures and schemas
• Gather and interpret business requirements for reporting and analysis
• Ensure data accuracy and consistency in reporting outputs
• Collaborate with stakeholders across departments to optimize data use
• Provide support and troubleshooting for BI tools and dashboards
• Assist with ad hoc analysis where needed
• Build and maintain automation scripts and tools using VBA (e.g., Excel macros for data transformation or report preparation)
• Create reusable templates and report logic for future automation and scalability

Key experience / Qualifications:

• Practical experience with Power BI, including dashboard development
• Strong working knowledge of DAX and Power Query
• Good understanding of data relationships, schemas, and reporting logic
• Strong analytical thinking and attention to detail
• Ability to translate data into clear, visual narratives
• SQL Coding experience whilst not necessarily needed would be beneficial
• Proficiency in VBA (Excel macros) for process automation and report scripting

Qualities required:

• Excellent verbal and written communication skills and the ability to negotiate and influence effectively with all levels
• Excellent organisational skills with the ability to take responsibility for own workload and handle multiple priorities
• Ability to deal tactfully and diplomatically and maintain confidentiality with internal and external stakeholders
• A can-do attitude, proactively responsive to change and flexible approach with ability to adapt to changing priorities
• Team player and able to work well under pressure and in a fast-paced environment
• Excellent IT skills, including Microsoft Office 365 – Excel, Word and PowerPoint
• Full Driving Licence

We will offer the following package:

• Working hours: Monday – Friday, 8.00am – 5.00pm
• Salary: £40,000 - £45,000 dependant on skills, experience, and qualifications
• Benefits: Commitment to annual inflation increase in salary, Difference Maker Awards, Salary Sacrifice Pension Scheme, Holiday Buy Scheme, Life and Accident Insurance, Medical Cash Plan, Cycle to Work, 23 days holiday increasing to 27 days plus 8 bank holidays, Birthday holiday, Perks and Employee Assistance Program

To apply:

please submit a short expression of interest along with your CV to the
People Department at [e-mail].

TIS Ltd, Hamilton Way, Oakham Business Park, Mansfield, Notts, NG18 5BU