Senior BI Developer

We're now recruiting a Senior BI Developer to work in the D2C business area of AJ Bell. The Data and Insights team is a small but dynamic and experienced group of SMEs who work across Google Analytics, Bloomreach CDP and BI/data engineering. The team is the first port of call for insights from our customer-centric marketing, product, PR, content and strategy teams, as well as working on projects and initiatives to allow the business to harness the power of our data.
The purpose of this role is to develop Business Intelligence solutions to be used to report on and drive business decisions by product and marketing teams, as well as the Senior Management Team. Youll be responsible for owning and developing our data model for the Direct-to-consumer business as well as creating custom solutions and fulfilling data analysis requests for key stakeholders at every level.
What does the job involve?
The key responsibilities of the role are as follows:
Working closely with engineering and streaming teams across Tech Services and Operations to ensure reliable and accurate data is available for D2C data and insights team to develop solutions from.
Be subject matter expert in D2C team for cloud-based data solutions (including Snowflake and AWS Aurora).
Work with Data Ingestion Specialist and Enterprise Architecture teams to develop implement robust data pipelines and ETL processes to streamline data ingestion and transformation.
Support Manager and HoD with delivery of D2C data roadmap and embedding a data-driven mindset in the D2C business.
Support Data Analysts to deliver ad-hoc analysis requests from business stakeholders by QAing work, helping refine requirements and helping design solutions. This may include data extraction from multiple sources.
Identifying and refining data and reporting requirements from key stakeholders
Owning and continuously improving the data model
Visualising and reporting data findings creatively in a variety of formats including data visualisation in Power BI
Performing data studies and data discovery around new data sources or new uses for existing data sources.
Engage with data governance and other data teams on data integrity issues between sources and various data layers/services.
Participate and advocate best practices with Data Community Practice group.
Agile DataOps support for D2C initiatives and regulatory requests.
To identify, capture and introduce controls for any existing or emerging risks. Ensure compliance with regulatory requirements and industry standards related to data privacy, security, and confidentiality.
To foster and maintain excellent relationships with stakeholders especially in Marketing and Product.
Potential line management responsibilities of junior/mid Data Analysts.
Supporting and enabling the business to achieve its regulatory requirements, including consumer duty.
A broad range of competence, knowledge and skills 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.
Competence
Proven mid to senior level experience in analysis and development within a BI environment
Able to identify and implement change and foster culture of continuous improvement
Good levels of data and market awareness
Database architecture (largely Cloud but some on-prem legacy)
Business Intelligence Reporting
Broad experience including data mapping, extraction and manipulation, cleansing, modelling, mining
Highly effective communication skills and comfortable working with both technical and non-technical teams
Good analytical and problem-solving skills
Able to prioritise work effectively
Flexible approach to work and adaptable to changing environment
Self-motivated
Embraces continuous learning
Knowledge
Good knowledge of AJ Bell and our product offerings, incl. AJ Bell platform and systems
Good knowledge of SSAS
Some knowledge of Customer Data Platforms (Bloomreach) would be an advantage
Some knowledge of Google analytics and mining web logs advantageous
Knowledge of Business Intelligence strategies
Skills
Proficiency in data analysis tools and programming languages such as SQL, Python, R, or SAS.
Experience with data visualization tools, particularly Power BI
Strong and demonstrable experience in T-SQL
Data integration tech stack experience with MS SSIS or Azure data factory or AWS Glue would be an advantage
MS Office including Word, Excel, Outlook and PowerPoint
JIRA and Confluence experience would be an advantage
About us:
AJ Bell is one of the fastest-growing investment platform businesses in the UK offering an award-winning range of solutions that caters for everyone, from professional financial advisers, to DIY investors with little to no experience. We have over 503,000 customers using our award-winning platform propositions to manage assets totalling more than £80.3 billion. Our customers trust us with their investments, and by continuously striving to make investing easier, we aim to help even more people take control of their financial futures.
Having listed on the Main Market of the London Stock Exchange in December 2018, AJ Bell is now a FTSE 250 company.
Headquartered in Manchester with offices in central London and Bristol, we now have over 1300 employees and have been named one of the UK's 'Best 100 Companies to Work For forsix consecutive years.
What we offer:
Generous holiday allowance increasing up to 31days with service, plus bank holidays
Holiday buy/sell scheme
Hybrid working policy
Casual dress code
Discretionary bonus
Contributory pension scheme
Healthcare Cash Plan
Dedicated time for proof-of-concepts and assessing new tech
Support to attend conferences, events, and meet-ups
Buy as you earn share scheme
Free annual share scheme
Paid study support for qualifications
Enhanced maternity/paternity scheme from day one
Bike loan
Season ticket loan portal
Discounted PMI and Dental
Free gym
Paid volunteering opportunities, free social events and more
AJ Bell is committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and all employees are empowered to bring their whole self to work.
We do not discriminate on the basis of race, sex, gender identity, sexual orientation, age, pregnancy, religion, physical and mental disability, marital status and any other characteristics protected by the Equality Act 2010. All decisions to hire are based on qualifications, merit and business need.
ADZN1_UKTJ