Senior Analyst and BI Analyst

Aymes International; Leek; Remote; GBP 40,000 - 80,000

Job description

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 aim to 'do once and automate' wherever possible, reducing analytical overhead and ensuring consistency of reporting.

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

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

Key Focus Areas:

• You will help drive the strategy and implementation of Business Intelligence across the business, managing the day-to-day workload while overseeing the long-term developments of data from the Customer Data Warehouse, source systems, and the future roll-out of advanced/predictive analytics.
• Have the strategic vision to develop and create a BI analytical centre of excellence for the business. Strong technical experience is required, including knowledge of SQL/MySQL and advanced Excel skills including VBA; experience in data visualization tools (e.g., QlikView, Power BI, Tableau, Domo) 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 utilizing insights and research to analyze, adapt, and shape business decisions.
• 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 insights 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 organization 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:

• Unlock value and insights by joining and analyzing data sets from across multiple sources and creating a “single 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.
• Manage day-to-day workload while overseeing 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 (e.g., QlikView, Power BI, Tableau, Domo) and a good understanding of how to manipulate and interpret complex/imperfect data sets.
• Play a pivotal role in gathering and utilizing insights and research to analyze, adapt, and shape business decisions.

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 insights 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.

ISO27000 Compliance: Serve as an internal auditor to ensure compliance with ISO27000 standards and 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 (e.g., 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 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 in 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

• Analytical Subject Matter Expert.
• Ability to provide Descriptive and Diagnostic Analysis.
• Ability to understand and anticipate requirements.
• Proactively 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-oriented.
• Ability to tell an accurate and useful story from data sources that helps guide business decisions.
• Commercial astuteness as relates to data interrogation and optimization.
• 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 visualization 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.

Strong interpersonal skills and ability to build internal relationships with key stakeholders.

• Previously responsible for a budget, involved in budget setting and working knowledge of financial processes.
• Experience in using a range of statistical software such as SAS, SPSS, R, and SQL.
• Technical skills in data management, business intelligence, and analytics – including data modeling, data visualization (e.g., Tableau and Qlik), and data blending (e.g., Alteryx and SSIS) along with other supporting tools (e.g., Microsoft BI stack, System1).
• Ability to make decisions autonomously.
• Demonstrates a strong desire to improve performance.
• Must be able to prioritize 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 the population being modeled.
• Able to apply methods to explore presenting issues and identify key issues.
• Evidence of post-graduate qualification and continuing professional development.

Knowledge of ERP and CRM systems, in particular Salesforce and SAP Business 1, Pardot, etc.

Commitment to quality, promoting high standards.

Looking for collective success.

Personal Attributes:

• Highly organized 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-oriented self-starter.

• Able to work autonomously.

• Excellent communications skills across all levels.

• Organized, 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. 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.