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. You'll 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.


• 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
  
  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' for six consecutive years.


• Generous holiday allowance increasing up to 31 days 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.