Data Analyst X 2

Position Title: Data Analyst
Location: Toronto, ON
Duration: 2 months

Story Behind the Need:
The Data Analyst, Data Remediation Audit Program contributes to the overall success of the Group Treasury Data Office in Canada ensuring specific individual goals, plans and initiatives are executed/delivered in support of the team’s business strategies and objectives.
Reason: Bringing in for the Data Remediation Audit Program (DRAP) for the Group Treasury Data Office compliance.
The main function of the Data Analyst role is to support the investigation, development, testing and operationalization of data solutions related to the strategic goals of the Group Treasury Data Office. This role ensures all activities are conducted in compliance with enterprise data standards, policies and procedures. This project entails a three-year road map from 2024 to 2026, an extension opportunity is available for the candidates.
Candidate Value Proposition:
The successful candidate will have the opportunity to work within client. We are data partners that support technology and business around the world. You will get to work with and learn from diverse industry leaders, who have hailed from top technology.
Typical Day in Role:

• Support the Senior Manager on strategic data and innovation initiatives, presentations, and analysis with executive-level visibility for the Treasury Management team.
• Experience working in data management and can provide hands-on support on the implementation according to Data Office playbooks, guidelines, standards, and policies (e.g., documenting initiatives, use cases, data tiering and classification, critical data elements, and business data elements).
• Performs necessary data mapping and lineage activities and documents information flows to support specific business requirements.
• Performs data quality rule creation, and analyzes and communicates results supporting data quality processes.
• Builds the metadata model and business glossary by gathering information from multiple sources: business users, existing data sources, databases and other relevant documents and systems.
• Participates in knowledge transfer within the team, and business units and provides recommendation opportunities to enhance productivity, effectiveness and operational efficiency of the business unit and/or team.
• Monitors project progress by tracking activity, resolving problems, publishing progress reports and recommending actions.
• Work in an Agile mindset to accelerate the delivery of the project.
• Prepares technical reports by collecting, analyzing, and summarizing information and trends.
• Assesses, researches, analyzes, and documents project needs and outcomes by selecting the appropriate information gathering and/or modeling technique to elicit requirements.
• Champions a data-driven & customer-focused culture to deepen client relationships and foster broader Bank relationships and DO knowledge.

Candidate Requirements/Must-Have Skills:

• 10+ years of working experience as a Data Analyst with a strong understanding of data concepts (metadata, data mapping, data quality, data modeling, data governance).
• Hands-on experience working within Data Management and Operations, including proficiency in Data Management Tools (Collibra and IGC preferred) and understanding of data flows within a large enterprise.
• Working knowledge of Data Management framework and can trace data elements at origination and as they move between systems including any transformations.
• Working knowledge of data models, data relationships, mapping lineage and business rules using IGC (Information Governance Console) and universal catalogue.
• Hands-on experience with developing dashboards in PowerBI and Tableau.

Nice-To-Have Skills:
Strong business acumen, data analysis, metadata documentation, and data quality controls skills specifically with respect to analyzing business process controls, sourcing, and provisioning of lineage, identifying data quality issues and proposing remediation steps.• Understanding of Bank’s systems i.e. ALM6, IGC, GC.

• Demonstrated ability to provide evidence to 2nd and 3rd line.
• Understanding or experience with Treasury.
• Cloud platforms and related data services knowledge (e.g., Google Cloud Platform, Microsoft Azure, Amazon Web Services).

Soft Skills:

• Strong communication (verbal/written) skills and ability to distill information for executives.
• Strong organizational skills to effectively manage multiple tasks within varying timelines.
• Ability to work as part of a team, as well as work independently or with minimal direction.
• Strong decision making, forward thinking and creative problem-solving skills to anticipate and respond quickly to technological/market influences.

Best vs. Average Candidate:

• An average candidate will only have experience with data governance, whereas the ideal candidate will have expertise in both data governance and data analytics.
• Extensive experience with Power BI and Tableau.
• Detail-oriented and ability to work independently.

Education:

• Strong technical education background, majoring in fields that require a high degree of analytical skills, such as Engineering, Computer Science, Physics, Math, Statistics, Accounting or related field.

Candidate Review & Selection
One round MS Teams video interview – Hiring manager and Team member (1 hour)
70% technical (data governance and analytic capabilities) and 30% soft skills
Possibility of second-round interview