Data Analyst with Python and ETL

3 months ago


Old Toronto, Canada Scotiabank Full time

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

The Team

This position belongs to a highly skilled development team that develops and supports various applications in growing Global Regulatory & Controls Technology team. The team is responsible for providing specialized analysis, design, development, and support of cost effective, mission critical, on-line, risk management and decision support systems for business users within Scotiabank IT group.

The role:
  • The incumbent will be responsible for supporting and building end-to-end technical solutions to support regulatory reporting of Scotia Capital Markets transactions. From root cause and business requirements analysis, aided by strong data and technical system analysis, to solutioning, development, testing, and release to production, the incumbent will ensure timely resolution of high priority Production Support tickets.
  • The incumbent will work closely with the broader project team, developers, scrum masters, regulatory stakeholders, trading systems, and downstream consumers to ensure high priority support tickets are resolved within SLAs with high quality. The incumbent will also be expected to develop application and business process subject matter expertise over the duration of the assignment.
Is this role right for you?
  • Work within a cross functional Agile team to analyse and troubleshoot technical issues and production support tickets and deliver solutions for the same.
  • Change request delivery – requirements gathering, design, implementation, and testing as part of new regulatory initiatives.
  • Support of advanced issue triage and ad-hoc data analysis and reporting.
  • Work closely with business users and IT teams from multiple key trading systems in Canada, US, and Asia, in the design and prototyping of business solutions.
  • Ad hoc inquiries from business stakeholders on G20 Regulatory Reporting logic (CFTC, SEC, CSA, MAS, HKMA, EMIR, UK, etc.), behaviour, and data requests.
  • Keep current on rapidly changing technological trends, self-leaner on new technologies and maintain an understanding of the business and technology strategies.
  • Ability to look at a problem from both a business and technical angle.
  • Other projects and initiatives as required.
Do you have the skills that will enable you to succeed in this role?
  • Strong hands-on experience with data analysis and ETL (SQL, Python, Kafka, Jupyter, Java, XML, and JSON).
  • High levels of analytical, conceptual, problem solving and organizational skills.
  • Excellent verbal and written communication skills.
  • Attitude and willingness to learn fast, go above and beyond consistently and work independently without supervision.
  • Experience with Apache Kafka, Postman, ElasticSearch, Kubernetes, Airflow, and/or Linux.
  • Ability to perform Java coding is a strong asset.
  • Knowledge of Capital Market products, front office trading, and back-office booking process globally.
  • Provide timely IT support to the enquiries from regulators in Canada and US and internal business stakeholders to meet critical timelines.
  • Excellent team building skills, working with diverse groups to resolve issues and identify efficiencies.
  • Ability to work in a project environment as required, with key deliverables and ensuring requirements of department are represented.
  • Strong ability to establish relationships with internal customers, as well as senior management.
  • A recognized degree in engineering, computer science, math, related discipline or experience.
