Data Engineer

Position Title: Data Engineer
Location: Toronto, ON
Duration: 12 months
             
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 client. 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.
Reason: New requirement
Candidate Value Proposition:

• A 12-month contract position focused on delivering value within a development framework using technology operations data.
• You will be part of the team transforming the way we do and measure IT services to build reliable and resilient systems for our customers.
• The role is mostly remote with occasional rips to work with team members (usually downtown). On-site access can be made available if required in several locations.
• We have an inclusive and collaborative environment encouraging creativity and curiosity.
• You’ll get to work with and learn from diverse industry leaders.
• We foster an environment of innovation and continuous learning.
• We care about our people, allowing them to design how they work to deliver amazing results.

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.
The main function of a Developer is to design, develop, and implement applications using general languages and technologies to support business requirements. Job Responsibilities: Analyze highly complex business requirements; generate technical specifications to design or redesign complex software components and applications. Act as an expert technical resource for modeling, simulation and analysis efforts. Leverage industry best practices to design, test, implement and support a solution. Assure quality, security and compliance requirements are met for supported area. Be flexible and thrive in an evolving environment. Adapt to change quickly and adjust work accordingly in a positive manner.
Candidate Requirements/Must-Have skills:

• You have at least 8+ years of hands-on technical working experience as a technical 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.

Soft Skills:
You have proven interpersonal and negotiation skills that allow you to build consensus and obtain co-operation from both support teams and senior management.
Excellent written, presentation, and verbal communication skills to be able to work well with technical peers and business stakeholders at different levels within the organization

• Strong decision making, forward thinking and creative problem-solving skills to anticipate and respond quickly to technological/market influences
• Ability to work as part of a team, as well as work independently or with minimal direction

Best vs. Average Candidate:

• Clear, crisp and tight communication skills
• Well organized and strong problem-solving skills
• Ability to influence various levels of key stakeholders and push project results forward

The ideal candidate would have previous client experience with IT operations experience especially backups. Has Solutioning experience in Data analysis in his recent position. Great communications skills. Success in Predictive Analytics
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