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. 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 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 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 SAPBusiness1, 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. 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. ADZN1_UKTJ