Data Analyst - Power BI Developer

Job description

Data Analyst - Power BI Developer, London, 12 months FTC

The Data Analyst will manage Pay.UK's management information (MI), both operational and analytical, and associated data analysis processes and procedures, including the production of regular and ad-hoc MI reports and MI dashboard updates on a timely basis. Here's a quick overview..

  • Provide quantitative analysis in support of Pay.UK strategy and development initiatives.
  • Manage the development of strategic insight and research to support the payment ecosystem end to end and manage the distribution of published material, leveraging commercial opportunities as appropriate.
  • Maintain understanding of the end-to-end payments landscape combining insights and data internally across Pay.UK, stakeholder engagement and horizon scanning of the industry leveraging from internal and external market analytics capabilities.
  • Facilitate the transparency of the ecosystem to the supplier market.
  • Apply data strategy including maintaining associated Data Policies that enable Pay.UK strategy and ecosystem needs (GDPR), and drive commercial opportunities that may arise from data exploitation.

Key Accountabilities


  • Manages regular data collection from participants, vendors, third parties at agreed frequency
  • Regular engagement with key internal and external stakeholders on BAU activities
  • Manages, and is responsible for, the production of regular management information (MI) reports and publications, (e.g. daily, weekly, monthly, annually) together with detailed analyses and presentations (where relevant) and as required by internal and external Pay.UK stakeholders. Reports include, but are not limited to, data relating to performance, operations, assurance, fraud, regulatory, clearing, risk, settlement, suppliers, service, security, and
  • Provides knowledge and insight of current and future business performance and trends for the Schemes by producing volume forecasting reports to facilitate effective business planning and capacity management
  • Contributes to continuous efficiency and effectiveness improvements through enablement of fact-based decision making. Explores, validates and manages information management sources, using independent resources, where
  • Supports the business areas with the development of required MI dashboards and frameworks ensuring they are fit for purpose, providing expertise to foster the best
  • Establishes, develops and introduces self-service reporting and analytical tools adopted across the


  • Data preparation. Cleaning, validating transforming the data to ensure accuracy, completeness, uniformity and suitability for analysis
  • Designing and building reporting and analytics dashboards on BI Tools that track key metrics and provide actionable insights e.g. Power BI, R Studio
  • Produces ad-hoc reports and publications, together with detailed analyses and presentations (where relevant), as required for a wide range of Pay.UK stakeholders, liaising with them, or their representatives, as appropriate, in terms of content and timely
  • Completes the gathering, analysis, evaluation and manipulation of payment, supplier and Participant performance data, to produce informative reports and publications, based on historical activity, trends and changes, for a wide range of Pay.UK stakeholders including the Board, Schemes and
  • Proactively seeks trends in fraud MI, where appropriate, and ensures these are effectively communicated to the relevant
  • Provides Payments ecosystem insight to support strategic decision making.
  • Provides quantitative analysis to support Pay.UK strategy along with evaluation of proposals and projects, liaising with Pay.UK Directorates and stakeholders regarding the content and timing of the
  • Contributes to the data strategy including developing and maintaining of Data Policies that enable Pay.UK strategy and ecosystem needs (GDPR).
  • Develops and uses available IT tools to extract and present data as required, and is actively involved in the development of systems, tools and techniques to improve reporting and analysis.
  • Where required, undertakes data loads and data and user administration, along with responsibility for the administration of the systems and databases; ensures timely updates to reference data, as relevant, and contacts information across the various data repositories.
  • Ensures sourcing and integration of external data to ensuring data integrity.
  • Implements the data visualisation standards and ensures data policies, processes, governance and tools are updated to agreed standards, to deliver data requirements.
  • Contributes to the establishment of the framework, processes and systems required to provide a central view of data that allows Pay.UK to run and improve the business with the strategy and governance that goes with this. This includes the development of a granular understanding of transaction and performance data for Pay.UK provided services.
  • Contributes to the establishment of the capability to undertake neural network / pattern analysis to proactively identify issues or trends.
  • Supports, facilitates and presents at Pay.UK business and stakeholder meetings, as required.
  • Supports and advises colleagues on the use of data to ensure that statistics are not taken out of context, or misunderstood in terms of their nature and composition.

Other obligations:

  • Ensure compliance with all Pay.UK policies and procedures and complete required compliance training in a timely manner.
  • Comply with Pay.UK’s Data Protection Policy and all associated procedures and processes and communicate any data protection risks to the Data Protection team without delay.
  • Promote diversity and inclusion across Pay.UK to build a workforce that reflects the users we serve and provides equal opportunity for all colleagues.
  • Good knowledge and experience working with visualisation tools. e.g. Power BI, Tableau, etc
  • Good knowledge and experience working with databases, including modelling and architecture e.g. SQL Server, Oracle.
  • Good understanding DAX creating measures and time intelligence
  • Good understanding of the Financial Services / Retail Payments market
  • Proven track record and/or project experience of data analysis, modelling and management
  • Strong experience with data manipulation using analysis, modelling and reporting
  • Experience with Cloud environments beneficial.
  • Professional qualification preferred but not compulsory
  • Recognised capability in establishing, developing and implementing data management and data analytics practice area or function operating as a centre of expertise
  • Excellent stakeholder management skills coupled with the ability to quickly understand stakeholder needs and define and ensure the implementation of corresponding actions
  • Solution oriented with bias for action and a pragmatic attitude

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.