Senior Data Analytics Solution Expert

- Technology Resilience and Regulatory Management

Location Address: Toronto- hybrid – onsite once in 2 week

Contract Duration: 10 months

Possibility of extension: Yes

Business group: GBT Risk & Resiliency

You will be part of the Resilience Analytics team that is part of Technology Internal Controls and Regulatory Management (ICRM) for Global Technology & Enterprise Platforms (GTEP) at Scotiabank. GTEP ICRM team plays an important role in the Bank’s Risk Governance Framework, providing First Line of Defense for GTEP and the Bank for all technology risk domains, including Cyber Security, Data Privacy, Software Currency, Disaster and Backup Recovery, Third Party Management, and Audit and Regulatory issue remediation.

Typical Day in Role:

• Reporting to the Director, Resilience Data Analytics, the Data Analytics Solution Expert (DASE) will be a senior contributor to the overall success of the Technology Internal Controls and Regulatory Management for GTEP by ensuring goals, plans, and initiatives are executed and delivered in support of the team’s business strategies and objectives. The DASE conducts all activities in compliance with governing regulations, internal policies and procedures.
• Your goal is to tell our resilience and reliability story around backups taken for our applications.
• You will interface with multiple technology teams (back-up tool owners, application owners) to find data sources.
• You will work to normalize the data regardless of source to identify and measure key metrics. You will design and create ETL that can absorb large amounts of data to create the story.
• You will design and automate the discovery, ingestion, and normalization of data into SQL databases and then work to present them to tell the story in Power BI.
• When there are breaks or other priorities that might arise, you will drive a data driven focus on technology resiliency across the enterprise.
• A key contributor to a to designing metrics, finding data points, working with engineering teams on solutions, and designing resulting dashboards. On a day-to-day basis, you may be asked to review existing solutions to provide insights into potential areas of risk, to streamline the data gathering process,, or to help find new data sources

Must Have Skills:

• You have 10+ years in as a technical engineer/architect resource in a data analytics environment.

• You have at least 7+ years of expertise in ETL & pipeline construction, ensuring efficient data flow and integration from various sources, and maintaining high standards of data quality, timeliness, completeness, and consistency.

• You have at least 7+ years of experience designing Data Warehouse experience and Data Modeling solutions ensuring data quality.

•You have 5+ years’ experience with solution architecture and enterprise architecture. That includes implementing data models and has knowledge on backup requirements for applications.

• You have 5+ years of working experience and demonstrated ability using most of the tools we use: Python, SQL, Power BI. Your experience includes leveraging Python for data manipulation, analysis, and automation, and Power BI for building comprehensive data models and visualizations that drive business insights.

• You have 2+ years’ experience working with back-ups and restores to backup solutions including some of the following: NetBackup, Tivoli, Veritas, Cohesity, HP Solutions.

Best VS. Average Candidate:

The ideal candidate can understand complex data problems to create an architecture that would solve the problem. This would include architecture, onboarding of data pipelines, creating effective ETL visualizations of solutions, and the ability to manage a small team so the objectives can be achieved within a specific timeline. Has experience with IT operations experience especially backups, solutioning experience in Data analysis / Data engineering in a recent position. Also has great communications skills and Python, Power BI & ETL expertise.

Candidate Review & Interview Selection:

1st round – 30mins technical & 30mins soft skills – Panel of 4 – In-person is must

2nd round – with VP & Sr technical resource – 30mins on MS teams.