Senior Developer, Technology

Senior ETL Developer Location Toronto, ON M5H 1H1 : Requisition ID: 222564 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Global Fraud Technology team develops and manages innovative products designed to continuously strengthen the bank's posture against the ever-changing Fraud threat landscape. We are part of the Global Engineering and Operations Functions team and we work in close partnership with our Fraud Business and key Technology Partners throughout Scotiabank to drive implementation of global products that will protect and strengthen the bank. Global Fraud Technology Team is looking for an energetic and results-oriented Senior BI developer with Azure exposure and deep data analysis background to join our team to help build our most innovative Fraud insights and data product.

We're looking to fill our team with influencers, makers, creators and leaders who are flexible, curious, adventurous, versatile and responsive; Build best in class BI solutions for the Fraud Analytics Architecture scrum team; working closely with Product Owners, Developers, Scrum Masters, Project Management and Stakeholders to deliver on the product roadmap

Provide Production Support on current environment and ETL data pipeline

Conduct source data analysis and profiling to complete source to target mapping

Develop and execute shell scripts, with proficiency in Windows batch scripting.

Develop ETL process using MS SQL Server BI stack and MS Azure Data Factory to ingest, transform, cleanse and load data into on-prem SQL Server 2017 and/or Azure SQL DB

Collaborate with data architect, ETL development lead, and data analysts to design optimal logical and physical data model for fast querying of large volume of data

Work closely with stakeholders to understand business needs, data specifications and translate highly complex requirements into technical design and implementation

This includes ensuring proper documentation is created by the team, including (but not limited to) design specifications, developing programs, test strategies, peer reviews, change control, release preparation, artefacts for operational readiness and steady state support

Post-secondary degree in Computer Science, Engineering or similar degrees. Certification in Business Intelligence preferred.

You have 5-7 years of experience in working for large projects and have advanced experience with SQL Scripting, ETL, data analysis and profiling, data mapping, data modeling, data lakes, and analytics

You are an expert in dimensional data modeling methodology

You have extensive development experience with SQL Server SSIS, Integration Services Catalog and project deployment

You have working knowledge of Power BI design and implementation

You have experience working with an agile scrum team

You have experience working with Azure DevOps pipeline, Azure Data Factory and Azure SQL MI

You are excellent in written and spoken English to clearly communicate complex issues and interface with all levels of the organization with ease

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.

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!

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. 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. Candidates must apply directly online to be considered for this role.