Senior BI Developer

Job Description

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. 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 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

We'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 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, BiqQuery) 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.