What's in it for you?
  • We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success
  • We provide you with the tools and technology needed to create beautiful customer experiences.
  • You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world.
  • We offer a competitive total rewards package that includes a base salary, a performance bonus, company matching programs (on pension & profit sharing), generous vacation, personal & sick days, personal development funding, maternity leave top-up, parental leave and much more.

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

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


  • Toronto, Canada Scotiabank Full time

    Is this role right for you? Work within a cross functional Agile team to analyse and troubleshoot technical issues and production support tickets and deliver solutions for the same. Change request delivery – requirements gathering, design, implementation, and testing as part of new regulatory initiatives. Support of advanced issue triage and ad-hoc...


  • Toronto, Canada Scotiabank Full time

    Requisition ID: 200666 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. **The Team** **The role**: - The incumbent will be responsible for supporting and building end-to-end technical solutions to support regulatory reporting of Scotia Capital Markets transactions. From root cause and business...


  • Toronto, Ontario, Canada Sun Life Full time

    Job Title: Senior Python ETL DeveloperAre you a skilled Python developer looking to take your career to the next level? Do you have experience with data transformation and ETL processes? We are seeking a highly motivated and experienced Senior Python ETL Developer to join our team at Sun Life.Job Summary:We are looking for a talented developer to design,...


  • Toronto, Canada Atlantis IT group Full time

    **Role - Data QE Lead(ETL, BigData & Python skills)** **Location - Toronto, ON - Canada** **Duration - Long Term** Data QE Lead with 8+ years QE and lead experience on ETL, BigData & Python skills. Thanks & Regards, **_Harshaja_** Apptoza Inc. Phone#:647-953-1625


  • Toronto, Ontario, Canada Purple Drive Full time

    Job OverviewPurple Drive is seeking a highly skilled Senior ETL Data Analyst to join our team. As a key member of our data analytics department, you will be responsible for ensuring the accuracy and integrity of our data.Estimated Salary$120,000 - $150,000 per year, depending on experience.Job DescriptionIn this role, you will work closely with our...

  • Data Analyst

    3 months ago


    Toronto, Canada Sun Life Full time

    You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll...


  • Toronto, Canada Sun Life Full time

    Job Description : Do you want to build and maintain mission critical data processing and transformation systems that will help run one of Canada’s biggest financial institutions? Do you enjoy being part of a tight-knit, empowered team? Do you have experience writing data manipulation code in a cloud using Python and/or Pyspark? If so, we’d like to hear...


  • Toronto, Ontario, Canada Wirehead Full time

    Wirehead is seeking an experienced Data Engineer ETL Specialist to join our team on a 4-month contract with a potential extension of up to 1 year. The successful candidate will be based in Toronto and work in a hybrid environment, commencing within 2-3 weeks.Key Responsibilities:The ideal candidate will have extensive experience working with ETL tools,...

  • Data and AI Analyst

    4 weeks ago


    Toronto, Canada Stikeman Elliott Full time

    We are seeking an experienced Data Analyst with expertise in Generative AI (GenAI), Python, and data strategy implementation to join our team. This role will assist with shaping and executing our organization’s data strategy, helping us optimize how data is collected, processed, and utilized to drive business decisions. The ideal candidate will have...

  • Senior ETL Developer

    4 weeks ago


    Old Toronto, Canada LanceSoft Full time

    ${lang_code} Job Title: Sr. ETL Developer${lang_code} We are seeking an experienced ETL developer to join our team at LanceSoft. As a key member of our data integration team, you will be responsible for designing, developing, and implementing complex data pipelines using Azure Data Factory, Azure Synapse Analytics, and other ETL tools.Responsibilities:Design...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Job Title: Senior Python Developer - Data Extraction SpecialistJob SummaryNexus Systems Group Inc. is seeking an experienced Senior Python Developer to join our team as a Data Extraction Specialist. The successful candidate will have a strong background in Python programming and experience with data extraction, transformation, and loading (ETL) functions....

  • ETL Developer

    3 weeks ago


    Old Toronto, Canada ALLTECH CONSULTING SVC INC Full time

    About the RoleWe are seeking a highly skilled ETL Developer to join our team at ALLTECH CONSULTING SVC INC. As an ETL Developer, you will be responsible for designing, building, and maintaining complex data extraction, transformation, and loading processes using Informatica.The ideal candidate will have 10+ years of experience with data warehousing design...

  • ETL Tester

    4 weeks ago


    Toronto, Ontario, Ontario, Canada Iris Software Inc. Full time

    Iris's direct client, one of the leading Banking and Financial Company, is looking to hire a Sr ETL Tester (Database Testing and Python) for a long term opportunity at Toronto, ON (Hybrid Position). Please respond back with your most recent resume if you would be interested..!Position: Sr ETL Tester (Database Testing and Python)Location: Toronto, ON...

  • Senior ETL Developer

    3 weeks ago


    Old Toronto, Canada Softline™ Technology Inc. Full time

    Data Warehouse SpecialistThis role is responsible for designing, developing, maintaining, and optimizing ETL (Extract, Transform, Load) processes in Databricks for data warehousing, data lakes, and analytics. The specialist will work closely with data architects and business teams to ensure the efficient transformation and movement of data to meet business...

  • Python Developer

    4 weeks ago


    Toronto, Ontario, Ontario, Canada Cititec Talent Full time

    Python Software Developer (Data)Data Pipeline DevelopmentCommodities TradingToronto, CanadaOur client, a prominent financial services firm, is looking for a Python Software Developer to join their data focussed team. This role is focused on designing, developing, and maintaining ETL pipelines to streamline the ingestion and processing of fundamental data....

  • Sr. ETL Developer

    1 month ago


    Old Toronto, Canada LanceSoft Full time

    Title: Sr. ETL DeveloperLocation: Toronto, ON (Hybrid)Duration: 6 Months Contract with 6 Months possible extension.Job Description:Desired Skills and Experience5+ years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns....

  • Software Developer

    1 month ago


    Old Toronto, Canada Arthur Grand Technologies Inc. Full time

    Company DescriptionArthur Grand Technologies (www.arthurgrand.com) is in the business of providing staffing and technology consulting services. We have doubled our revenue year over year for the past 5 years. This speaks to the long-lasting relationship and customer satisfaction that we have built in this short span of time. Our company is managed by a team...


  • Toronto, Canada S.i. Systems Full time

    Sr. QA Analyst to create and execute automation tests for Data/ETL projects using TOSCA for a large insurance client - 5180 Duration: 6 Months (possibility for extension) Location: Remote *ERC required Applications Operations Services & Quality Engineering (AOSQE) is looking for a Senior Software Development Engineer in Test (Data/ETL Testing) with a...


  • Old Toronto, Canada Live Assets Full time

    Bi-Engineer Position in Veterinary HealthcareCompany Overview:Live Assets | IT Staffing Solutions collaborates with a leading Veterinary Provider to deliver innovative healthcare solutions. We seek a skilled Bi-Engineer to join our client's team.Estimated Salary Range: $90,000 - $120,000 per annumLocated in Canada, this role offers an exceptional opportunity...