At Just we encourage a flexible and agile working environment for the majority of our opportunities. Get in touch with us to discuss in more detail. Senior Data Analyst Full Time London - Hybrid Who are Just? We’re a FTSE 250 Financial Services company who specialise in retirement solutions and right now, our world is moving pretty quickly. With the defined benefit buy in / buy out space growing each year, Just continues to annually grow its business by over £4bn of assets. We are a purpose driven company with compelling and credible goals. Quite simply, we help people achieve a better later life. We achieve this by providing competitive and innovative products, services, financial advice and guidance to help our customers achieve security, certainty and provide them with peace of mind in retirement. That’s who we are. We’re a company on a mission: to become a beacon for the entire retirement industry. Because we believe everyone deserves a fair, secure, and fulfilling retirement. Purpose The Senior Data Analyst collaborates with business users to create reports, dashboards, and data products that drive decision-making, support regulatory and partner reporting, and enhance internal operations. They develop and maintain data/business intelligence solutions, leveraging deep knowledge of source systems and business processes to ensure high-quality outputs. This role also promotes data culture by advocating for advanced analytics, innovation, and best practices, while working with senior leadership to set standards across the organization. Additionally, the Senior Data Analyst mentors junior team members and supports the growth of the broader analytics community at Just. Job Role Accountabilities Technical Subject Matter Experience – To take a technical leadership role on projects with regards to the data analytics subject area relating to data product design, data modelling, SQL Server Solutions, Purview and other technologies Requirements Gathering – To work with business stakeholders to gather requirements which can be used for the purposes of data modelling and data product design and development. Develop Bespoke Solutions - To develop high-quality bespoke data solutions using appropriate, industry-standard tools, technologies and languages aligned to the organizational target architecture and data strategy. Technical Documentation - To ensure that high-quality documentation is developed, maintained, regularly reviewed and stored for all solutions developed and all operational processes. Metadata Management – To work to collect metadata which can be added to relevant systems and solutions to improve usability. Continuous improvement – Innovates by driving continuous improvement relating technical solutions, making appropriate use of new technology and recommending process improvements that will let the team to meet and exceed expectations. Quality Assurance - To perform peer reviews of solutions and documentation in order to ensure that procedures and standards are followed consistently. Continuously work towards the objective of building in quality and provide appropriately tested solutions. Operational Process Support - Support, execute and administrate weekly and monthly processes within the bespoke Financial Data Warehousing solutions. Service Desk Requests - To act as second and third-line support in undertaking tasks assigned via Service Desk. Stakeholder Engagement and Support – To engagement with stakeholders through various channels (e.g. surgeries, communities of practice) with a view data platform adoption and improve data maturity within the organisation. Cross Platform Knowledge - To be able to support, develop and maintain the Azure Data Platform and the legacy SQL Server Data Platform (SQL Server platform is a stretch) Mentoring – To be able to mentor and lead less experienced team members. Examples of Key Activities Business/process analysis based with support of business analysts. Leading on creation of requirements documentation based on business analysis which will be used to enable data modelling, data mapping to source and data product design Creation of data product wireframes as part of requirements gathering process. Data Modelling: of gold presentation layer (i.e. star/snowflake schema); of silver layer (i.e. data vault) Data profiling and exploration of source data Data mapping and data transformation specifications from source systems through the medallion architecture to presentation layer (bronze, silver, gold). Definition of semantic models that enable report development and self-service reporting Creation of measures and calculations within semantic models base don KPI definitions Gathering metadata from the business to add to both purview and Power BI. Participation in warehouse/data mart design collaborating with other team members. Creating high quality data products which enable end users to consume insight easily. Developing, testing and maintaining Power BI Reports, Paginated Reports and dashboards, PBRS/SSRS reports and Power BI Dashboards. Development of SSAS cubes as required. Promoting the adoption of advanced analytics, best practices, and innovative data tools among end users. Creating and maintaining the wiki and documentation for all development and analysis activities Supporting BAU operations as required on a rota basis which includes morning checks, managing the service desk queue and supporting out of hours testing as required. Monitoring performance and usage of BI products and resolving any performance issues or outages in a timely manner. Providing support to business users through the Analytics Community or Practice framework including regular surgeries Carrying out ad hoc SQL queries for analysis and investigation Expanding the use of purview within Just. Engagement as Data SME on projects to provide expertise on data requirements and BI development timelines Supporting the business by flagging data quality issues and passing them to the Data Governance team for investigation and remediation. Attend team and project meetings and all SCRUM ceremonies (stand ups, retros, refinements, PIP Planning, etc) Presenting to stakeholders as required Continuous Improvements of the data platforms at Just. Mentoring less experienced members of the development team. Collaborating with the wider data department on innovative experiments. Releasing developments and code into production environments. Supporting and working on data engineering tasks relating to data onboarding as required to delivery projects (e.g. mapping specification updates, pipeline releases, etc), please note low level refactoring of pipelines is not expected. Support and maintenance of Azure data solutions as required. Ensures that defined standards, processes and best practice are adhered to. Skills, Knowledge and Experience The successful candidate will be able to present: Demonstrable skills in the Azure Data Platform namely Fabric, Power BI, Data Bricks, ADLS Gen 2 Storage, SQL Server, Azure ML, Azure Data Factory. Demonstrable experience with Microsoft, Azure and cloud applications and platforms Demonstrable skills in Data warehousing, data lakes and big data solutions. Expert knowledge in the Power BI platform relating to support, administration and security Skills relating to business analysis and requirements elicitation and documentation An aptitude for data development and the ability to understand and manage complex concepts A willingness to learn new skills and adopt to new technologies Excellent data visualisation and presentation skills using commercial and/or open source software Creating credible KPIs and performance metrics Creating robust measures from operational data Operational familiarity in the use of meta-Data Management, data quality, and data stewardship tools and platforms Can quickly understand business problems and requirements and derive workable actions Strong communication and relationship building skills Ability to constructively challenge requirements and current state to increase overall value to the organisation Flexibility to adjust to multiple demands, shifting priorities, ambiguity and rapid change Financial Services background is desirable Experience of supporting end users in the adoption and effective use of Data, Data Platforms and Data Products Experience with IT development processes and delivery lifecycles; development methodology; release strategy and configuration management; development tools, and applications across full project lifecycles. Experience working within an Agile environment; delivering within defined Sprints; familiarity with Agile principles ceremonies. Experience in mentoring other team members to improve individual and team capability Experience in the use of data catalogues and data quality technologies. Qualifications: Bachelor/Master’s degree in Computer Science, Business Administration, Information Management or equivalent experience in a Data Management/Business Intelligence profession Azure Foundation Certs (AZ-900, DP-900) Azure Data Analyst Certs (PL-300) Company Benefits A Competitive Salary, Pension Scheme and Life Assurance Along with 25 Days Annual Leave plus an Additional Day on us for your Birthday Private Medical Cover and Income Protection, just in case A generous and highly achievable bonus scheme – paid annually based on individual and company performance against targets Opportunity to progress within your career both in-role and within the company FREE access to the Headspace App, a 24/7 Employee Assistance Helpline and Trained Physical & Mental Health First Aiders (On-Site) A variety of Employee Funded Benefits available to you via our Online Benefits Portal Plus, several additional purchase options available for you and your loved ones Why Just? We are committed to building a more sustainable business and have publicly committed to reduce our scope 3 emissions to Net Zero by 2050 and our scope 1 and 2 emissions to Net Zero by 2025. We’ve made good progress so far and encourage our people to make small and meaningful changes in their everyday lives, so that we can protect our planet for future generations. Diversity, Equity and inclusion (DE&I) is a key priority for Just as part of our overall strategy and ensuring all of our people feel proud to work at Just. We have joined a number of initiatives including the Race at Work Charter, designed to improve outcomes for employees from underrepresented backgrounds. We also run a Reciprocal Mentoring scheme for employees from a BAME background, those with a disability and those who identify as LGBTQ. There are multiple employee network groups, which champion issues including race, gender, social mobility and neurodiversity. What’s clear about working at Just is that we care. We care about our customers, our purpose, our environment, inclusivity, wellbeing and most importantly - each other. About Us We’re a FTSE 250 Financial Services company who specialise in retirement solutions and right now, our world is moving pretty quickly. How people work, save, and plan for the future is all changing. A new generation of retirees needs a new kind of retirement company. A company who will look for new ways of doing things – and will always put the customer first. That’s who we are. We’re a company on a mission: to become a beacon for the entire retirement industry. Because we believe everyone deserves a fair, secure, and fulfilling retirement. And with you on our team, we’re going to make sure they get it. We’ve built our sustainability strategy around the United Nations Sustainable Development Goals (SDG) and have selected goals where we believe we can make the most difference. By aligning our activity with these global goals, we can make sure we play our part in addressing the wider issues facing the planet and leave a positive legacy to the world. You can read more about our sustainability strategy here. Diversity, equity and inclusion are priorities for us. Having a diverse, talented workforce with colleagues of different backgrounds, world views and experiences is the right thing to do. It’s also the most effective way to succeed, innovate and better serve our customers now and in the future. We are committed to our targets on gender and ethnicity and run a number of successful mentoring and sponsorship programmes for our colleagues from diverse backgrounds. We have multiple active employee network groups which champion issues including gender, ethnicity, sexual orientation, disability and neurodiversity. You can read more about our DE&I strategy and commitments here. What’s clear about working at Just is that we care. We care about our customers, our purpose, our environment, inclusivity, wellbeing and most importantly - each other. We look forward to welcoming you to the team soon.