ETL Software Engineer, Scotiabank

4 months ago

Toronto, Canada Scotiabank Full time

 

 

 

Requisition ID: 203486

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

 

The Global Compliance Technology team is accountable for developing and supporting a number of compliance and risk management data and reporting solutions within the Bank.  The incumbent will be joining a team of solution developers and architects that work with on prem and cloud data platforms utilized in compliance and risk management. 
  

The team is seeking a Software Engineer to integrate and support systems and ingest data from source systems to our data warehouse and to develop dashboards and reports.  

 

 

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

  • Lead data initiatives as the technical lead / technical pm from intake / requirements / estimations to solution design, development, testing, productionization of data processes
  • Lead developers (consisting of contractors as well as full time employees) to enable data processes
  • Implement data ingestion pipelines / DevOps (on prem and GCP cloud) to move data from source systems to our central data repository
  • Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with data warehouse
  • Provide smooth transition to Operations team to ensure processes are sustained effectively once they go live
  • Support for design and development of high quality dashboards / reports using tools like Power BI, SSRS, Excel/PowerPivot and Tableau.  
  • Complete testing to ensure high quality product for clients
  • Developing SQL views to enable data consumers to read data from data warehouse
  • Integrate systems via REST API, database views, SharePoint lists, sFTP, etc
  • Responsible for documenting databases, data process flows and maintain data dictionaries
  • Troubleshoot and resolve database and applications defects in a timely manner. Consult with internal and external groups as required
  • Coordinating code deployments / production implementations.
  • Assist with resource onboarding / access / tool procurement activities
  • Assist with tracking financials, including resource forecasts, accruals etc as needed
  • Train and assist users at all levels

 

 

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

  • Lead data initiatives as the technical lead / technical pm from intake / requirements / estimations to solution design, development, testing, productionization of data processes
  • Lead developers (consisting of contractors as well as full time employees) to enable data processes
  • Implement data ingestion pipelines / DevOps (on prem and GCP cloud) to move data from source systems to our central data repository
  • Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with data warehouse
  • Provide smooth transition to Operations team to ensure processes are sustained effectively once they go live
  • Support for design and development of high quality dashboards / reports using tools like Power BI, SSRS, Excel/PowerPivot and Tableau.  
  • Complete testing to ensure high quality product for clients
  • Developing SQL views to enable data consumers to read data from data warehouse
  • Integrate systems via REST API, database views, SharePoint lists, sFTP, etc
  • Responsible for documenting databases, data process flows and maintain data dictionaries
  • Troubleshoot and resolve database and applications defects in a timely manner. Consult with internal and external groups as required
  • Coordinating code deployments / production implementations.
  • Assist with resource onboarding / access / tool procurement activities
  • Assist with tracking financials, including resource forecasts, accruals etc as needed
  • Train and assist users at all levels

 

 

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

 
 
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.

  • ETL Software Engineer, Scotiabank

    3 months ago

    Old Toronto, Canada Scotiabank Full time

    Title: ETL Software Engineer, ScotiabankRequisition ID: 203486Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.The Global Compliance Technology team is accountable for developing and supporting a number of compliance and risk management data and reporting solutions within the Bank. The incumbent will be...

  • ETL Software Engineer, Scotiabank

    3 months ago

    Old Toronto, Canada Scotiabank Full time

    Title: ETL Software Engineer, ScotiabankRequisition ID: 203486Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.The Global Compliance Technology team is accountable for developing and supporting a number of compliance and risk management data and reporting solutions within the Bank. The incumbent will be...

  • Software Engineer with Datastage and ETL

    2 weeks ago

    Toronto, Canada Scotiabank Full time

       Requisition ID: 210538Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Team  The primary role of Global Finance Technology is to work with the Bank's finance community to re-engineer finance processes to enhance effectiveness and efficiency.  The unit is also responsible for developing and...

  • Data Engineer

    1 month ago

    Toronto, Ontario, Canada Scotiabank Full time

    Job Title: Data Engineer - ETL PipelinesScotiabank is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, developing, and maintaining ETL pipelines to integrate data from various sources into our data warehouse.Key Responsibilities:Design and develop ETL pipelines using T-SQL and SSIS to ingest...

  • Software Engineer, Scotiabank

    5 months ago

    Old Toronto, Canada Scotiabank Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Requisition ID: 201673Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. As a Software Engineer with Scotiabank Platforms, you will have an opportunity to be part of a group of people changing how the Bank...

  • ETL Software Engineer, Data Integration Specialist

    1 month ago

    Old Toronto, Canada Scotiabank Full time

    Job SummaryWe are seeking a highly skilled ETL Software Engineer to join our Global Compliance Technology team at Scotiabank. As a key member of our team, you will be responsible for designing, developing, and implementing data integration solutions to support our compliance and risk management initiatives.In this role, you will lead data initiatives as the...

  • Software Engineer, Scotiabank

    2 months ago

    Toronto, Canada Scotiabank Full time

       Requisition ID: 206721Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. This team contributes to the overall success of the Global Finance and Risk Technology (GFRT). Ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team’s business strategies and...

  • Software Engineer, Scotiabank

    2 months ago

    Old Toronto, Canada Scotiabank Full time

    Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. This team contributes to the overall success of the Global Finance and Risk Technology (GFRT). Ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team’s business strategies and objectives. Ensures all...

  • Senior ETL Engineer

    4 months ago

    Toronto, Canada Scotiabank Full time

    Is this role right for you? In this role you will: Analyse and estimate effort for new scope and requirements Design and development ETL solutions on multiple complex initiatives. Stay abreast of modern technologies and best practices, and recommend introduction of new technology and processes Act as the Subject Matter Expert and manage admin...

  • Software Engineer, Scotiabank

    5 months ago

    Toronto, Canada Scotiabank Full time

    Is this role right for you? In this role you will: Primarily focused on design and development of our API Gateway solution built on Apigee. Participating in daily design discussions focused on scalability and design and implementation best practices Design and develop technical solutions and strategies for software applications and building detail...

  • Application Specialist, Scotiabank

    5 months ago

    Toronto, Canada Scotiabank Full time

    Requisition ID: 196718 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Global Operations Technology - Operations and Corporate Services plays a critical role in enabling Global Engineering, Operations and Functions to deliver against its mission to bring innovation and value to the Bank with...

  • ETL Developer

    1 month ago

    Toronto, Canada Scotiabank Full time

       Requisition ID: 209195Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. We are seeking an energetic, self-starter willing to take on a challenge! This position will deliver against current and new initiatives to support our Enterprise Crisis Management mandate by ensuring that specific goals, plans,...

  • Senior ETL Developer

    3 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    About the RoleWe are seeking an experienced Senior ETL Developer to join our team at Scotiabank.The ideal candidate will have a strong background in developing strategies for Extraction, Transformation, and Loading (ETL) mechanisms, with experience in designing Server jobs using various types of stages. They should also be skilled in integrating multiple...

  • Senior Data Engineer

    4 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Job DescriptionWe are seeking a highly skilled Data Engineer to join our team at Scotiabank. As a Data Engineer, you will be responsible for designing, developing, and implementing data ingestion pipelines and ETL processes to support our business operations.Key ResponsibilitiesLead data initiatives from intake to solution design, development, testing, and...

  • ETL Developer

    1 month ago

    Old Toronto, Canada Scotiabank Full time

    Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.We are seeking an energetic, self-starter willing to take on a challenge! This position will deliver against current and new initiatives to support our Enterprise Crisis Management mandate by ensuring that specific goals, plans, initiatives are...

  • ETL Developer

    1 month ago

    Old Toronto, Canada Scotiabank Full time

    Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.We are seeking an energetic, self-starter willing to take on a challenge! This position will deliver against current and new initiatives to support our Enterprise Crisis Management mandate by ensuring that specific goals, plans, initiatives are...

  • ETL Software Engineer, Data Integration Expert

    3 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Job DescriptionDiversity, Equity, Inclusion & AllyshipWe 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 employees to learn, grow &...

  • ETL Developer

    2 months ago

    Old Toronto, Canada Scotiabank Full time

    Requisition ID: 209195 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. We are seeking an energetic, self-starter willing to take on a challenge! This position will deliver against current and new initiatives to support our Enterprise Crisis Management mandate by ensuring that specific goals, plans,...

  • Datastage ETL Developer

    2 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Scotiabank is a leading bank in the Americas, guided by its purpose: "for every future." This role offers an exciting opportunity to contribute to the bank's finance technology team.About the RoleThe primary responsibility of this position is to provide technical expertise in designing, coding, and documenting ETL processes for new initiatives. The...

  • Data Governance Architect, Scotiabank

    2 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Job Description:As a Data Governance Architect at Scotiabank, you will play a crucial role in designing and managing the bank's ServiceNow platform foundational data. This includes working with stakeholders to ensure that data is sourced, defined, and managed to meet regulatory standards, industry standards, and protect Scotiabank's...