Senior Analyst and BI Architect

AYMES | B-Corp
Glasgow
2 weeks ago
Create job alert

Position: Senior Analyst and BI Architect

Location: Fully Remote

Reports to: Finance Director

Department: Business Intelligence

Type: Full-Time/ Permanent


Role overview

The Business Intelligence function is an analytical service providing information, analysis and analytical support. We have an aim of 'do once and automate' wherever possible. This approach reduces the analytical overhead and ensures consistency of reporting.

This role sits in the Business Intelligence function which is the main point of contact for most of the team, responding to ad hoc requests and identifying and working with the other functions to support with insightful analysis.

This role will often work as part of multi-disciplinary pods, made up of colleagues, both internal and external to the Insights and Intelligence function, to deliver on projects that require a range of skills and knowledge.


Key Focus Areas:

· You will help drive the strategy and implementation of Business Intelligence across the business, both managing the day-to-day workload whilst overseeing the long-term developments of data from the Customer Data Warehouse, source systems and future roll out of advanced/predictive analytics.

· have the strategic vision to develop and create a BI analytical centre of excellence for the business, with detailed knowledge of Qlik platform. Strong technical experience will also be required, including knowledge of SQL/MySQL and advanced Excel skills including VBA; experience in data visualization tools (eg. QlikView, Power BI, Tableau, Domo etc) and a good understanding of how to manipulate and interpret complex / imperfect data sets.

· As Senior Analyst on insights, you will play a pivotal role in gathering and utilising insights and research to analyse, adapt and shape the business decisions we make.

· You will own and deliver the insight plan across quantitative and qualitative research methods.

· Support all departments in their insight needs and work with them to build and deliver appropriate plans

· Develop quarterly debriefs to encompass all insight to be shared internally and externally via written and verbal presentations as required and appropriate for the audience.

· Support key programmes and projects with their insight needs

· Be one of the champions of the voice of customers across the organisation and be seen as the go-to person for insight and understanding; work cross-functionally to ensure insight is a key input to any major decision-making and planning.


Roles and Responsibilities:

  • unlocking value and insights by joining and analysing data sets from across multiple sources and creating “once source of truth” in Qlik ( or any other data insights platform).
  • drive the strategy and implementation of Business Intelligence Insights and Analytics across the business
  • managing the day-to-day workload whilst overseeing the long-term developments of data from the Customer Data Warehouse, source systems and future roll out of advanced/predictive analytics.
  • Develop the strategic vision and create a BI analytical centre of excellence for the business.
  • Strong technical experience, including knowledge of SQL/MySQL and advanced Excel skills including VBA;
  • experience in data visualization tools (eg. QlikView, Power BI, Tableau, Domo etc) and a good understanding of how to manipulate and interpret complex / imperfect data sets.
  • pivotal role in gathering and utilising insights and research to analyse, adapt and shape the business decisions we make.

· Technical Expertise: Manage and maintain technical systems ,including but not limited to, Qlik, Clickup, Salesforce, SAP Business 1, Pardot, etc and any other information systems acquired.

· Be the expert on defining which systems are optimal to suit company needs and requirements

  • Support all departments, key programmes and projects in their insight needs and work with them to build and deliver appropriate plans
  • Develop debriefs (monthly / quarterly) to encompass all insight to be shared internally and externally via written and verbal presentations as required and appropriate for the audience.
  • be seen as the go-to person for insight and understanding;
  • work cross-functionally to ensure insight is a key input to any major decision-making and planning.

· standardise analytical solutions in terms of user experience;

· keep abreast of emerging / advanced analytics tools / techniques / technologies, as well as new versions of existing software to recommend further value-adding initiatives;

· Seek best practices and bring innovative thinking

· Contribute to building a pipeline of opportunities that fully exploit the benefits of all the databases and information platforms in use across the company.

· ISO27000 Compliance: Serve as an internal auditor to ensure compliance with ISO27000 standards. – ensure GDPR protocols are adhered to across all systems and platforms

· Contribute to the strategic planning of team projects, identifying interdependencies across projects/functions, potential risks and resource requirements and building in contingency and adjustments as necessary.

· Provide systems / platform guidance and support to Strategic Project implementation –including but not limited to any projects that involve NHS platforms/ systems or facilities eg: OffFP10 (AYMES Direct)

· Contribute to short, medium- and long-term business plans, achieving quality outcomes.

· FOI Protocols: Act as BI Records Manager, ensuring Freedom of Information (FOI) protocols and procedures are followed.

· Ensure annual certifications across cyber security/ GDPR security etc are achieved.

· First Point of Contact: Act as the first point of contact for our team, including any customer networks and associated research teams, regarding systems and technical configurations and any Business Intelligence requirements.

· Customer Onboarding: Ensure effective and smooth onboarding processes for new customers within any platforms internally and provide support for any systems glitches or failures in product purchasing across the Sample Service systems or work with external service providers for solutions.

· Analyse, interpret and present data to highlight issues, risks and support decision making

· Ensure GDPR compliance across all data sets and platforms

· Ensure Cyber Security Certificate is achieved annually.

· Provide operational support across all platforms

· Policy Implementation: Support the development and implementation of Business Intelligence and related systems policies and procedures.

· Business Intelligence, Data retention platforms, IT systems and Microsoft Office Suite systems or work experience equivalent

·

Qualifications

  • Degree/ Diploma Business Intelligence, Data retention platforms, IT systems and Microsoft Office Suite systems or work experience equivalent (or related fields Mathematics, Economics, Statistics, Operational Research, or a related quantitative or analytical discipline) or equivalent experience in a similar role


