Job Descriptionhackajob is collaborating with AJ Bell to connect them with exceptional professionals for this role.Apply below after reading through all the details and supporting information regarding this job opportunity.Job DescriptionAs part of our continued growth and investment in our data and analytics capabilities, we’re recruiting for an experienced Senior BI Developer to join our dynamic direct-to-consumer (D2C) business. This is a key opportunity to play a central role in shaping how data is leveraged to drive insight, inform decisions, and support ongoing business success.As the Senior BI Developer, you will play a pivotal role in designing, building, and maintaining the data assets that underpin our reporting, analytics, and customer marketing capabilities. You’ll work closely with stakeholders to define requirements, develop best-in-class data products, and produce engaging and accurate reporting used by our teams and senior managers to track performance and make strategic decisions.You’ll also form a key part of our wider data community, ensuring that our organisational data supports our ambitious growth targets. And most importantly you will contribute to our company data strategy by supporting colleagues to become even more data literate and ensuring they have reliable and relevant data and reporting at their fingertips.What you’ll be doingWorking closely with internal stakeholders to define and deliver the data products and reports which meet their needsCollaborating with data engineers and integration specialists within the team and across the wider business to deliver data pipelines, ETL processes and data models that meet requirementsDeveloping and maintaining a suite of engaging Power BI dashboards including enterprise level semantic models along with user and data permissions managementOwning and continuously improving the data models including data and KPI definitions ensuring consistency of useSupporting analysts and researchers in the team with data-driven initiatives, ensuring they have the data at hand to complete projectsDeveloping, maintaining, and adhering to robust data and delivery processes including testing, monitoring, documentation, and issue resolution.Contributing to the overall data literacy of the business by ensuring data and dashboards are understood and adoptedSupporting our wider company data strategy by contributing and adhering to our data development frameworks, and engaging with Data Governance to resolve quality and integrity issues What we’re looking forWe’re looking for someone with a broad range of competence, knowledge and skills which would help you succeed in this role, but it is not critical to meet every single criteria listed below. We encourage a wide range of applicants.Proven mid to senior level experience in data engineering, data architecture design and delivery, and BI within a data-intensive environmentWorking with data from multiple systems and structures and at different velocities including near real timeStrong knowledge of data architecture (Snowflake is preferred), SQL development, security, and process optimisationAdvanced SQL development including query development and optimisation, stored procedures, and performance tuningExpert knowledge of end-to-end enterprise BI using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisationAdvanced data modelling including dimensional modelling, star schema design, database layers, and data mart developmentKnowledge of BI solution delivery methodologies including requirements and discovery, Agile delivery, testing, deployment, and post-production supportStrong understanding of data governance and security frameworks including data quality, metadata management, lineage, user and permission management, compliance, and access controlsExcellent documentation skills with the ability to create and maintain solution designs, data dictionaries, business glossaries and technical standardsStrong stakeholder management, communication and business partnering skills with the ability to translate business requirements into data solutionsExperience of marketing orchestration platforms (e.g. Bloomreach) or reverse ETL tools (e.g. HighTouch) is desirableKnowledge of marketing and digital data (e.g. Google Analytics, BiqQuery) would be advantageousChange management using JIRA and Confluence would be an advantageExperience using and implementing AI agents for code creation and process efficiency would be advantageous About AJ BellAJ Bell is one of the UK’s fastest-growing investment platform businesses, providing award-winning solutions for everyone, from professional financial advisers to first-time investors.Today, over 723,000 customers trust us to manage more than £108.7 billion of assets. By continually striving to make investing simpler and more accessible, we’re helping more people take control of their financial futures.We’re proud to be recognised as one of the UK’s Best 100 Companies to Work For for six consecutive years, and a Great Place to Work in 2025 and 2026 a reflection of our supportive and collaborative culture.What we offer25 days holiday, increasing with service + buy/sell scheme + bank holidays6% Pension with matched contributionsDiscretionary bonus schemeShare schemes (including free shares and BAYE)Health Cash Plan and discounted private healthcareFree onsite gymEnhanced family leave (subject to qualifying criteria)Travel and bike loan schemesEmployee Assistance Programme Life at AJ BellRegular social events including summer and Christmas partiesLearning and development opportunities tailored to youCasual dress codeFriendly, supportive team environment Our ways of workingWe offer hybrid working, with a minimum of 50% of your working time per month spent in the office.For new starters, there’s an initial period of full-time office working to help you settle in and build relationships.Inclusion & diversityWe’re committed to creating an inclusive environment where everyone feels respected and able to be themselves at work. xohmjlaWe welcome applications from all backgrounds and make hiring decisions based on skills, experience, and potential….
