Senior Analyst and BI Architect

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 HR@aymes.com 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