Senior Analyst and BI Architect

AYMES Senior Analyst

Position: Senior Analyst

Location: Fully Remote

Reports to: Finance Director/ Head of Communications and Market Engagement (TBC)

Department: Business Intelligence

Type: Full-Time/ Permanent

About the Company:

AYMES International Limited is a leading company specialising in oral nutrition solutions dedicated to improving the lives of individuals with specialised nutritional needs. Our mission is to create innovative, high-quality medical nutrition products that support patient health and wellness. With a strong commitment to research, development, and customer care, we strive to provide the best nutritional solutions in the healthcare industry.

We are seeking a Senior Analyst to drive the strategy, reporting and source of truth across our data sets to create comprehensive and accurate Business Intelligence.

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.

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. 
• 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.   
• 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.
• 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.
• Contribute to short, medium- and long-term business plans, achieving quality outcomes.
• 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.

Qualifications

• Degree/ Diploma (such as Mathematics, Economics, Statistics, Operational Research, or a related quantitative or analytical discipline) or equivalent experience in a similar role

Key Skills

• 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 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  
• 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 modelling, data visualisation (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 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
• Solutions orientated
• Friendly, approachable, collaborative

How to Apply:

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.