Senior BI Developer

As 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. 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 doing:

• Working closely with internal stakeholders to define and deliver the data products and reports which meet their needs.
• Collaborating 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 requirements.
• Developing and maintaining a suite of engaging Power BI dashboards including enterprise level semantic models along with user and data permissions management.
• Owning and continuously improving the data models including data and KPI definitions ensuring consistency of use.
• Supporting analysts and researchers in the team with data-driven initiatives, ensuring they have the data at hand to complete projects.
• Developing, 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 adopted.
• Supporting 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 for:

• Proven mid to senior level experience in data engineering, data architecture design and delivery, and BI within a data-intensive environment.
• Working with data from multiple systems and structures and at different velocities including near real time.
• Strong knowledge of data architecture (Snowflake is preferred), SQL development, security, and process optimisation.
• Advanced SQL development including query development and optimisation, stored procedures, and performance tuning.
• Expert knowledge of end-to-end enterprise BI using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisation.
• Advanced data modelling including dimensional modelling, star schema design, database layers, and data mart development.
• Knowledge of BI solution delivery methodologies including requirements and discovery, Agile delivery, testing, deployment, and post-production support.
• Strong understanding of data governance and security frameworks including data quality, metadata management, lineage, user and permission management, compliance, and access controls.
• Excellent documentation skills with the ability to create and maintain solution designs, data dictionaries, business glossaries and technical standards.
• Strong stakeholder management, communication and business partnering skills with the ability to translate business requirements into data solutions.
• Experience of marketing orchestration platforms (e.g. Bloomreach) or reverse ETL tools (e.g. HighTouch) is desirable.
• Knowledge of marketing and digital data (e.g. Google Analytics, BigQuery) would be advantageous.
• Change management using JIRA and Confluence would be an advantage.
• Experience using and implementing AI agents for code creation and process efficiency would be advantageous.

About AJ Bell:

AJ 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 offer:

• 25 days holiday, increasing with service + buy/sell scheme + bank holidays.
• 6% Pension with matched contributions.
• Discretionary bonus scheme.
• Share schemes (including free shares and BAYE).
• Health Cash Plan and discounted private healthcare.
• Free onsite gym.
• Enhanced family leave (subject to qualifying criteria).
• Travel and bike loan schemes.
• Employee Assistance Programme.

Life at AJ Bell:

• Regular social events including summer and Christmas parties.
• Learning and development opportunities tailored to you.
• Casual dress code.
• Friendly, supportive team environment.

Our ways of working:

We 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 & diversity:

We’re committed to creating an inclusive environment where everyone feels respected and able to be themselves at work. We welcome applications from all backgrounds and make hiring decisions based on skills, experience, and potential.