Data Manager

Robert Walters; City Of London; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

An innovative firm is seeking a Data Analytics Manager to lead data integration and visualization efforts. This pivotal role involves migrating data from diverse sources into a structured SQL database and developing intuitive dashboards using Tableau and Power BI. You'll champion data-driven decision-making across the organization, providing actionable insights and fostering a culture of data literacy. If you have a passion for transforming data into strategic advantages and possess strong communication skills, this is an exciting opportunity to make a significant impact in a dynamic environment. Join a team that values your expertise and creativity in driving business growth through data.

Qualifications

• 5+ years in data analytics, especially in payments.
• Proficient in SQL, Tableau, and Power BI for data visualization.

Responsibilities

• Migrate data from various sources into SQL and build dashboards.
• Promote data-driven decision-making and enhance data literacy.

Skills

Data Analytics

SQL Database Management

Data Integration

Tableau

Power BI

Excel

Data Visualization

Data Governance

Communication Skills

Training and Upskilling

Education

Bachelor's Degree in Data Science or related field

Tools

Tableau

Power BI

SQL

Excel

SSIS/SSRS

Python

Job description

Data Manager (14603) City of London, England

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:

1. 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.
2. Assess ideal target tooling for dashboarding between Power BI and Tableau.
3. Migrate data from multiple sources including Excel files into a structured SQL database.
4. Design, develop, and implement a user-friendly Tableau/Power BI dashboard that integrates all data sources.
5. 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.
6. 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.
7. Provide documentation and user guides for the dashboard and data migration processes.
8. Champion the value of data-driven decision-making across the bank by promoting Merchant Services data products and their benefits.
9. Collaborate with Product, Marketing, Sales, Business leaders, Platform and cross-functional partners to understand their data needs and provide relevant insights.
10. Extract meaningful insights from MS data analytics and present them in a clear and actionable manner to stakeholders.
11. Lead efforts to enhance data literacy among colleagues, offering training and support to enable effective data usage.
12. Develop a deep understanding of MS data products, their methodologies, and applications, ensuring accurate communication.
13. Advocate for and ensure adherence to data governance standards and policies while sharing data insights.
14. Contribute to the enhancement of data products by gathering feedback and insights from stakeholders.
15. Upskill and task manage more junior members of the wider data hub team.
16. Collaborate with MS teams and stakeholders to identify data-driven opportunities and challenges.
17. Promote MS data products, showcasing their benefits and applicability to different business contexts.
18. Translate complex MS data insights into actionable recommendations for strategic decision-making.
19. Develop and deliver engaging presentations and reports that convey data-driven insights to non-technical stakeholders.
20. Provide training sessions and workshops to enhance colleagues' data literacy and analytical skills.
21. Collaborate with data analysts and scientists to ensure data products meet stakeholder needs.
22. Foster a culture of data-driven decision-making and curiosity across the business.
23. Stay informed about industry trends and advancements in MS Data Analytics.

Experience:

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