At a Glance
- Tasks: Design and maintain data assets for reporting and analytics in a dynamic D2C environment.
- Company: Join AJ Bell, one of the UK's fastest-growing investment platforms.
- Benefits: Enjoy 25 days holiday, a generous pension scheme, and health benefits.
- Other info: Hybrid working with a casual dress code and tailored development opportunities.
- Why this job: Shape data strategies and drive insights that impact business success.
- Qualifications: Experience in data engineering, BI, and advanced SQL skills required.
The predicted salary is between 55000 - 65000 £ per year.
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.
- 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.
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:
- 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.
- Knowledge of marketing and digital data.
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.
Benefits include:
- 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.
- Regular social events including summer and Christmas parties.
- Learning and development opportunities tailored to you.
- Casual dress code.
- 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.
StudySmarter Expert Advice🤫
We think this is how you could land Data Developer / BI Developer in Manchester
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Aj Bell!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Developer / BI Developer at Aj Bell.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Aj Bell.
✨Apply Directly through Our Website
When you find a suitable opening like Data Developer / BI Developer at Aj Bell, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Developer / BI Developer in Manchester
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Aj Bell, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Aj Bell. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Aj Bell
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Aj Bell!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
