Data Developer

Scotiabank; Toronto; Hybrid; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled professional to join their dynamic team in Toronto. This role focuses on the implementation and support of an Investment Data Hub, leveraging advanced data management strategies to enhance operational efficiency and decision-making processes. The ideal candidate will possess extensive experience with HIS Markit EDM and SQL, along with a strong analytical mindset. This innovative company promotes a collaborative culture and offers a range of benefits, including upskilling opportunities and a competitive rewards program. If you're passionate about data and technology, this is the perfect opportunity to make a significant impact.

Benefits

Flexible vacation

Tuition assistance

Competitive rewards program

Community engagement opportunities

Free tea & coffee

Dynamic workspace

Employee Resource Groups (ERGs)

Qualifications

• 5+ years of experience with HIS Markit EDM and SQL server.
• Strong analytical skills and attention to detail are essential.

Responsibilities

• Design and maintain the Investment Data Hub system.
• Collaborate with teams to implement system integration solutions.

Skills

SQL

HIS Markit EDM

.Net Framework

Informatica

Data Stage

MSBI

Agile Methodologies

DevOps

Analytical Skills

Problem-Solving Skills

Education

Bachelor Degree in Technology or Computer Science

Tools

SQL Server

Job description

Requisition ID: 224934

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

High quality data is critical to the success of Scotia Global Wealth Management (SGWM). There is a strategic vision across SGWM to transform the way in which data is managed through the creation of a centralized data hub. This has several benefits, including the ability for enhanced analytics to support decision making, improved operational efficiency, risk reduction, decreased vendor costs, and building the foundation for the future.

In this role, you will be responsible for the implementation and on-going support of our Investment Data Hub (IDH), a platform built on the Enterprise Data Management (EDM) solution from S&P Global Market Intelligence. You will also be working with business and technology partners across SGWM on new data and reporting initiatives and delivery of data quality enhancements.

Is this role right for you? In this role you will:

• Design, build, and maintain the IDH system as it supports Business and Operations needs.
• Develop and implement solutions using the IHS Markit EDM platform, ensuring high-quality deliverables.
• Gather, process, and analyze complex raw data at scale, including writing scripts, calling Aps, and writing SQL queries.
• Collaborate with integration teams to design and implement system integration solutions, addressing data-related challenges.
• Develop test strategies to ensure the reliability and performance of developed solutions.
• Interact with Business Analysts and Product Owners for requirement gathering, analysis, and providing technical support during project backlog and sprint backlog calls.
• Prepare comprehensive documentation, including test strategy documents, test case documents, and metadata setup.
• Work in close collaboration with the entire Project and BAU Support teams to ensure on-time deliverables and project milestones.
• Identify and implement internal process improvements to enhance efficiency and reduce time expenses.
• Configure net new and enhance current solutions within IDH to build out a continually evolving centralized data master within SGWM.
• Participate in engagement with key partners and stakeholders to understand investment data and reporting requirements and participate in design, planning, testing, and solutions delivery

Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

• Bachelor Degree, with a technology, computer science, or business focus, or equivalent education and experience.
• High level of proficiency with HIS Markit EDM. 5+ years of experience is preferred.
• High level of proficiency with SQL server, .Net framework, Informatica, Data Stage, and MSBI.
• Experience in Agile and DevOps software development methodologies.
• Previous experience with core investment data domains (eg positions, security reference, pricing and benchmarks).
• Ability to develop positive and collaborative relationships with business partners and effectively communicate with both business and technology data stakeholders.
• Excellent organizational skills and a keen attention to detail.
• Strong analytical and problem-solving skills.

What's in it for you?

• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
• Accessibility and Workplace Accommodations - 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. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
• Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
• Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
• Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.
• Community Engagement - No matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons.

Working location condition: Hybrid

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