Data Analysis Manager
London/Hybrid
£500 per day
6 month contract

Cardnet is looking for a Data Analytics Manager, skilled in SQL Data Integration and Tableau/ Power BI Dashboarding to streamline and improve data collection and visualization processes. The consultant will be responsible for migrating and integrating data from approximately 50 different resources into an SQL database and building a comprehensive, user-friendly dashboard in Tableau / PBI. You will play a vital role in the Merchant Services Data & Analytics team acting as a bridge between Data analytics and stakeholders across the organisation. The role aims to facilitate effective data-driven decision-making by promoting data products, providing actionable insights, and upskilling colleagues in data literacy. This will ultimately contribute to optimised sales and supporting the 2.5x growth target for the business.

Accountabilities & Responsibilities
Understand the current finance feeds versus performance feeds (with differences) and reconcile large volumes of data so that the two align, articulate the challenges and write options, recommendations and proposal for solution rebuild.
Assess ideal target tooling for dashboarding between Power BI and Tableau
Migrate data from multiple sources including Excel files into a structured SQL database.
Design, develop, and implement a user-friendly Tableau/Power BI dashboard that integrates all data sources.
Conduct data analysis and establish dashboard views to track trends, charts and graph views to measure performance against finance actuals. Perform data validation and quality checks to ensure data accuracy and integrity
Ensure the dashboard can be quickly and easily updated with new data on a weekly basis. Improve the current format of the data pack to display all required data views comprehensively
Provide documentation and user guides for the dashboard and data migration processes
Data Advocacy: Champion the value of data-driven decision-making across the bank by promoting Merchant Services data products and their benefits.
Stakeholder Engagement: Collaborate with Product, Marketing, Sales, Business leaders, Platform and cross-functional partners to understand their data needs and provide relevant insights.
Data Insights: Extract meaningful insights from MS data analytics and present them in a clear and actionable manner to stakeholders.
Data Upskilling: Lead efforts to enhance data literacy among colleagues, offering training and support to enable effective data usage.
Product Knowledge: Develop a deep understanding of MS data products, their methodologies, and applications, ensuring accurate communication.
Data Governance: Advocate for and ensure adherence to data governance standards and policies while sharing data insights.
Continuous Improvement: Contribute to the enhancement of data products by gathering feedback and insights from stakeholders.
Upskill and task manage more junior members of the wider data hub team
Agile Working: experienced in working in agile methodology ways of working and sprint methodology
Collaborate with MS teams and stakeholders to identify data-driven opportunities and challenges.
Promote MS data products, showcasing their benefits and applicability to different business contexts.
Translate complex MS data insights into actionable recommendations for strategic decision-making.
Develop and deliver engaging presentations and reports that convey data-driven insights to non-technical stakeholders.
Provide training sessions and workshops to enhance colleagues' data literacy and analytical skills.
Collaborate with data analysts and scientists to ensure data products meet stakeholder needs.
Foster a culture of data-driven decision-making and curiosity across the business.
Stay informed about industry trends and advancements in MS Data Analytics.

Experience:
5+ years of experience in Data analytics (Merchant/Card Payments related is a plus).
Experience in consultancy in effectively communicating data insights to stakeholders, promoting data-driven decision-making, and upskilling colleagues in data literacy.
Proven experience in SQL database management and data integration.
Proficiency in Tableau/Power BI for dashboard development and data visualization.
Experience in Power BI/ Tableau data prep, data engine and data connectors
Strong knowledge of Excel, including excel formulae, macros and experience in handling large datasets.
Knowledge of database design principles, normalisation, indexing, and schema design.
Ability to create and maintain data models, including entity-relationship diagrams and logical/physical data models.
Strong understanding of SQL syntax and the ability to write complex but secure and performant queries, including joins and subqueries
Ability to design user-friendly interfaces and intuitive data views.
Strong commercial focus, emphasizing the measurement and delivery of results.
A strategic approach to meeting customer needs, the ability to think laterally, be innovative and creative.
Data Literacy: Strong understanding of data concepts and the ability to translate technical insights to non-technical stakeholders.
Stakeholder Engagement: Excellent interpersonal skills to effectively engage and collaborate with colleagues at all levels.
Data Presentation: Proficient in conveying complex data insights through presentations, reports, and visualisations.
Merchant Services Domain Knowledge: Comprehensive understanding of processes, policies, and regulations within the banking sector.
Communication: Clear and concise communication skills to convey data insights and recommendations.
Training and Facilitation: Ability to conduct engaging training sessions and workshops to improve data literacy.
Problem Solving: Creative problem-solving skills to address unique data-related challenges.
Using SQL, SSIS/SSRS, Python programming languages to extract information, provide MI to stakeholders and automating processes.