Senior Data Engineer with Python, SQL, VBA and PowerBI experience to work on predictive analytics for a Resilience Analytics team with one of our major ban

Senior Data Engineer with Python, SQL, VBA and PowerBI experience to work on predictive analytics for a Resilience Analytics team with one of our major banking clients - 36012

Location Address: Hybrid (mostly remote but will be required to come in on an adhoc basis for team meetings) - Downtown Toronto

Contract Duration: 12 months (Chance of Extension)

Scheduled Hours: Monday to Friday, 9am-5pm, 37.5 Hours Per Week

Story Behind the Need:

• Business Group: GBT Risk & Resiliency: 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 bank. 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.
• Project: Stable and resilient systems drive delivery of reliable business applications to our customers. The Resilience Analytics team’s mandate is to design metrics, gather data, analyse and provide insights to executives, execution teams, board representatives, and external regulators. Many of our projects involve the designing of new metrics and gathering of new data sources where creativity, and relationship building with possible sources is critical. We tell our story of resilience to a very senior audience and as such, a command of English is important as is the ability to analyze data and find insights. We work with process owners, technology owners, application owners, various risk, audit, and regulatory bodies across the globe.

Typical Day in Role:

• Reporting to the Director, Resilience Data Analytics, the Data Analytics Senior Engineer (Full-Stack Developer) (DAE) 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 DAE conducts all activities in compliance with governing regulations, internal policies and procedures.
• You are coming into this role to contribute to the technical solutions that will automate processes and enable new data functionality within the team. You will be the senior technical resource of a team of 3 to deliver to project objective. This will include the overall architecture and solution flow for the initiative. We hope to leverage your wide and varied skills to enhance our team’s overall performance.
• Your goal is to tell our resilience and reliability story around backups, disaster recovery and incident reporting for our applications. Can you
• Help us improve our disaster recovery time compliance based on historical testing results? You will build a data model to help ingest data from history as well as interviews that can lead to improved forecasting.
• Help us build co-pilot interfaces to improve the textual base of our reporting
• Help us automate the gathering and distribution of reporting.
• You and your team will work to normalize the data and create dashboard to measure key metrics. You will create input mechanisms so that data can be captured with integrity and quality across multiple resources. 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.

Must-Have skills:

• You have at least 8+ years of hands-on technical working experience as a technical Data engineer / analyst in the development and maintenance of data driven solutions. This includes experience in API/ETL, and Data Visualization using most of the tools we use: Python, SQL, VBA, Power BI ( Power Query, DAX), SharePoint and scripting languages.
• 5+ years of experience in conceptual & logical Data Modelling, Database Design, BI.
• You have 5+ years in Predictive Analytics.
• You have at least 2+ years of working experience presenting your solutions to architecture boards and other technical review bodies.
• You have at least 2+ years of hands-on technical working experience with Agile methodologies and tools: Atlassian’s Bitbucket/Git, Jira Confluence, etc…

Nice-To-Have Skills:

• You have 3+ years working as a team lead for a small development team and can lead through the software development life cycle (SDLC).
• You have experience working with back-ups and restores to at least 2 backup solutions (NetBackup, Tivoli, Veritas, HP Solutions
• experience in writing for and presenting to a Director+ audience & can demonstrate the ability to synthesize quantitative & qualitative information and content for this audience.
• Fluency in Spanish.
• ITIL certifications with experience in a technology operations domain.
• Financial industry experience
• Project Management & Risk Management.
• Exposure to Large Language Models (LLM), Machine Learning (ML), Google Cloud Platform (GCP), or other cloud technologies.

Education:

• You have completed a post secondary education in Computer Science, Engineering, or in a technology related discipline.

Candidate Review & Selection

• 1st round - 30 mins technical (Python, SQL, VBA, PowerBI) & 30mins soft skills - Panel of 4 - MS teams
• 2nd round if needed