Specialist, Data Analytics Engineering - Business Intelligence Data Analytics (Hybrid)

Requisition ID: 206230

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

Looking for a hybrid role? We have the job for you! Our employees in hybrid roles can alternate between work from home & onsite in the office with the details to be determined, based on business needs.

The team:

Scotiabank's Global Technology Services - Enterprise Process Management & Compliance's IT Service Management (ITSM)'s Governance, Data Analytics & Reporting team gathers, interprets, and presents data insights at all management levels, including the Board of Directors, ITSM process owners & external regulators.

The role:

Reporting to the Senior Manager, Analytics Technology & Engineering, you will be a senior technical contributor to the overall success of the ITSM by ensuring goals, plans, initiatives are executed / delivered in support of the team's business strategies and objectives. The role conducts all activities in compliance with governing regulations, internal policies, and procedures.

You will develop & maintain Data Engineering pipelines, Business Intelligence (BI), and analytics solutions. You will also complete engineering & architecture deliverables and provide technical consultation + direction to team members. The scope of solutions includes Windows / Web-based applications, complex workflows, automation scripts, Extraction, Transform & Load (ETL) solutions, Executive Dashboards, and much more. All solutions will be expected to follow technology policies, processes, and procedures. The role will also provide use cases and requirements to feeder-systems so that they may capture data for use by the ITSM team.

When required, you can expect to work into the evenings and/or weekends to complete deliverables.

Is this role right for you?

• You have a passion for data, technology, and Agile development.
• You are eager to create processes and documentation to support stable and resilient solutions.
• You can work independently and drive solutions from the ideation phase to implementation.
• You like the challenge to pick up new technologies quickly and have good insight into tools used within the industry.
• You embrace the opportunity to help a team mature on their data analytics engineering journey.
• You are curious and have a business mindset when developing technology solutions.
• You have a strong analytical skillset & thrive to quickly determine, identify root cause, and fix issues.

Do you have the skills that will enable you to succeed in this role?

• You can demonstrate above average communication (verbal/written) skills, which includes the ability to synthesize complex ideas from various sources.
• You have at least 5+ years of hands-on technical working experience in the development and maintenance of data driven solutions, including conceptual & logical Data Modelling, Database Design, BI, ETL, and Data Visualization.
• You have at least 3+ years of hands-on technical working experience as a Senior Data Engineer and/or Database Designer and/or Data Architect that involves performance tuning of both online queries & data driven ETL processes.
• You have at least 3+ years of hands-on technical working experience in writing requirements, architecture documents, or other governance documents associated with application management.
• You have at least 2+ years of hands-on technical working experience in the proficient creation of meaningful reports on MS Excel and/or MS PowerBI and/or MS Data Analysis Expressions (DAX) and/or MS Power Query.
• You can demonstrate a strong hands-on technical working experience with most of the following: Python, R, VBA, or any Object-Oriented programming / scripting languages.

• You have at least 2+ years of hands-on technical working experience with Agile methodologies and tools: Atlassian's Bitbucket/Git, Jira Confluence, etc…
• You have at least 1+ years of hands-on technical experience with predictive analysis & Machine Learning.

• You can troubleshoot BI modelling issues and develop solutions.
• You can demonstrate the ability to lead through the Software Development Life Cycle (SDLC).
• The following skills would be an asset to your success in the role: Exposure to Large Language Models (LLM), Google Cloud Platform (GCP), or other cloud technologies.

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

What's in it for you?

• You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world.
• We have an inclusive and collaborative work environment that encourages creativity, curiosity, and celebrates success! 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.
• We offer a competitive total rewards package, including a performance bonus, company matching programs (pension & Employee Share Ownership), generous vacation; health/medical/wellness benefits; employee banking privileges.
• As a part of our Hybrid Work Model, when required to be onsite, our primary office in downtown Toronto is:

• Renovated with a design focus on enabling collaboration through both environment and technology.
• Located near the TTC's Line 1 King subway station & is located minutes from GO Transit/VIA Rail hub at Union Station; as well as the TTC's King 504 streetcar line.
• Just minutes from the Gardiner Expressway & the DVP.
• Home to The Commons, a dining space at Scotia Plaza for employees where breakfast & lunch are served. Also, The Bean serves hot/cold beverages & snacks.
• Directly accessible to The PATH & its many food courts, restaurants, grocery stores, LCBO, hairdressers, pharmacies, gyms, clothing stores & services.

#scotiatechnology

#LI-hybrid

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.