Senior Software Engineer with MSBI

Job title: Senior Software Engineer with MSBI

Company: Scotiabank

Job description: Requisition ID: 203517Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.Role

• You are a technical expert who will help expand and optimize our data architecture and data transformation and delivery pipelines.
• An experienced data wrangler who enjoys optimizing data systems to support not only software developers, database architects, data analysts, and data scientists but also business partners, data governance professionals and subject matter experts within our Anti Money Laundering and Terrorist Financing (AMLTF), audit and compliance and functional groups.
• The right candidate will be excited by the prospect of optimizing our company’s AMLTF reporting data architectures to support our next generation of applications including both cloud-based reporting system as well as on-premises reporting warehouses and platforms to help drive better reporting insights from our data.
• You are a multi-talented data professional who can embrace architecture, analytics, modeling, and development, are comfortable collaborating with business subject matter experts have a keen ability to translate business needs into requirements documents, technical solutions, and storytelling insights.

Responsibilities

• Research, develop, deploy, and maintain end-to-end AML data and analytics solutions maximizing data pipelines and architectures to provide actionable talent metrics and insights (datasets, visualizations, dashboards) to serve business needs.
• Identify, design, and implement internal process improvements: automating manual processes, orchestrating and optimizing data delivery across various cloud-based and on-premises data platforms, re-designing data models for greater scalability, etc.
• Build on and optimize the existing foundation of data pipeline architectures required for optimal extraction, transformation, and loading of data from a wide variety of data sources using various methods, programming languages, and software technologies, adjusting as needed to optimize effectiveness.
• Support the construction of a common repository of AML and audit data knowledge including data dictionaries, dimension and measure definitions, platform cross walks and basic governance and lineage.
• Manage project risks, issues, and decisions related to data requirements, ensuring proper steps are taken to mitigate, escalate, and communicate detailed updates to leadership.
• Contribute to and review project documents, ensuring alignment between Business, Strategic, and HR data requirements, and contribute to successful data solution delivery by managing priorities, timelines, dependencies, critical paths, and solution design.

What do you need to succeed?Must have skills:

• 5+ years of advanced working experience with relational databases (MSSQL Server, or similar)
• 5+ years of advanced experience with MSBI Platform Tools (SSIS, SSRS, Power BI) and Windows Automation using Power Shell
• Expertise with object-oriented language for use with data access, data manipulation, ETL, APIs, text mining, and light analytics (including C#, Python and R)
• Experience with Version Control collaboration tools (Git)
• Strong management, organizational, critical thinking, analytical, communication and negotiation skills

Nice-to-have

• Expertise with cloud computing-based data platforms like Google Cloud or Azure
• Graduate degree in Computer Science, Statistics, Information Systems, or related quantitative field.
• 5+ years of experience in a Data Engineering or equivalent role.

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 everyone 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.
• Hybrid-friendly work environment will provide you with the flexibility of best of both remote and in office world, to perform at your best.
• 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.
• Community Engagement – no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

Location(s): Canada : Ontario : TorontoScotiabank 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 . 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.

Expected salary:

Location: Toronto, ON

Job date: Tue, 30 Jul 2024 22:08:58 GMT

Apply for the job now!