The Home Of Flexible Working, Find Your Flex Logo

BI Solutions Specialist

You’ll bring the focus. We’ll provide the detail.

Tesco Bank is here to offer a new approach to banking, building on the foundations of service and dedication that have made Tesco a truly great British brand and a worldwide success. Bringing that level of success to a new industry and new area of operations demands expertise at the highest level – and offers the chance for dedicated  professionals to make a long-lasting impact within a business that’s breathing new life into personal finance and retail banking.

An exciting opportunity has arisen for a Business Intelligence Solution Design Specialist to support the delivery and evolution of the EDS Department through designing and delivering a world class BI environment, whilst applying the most up to date technical expertise to support a BI Centre of Excellence strategy. Will be empowered to challenge the status quo, dream big and make a massive impact in the business intelligence domain across Tesco Bank. Strive to deliver best-in-class BI solutions that simplifies and enhances daily jobs, placing the customer at the centre of everything we do. Be the subject matter expert and go to person for all BI related technical queries, standards (internal and industry wide) and best practices.

Key responsibilities

  • Taking a lead on the design & implementation of data models & reporting developments to underpin the Bank's BI aspirations.
  • Proactively work with the Data & Data Governance Heads of & key CIO stakeholders to define & agree modelling methodology for the Bank's BI estate.
  • Understand business needs in order to develop the best fit BI & reporting requirements based on the underlying technology & consuming tool sets ie: the technical specialist.
  • Working with the BI Solution Design team to aid in the delivery, reacting to any development problems or issues in a flexible and supportive way.
  • Fully document the data model & marts through collaboration with the Data Governance team, ensuring that technical/business definitions tie up with the design & canon.
  • Actively assisting with the wider Data & CIO Dep in developing and delivering the BI roadmap, providing a plan to model, design and deliver the reporting that the business needs for analysis and reporting which are accurate, perform well, of high quality and are well governed.
  • Schema Development - Working with the Data Team, identify potential new data sources and assist with the integration of new data sources into the Datamarts / Warehouse.
  • Identify and recommend data/table structures appropriate for the existing MSTR schema structure.
  • Identify and create the relationships between data elements including parent/child and hierarchies
  • Create the necessary MSTR schema objects including Attributes, Facts, Hierarchies, Filters, Prompts, and Metrics
  • Content Development - Creation of reporting solutions tailored to the needs of business users.
  • MSTR Web - Creation of Interactive Dashboards and Scorecards employing best design practices.
  • MSTR Mobile (iOS) - Development/maintenance of customized MSTR App for iPhone/iPad.
  • System Administration - Assist with the maintenance of the MSTR server infrastructure as needed. This includes software installation/configuration, upgrades, server tuning, and MSTR Mobile configuration
  • Custom Application Development - support the creation of customisations to both the Web and Mobile MSTR interfaces.
  • Recommend process improvements to ensure MSTR queries running as efficiently as possible.
  • Monitor BI/MSTR industry trends work with Management to prepare strategies to implement recommended design enhancements.
  • Assist with the review of technical specification documentation as well as guiding less experienced members of the team through the process.
  • Assist users with problems and resolves issues independently.
  • Creates test plans, test cases, test scripts and performs testing of the BI and related environments.
  • Assist with projects as may be required to contribute to efficiency and effectiveness of the work, be the subject matter expert.
  • Promote BI benefits to the organisation and usage of our tools to relevant business groups.
  • Guides the Data Engineering team in implementing architectural patterns and building scalable BI platform.
  • Trains and mentors the BI Solution Design & Data team to implement Gap development standards and best practices.
  • Acts as a lead in identification and troubleshooting system issues impacting timely availability of data to business partners within established SLAs.
  • Seeks improvement opportunities in design, solution implementation approaches in partnership with Architects and Data Engineering teams for ensuring the performance and health of BI applications.
  • Participates in production migrations and upgrades, develops processes for sustaining the BI data platform.

Required skills/ experience

  • Previous experience in mentoring & coaching others.
  • Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.
  • Strong written and oral communications skills.
  • Problem solving: reporting queries & analysis.
  • Stakeholder & Project Management.

BI technologies:

  • Advanced IT experience.
  • Considerable experience of business intelligence development, preferably MicroStrategy.
  • Experience in advanced query development and design using SQL / SAS.
  • Experience data extraction transformation and loading experience.
  • Strong Excel knowledge, Visual Basic would be beneficial.
  • Developing BI, Reporting, Scorecards and Dashboards solutions from business requirements.
  • BI technologies and architecture such as delivery mechanisms (i.e. portals, dashboards, OLAP), data model/architecture, data integration/ETL and reporting tools.
  • Change management & development life-cycle including Requirements, Design, Development, Testing and Support.