Key Skills

  • Detailed experience in Qlik platform is essential
  • Analytical Subject Matter Experts
  • Ability to provide Descriptive and Diagnostic Analysis
  • Ability to understand and anticipate requirements
  • Pro-actively Identify Improvement Opportunities
  • Initiation & interpretation of in-depth analysis
  • Liaison with other teams on Data & Analytics requirements
  • Support Knowledge into Action
  • Horizon scanning
  • Problem Structuring – solutions orientated
  • Ability to tell an accurate and useful story from data source that helps guide business decisions
  • Commercial astuteness as relates to data interrogation and optimisation
  • Ability to communicate effectively on datasets and data sources and in assessing quality and reliability of sets and outcomes
  • Proven experience building Business Intelligence reports
  • Experience of triangulating data from different sources and demonstrate an appreciation of the differences that might occur in large datasets
  • Able to guide the team in best practice of quality assurance within data input, control and analytics.

· Technical experience / knowledge of SQL/MySQL and advanced Excel

· Experience in data visualisation tools (QlikView, Power BI, Tableau, Domo, SystemOne etc.)

· A good understanding of how to manipulate and interpret complex/imperfect data sets

· Proven experience in a highly numerate or data driven role

  • Must be able to prioritise own work effectively
  • IT literate across Microsoft 365 platform

Desirable criteria

  • Able to build and document complicated and varied types of models including forecasting performance.
  • Can use segmentation and or clustering to better understand population being modelled.
  • Able to apply methods to explore presenting issue and identify key issues.
  • Evidence of post-graduate qualification and continuing professional development.


· Knowledge of ERP and CRM systems, in particular Salesforce and SAP Business1, Pardot etc

· Commitment to quality, promotes high standards.

· looks for collective success.


Personal Attributes:

• Highly organised and detail-oriented

• Ability to work independently and as part of a team

• Strong leadership and motivational skills

• High level of integrity and professionalism

• Hands-on Can-do attitude

• Solutions orientated self -starter

• Able to work autonomously

• Excellent communications Skills across all levels

• Organised, efficient, professional

• Friendly, approachable, collaborative


If you fit the above criteria and would like to be part of a dynamic team of skilled professionals, please submit your application or send your CV to Unfortunately, due to the number of applications we receive, we cannot reply to each application. If you have not heard from us within two weeks of submitting your application, we regret you have not been shortlisted, and we wish you every success in your career search.



Industry

  • Information Services


Employment Type

Full-time


Edit job description


Show less


Screening questionPreferred qualifications

  • Have you completed the following level of education: Bachelor's Degree?
  • Ideal answer: Yes

Related Jobs

View all jobs

Senior Data Analyst

Lead Reporting and Data Analyst

Senior Data Engineer

Senior Data Engineer

Market Risk - Senior IT SME

eDiscovery Project Managers (all levels)

Get the latest insights and jobs direct. Sign up for our newsletter.

By subscribing you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Data Science Jobs for Non‑Technical Professionals: Where Do You Fit In?

Beyond Jupyter Notebooks Ask most people what a data‑science career looks like and they’ll picture Python wizards optimising XGBoost hyper‑parameters. The truth? Britain’s data‑driven firms need storytellers, strategists, ethicists and project leaders every bit as much as they need statisticians. The Open Data Institute’s UK Data Skills Gap 2024 places demand for non‑technical data talent at 42 % of all data‑science vacancies—roles focused on turning model outputs into business value and trustworthy decisions. This guide highlights the fastest‑growing non‑coding roles, the transferable skills many professionals already have, and a 90‑day action plan to land a data‑science job—no pandas required.

McKinsey & Company Data‑Science Jobs in 2025: Your Complete UK Guide to Turning Data into Impact

When CEOs need to unlock billion‑pound efficiencies or launch AI‑first products, they often call McKinsey & Company. What many graduates don’t realise is that behind every famous strategy deck sits a global network of data scientists, engineers and AI practitioners—unified under QuantumBlack, AI by McKinsey. From optimising Formula One pit stops to reducing NHS wait times, McKinsey’s analytics teams turn messy data into operational gold. With the launch of the McKinsey AI Studio in late 2024 and sustained demand for GenAI strategy, the firm is growing its UK analytics headcount faster than ever. The McKinsey careers portal lists 350+ open analytics roles worldwide, over 120 in the UK, spanning data science, machine‑learning engineering, data engineering, product management and AI consulting. Whether you love Python notebooks, Airflow DAGs, or white‑boarding an LLM governance roadmap for a FTSE 100 board, this guide details how to land a McKinsey data‑science job in 2025.

Data Science vs. Data Mining vs. Business Intelligence Jobs: Which Path Should You Choose?

Data Science has evolved into one of the most popular and transformative professions of the 21st century. Yet as the demand for data-related roles expands, other fields—such as Data Mining and Business Intelligence (BI)—are also thriving. With so many data-centric career options available, it can be challenging to determine where your skills and interests best align. If you’re browsing Data Science jobs on www.datascience-jobs.co.uk, you’ve no doubt seen numerous listings that mention machine learning, analytics, or business intelligence. But how does Data Science really differ from Data Mining or Business Intelligence? And which path should you follow? This article demystifies these three interrelated yet distinct fields. We’ll define the core aims of Data Science, Data Mining, and Business Intelligence, highlight where their responsibilities overlap, explore salary ranges, and provide real-world examples of each role in action. By the end, you’ll have a clearer sense of which profession could be your ideal fit—and how to position yourself for success in this ever-evolving data landscape.