ETL Software Engineer, Scotiabank

3 months ago

Old Toronto, Canada Scotiabank Full time
Title: ETL Software Engineer, Scotiabank

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
  • Develop 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
  • Develop SQL views to enable data consumers to read data from data warehouse
  • Document 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
  • 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:

  • Experience leading data initiatives as the technical lead / technical PM from intake / requirements / estimations to solution design, development, testing, productionization of data processes
  • Experience leading developers (consisting of contractors as well as full-time employees) to enable data processes
  • Experience implementing data ingestion pipelines / DevOps (on-prem and GCP cloud) to move data from source systems to our central data repository
  • Experience developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with data warehouse
  • Ability to provide smooth transition to Operations team to ensure processes are sustained effectively once they go live
  • Experience supporting design and development of high quality dashboards / reports using tools like Power BI, SSRS, Excel/PowerPivot and Tableau.
  • Experience completing testing to ensure high quality product for clients
  • Experience developing SQL views to enable data consumers to read data from data warehouse
  • Experience documenting databases, data process flows and maintaining data dictionaries
  • Ability to troubleshoot and resolve database and applications defects in a timely manner. Consult with internal and external groups as required
  • Experience assisting with resource onboarding / access / tool procurement activities
  • Experience assisting with tracking financials, including resource forecasts, accruals etc as needed
  • Experience training and assisting 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.
  • 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.
  • 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 - 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

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 during the recruitment and selection process, please let our Recruitment team know. 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.

#J-18808-Ljbffr

  • 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

    4 months ago

    Toronto, Canada Scotiabank Full time

       Requisition 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 joining a team of solution...

  • 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

    4 weeks 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

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

  • 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

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

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

    1 month 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,...

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

  • Software Engineer

    4 months ago

    Old Toronto, Canada Scotiabank Full time

    Title: Software EngineerRequisition 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 joining a team of...

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

  • Scotiabank Cloud Engineering Principal

    3 weeks ago

    Old Toronto, Canada Scotiabank Full time

    Principal Cloud Engineer RoleThis position operates within the Cloud Storage Engineering team at Scotiabank, responsible for creating platform components and services for enterprise-wide use.About the JobChampion a customer-focused culture to deepen client relationships and leverage broader Bank relationships, systems, and knowledge.Design, develop, and...

  • Data Analyst with Python and ETL Expertise

    3 weeks ago

    Old Toronto, Canada Scotiabank Full time

    Scotiabank is seeking a Data Analyst with expertise in Python and ETL to join our team.Key ResponsibilitiesSupport and build end-to-end technical solutions to assist with regulatory reporting of Scotia Capital Markets transactions.Work closely with the broader project team, developers, scrum masters, regulatory stakeholders, trading systems, and downstream...

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