Senior Data Engineer with API/ETL and Data Visualization experience using Python, SQL, VBA, Power BI ( Power Query, DAX), SharePoint and scripting language - ref. o84021523

Senior Data Engineer with API/ETL and Data Visualization experience using Python, SQL, VBA, Power BI ( Power Query, DAX), SharePoint and scripting languages with one of our major banking clients- 36517

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.
• 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 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.

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 bank 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.

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

2nd round if needed

Apply