ETL Data Engineer Associate
Share
Job Location:
Monthly Salary:
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
Requisition ID: 247885
Join a purpose driven winning team committed to results in an inclusive and high-performing culture.
At the heart of the Banks mission to uphold integrity and transparency the Global Compliance Technology team builds and supports cutting-edge data and reporting solutions that drive compliance risk management and procurement excellence. Were a collaborative group of developers and architects working across on-prem and cloud platforms to deliver secure scalable and insightful data products.
Were looking for a passionate ETL Developer Associate who thrives on solving data challenges and building reliable pipelines that fuel decision-making. If youre excited by the idea of working with modern data platforms and contributing to meaningful initiatives this is your opportunity to grow and make a difference.
In this role you will:
- Design and implement data ingestion pipelines across SQL Server Databricks on Azure or Google Cloud Platform (GCP).
- Build robust ETL solutions using T-SQL SSIS and other modern tools to integrate data into our central warehouse.
- Collaborate on end-to-end data initiativesfrom development and testing to deployment and support.
- Ensure smooth handoffs to operations teams and maintain high-quality production-ready data processes.
- Create SQL views and data interfaces that empower users to access and analyze data seamlessly.
- Integrate systems using REST APIs SharePoint sFTP scripting with python and more.
- Document data flows maintain data dictionaries and support data governance efforts.
- Troubleshoot and resolve issues quickly working with internal and external stakeholders.
- Coordinate code deployments and production rollouts.
- Explore and apply AI-powered development tools to boost productivity.
- Support and train users across the organization to maximize data value.
Do you have the skills that will enable you to succeed in this role
- Hands-on experience with the Microsoft Data Platform stack: SQL Server T-SQL SSIS Power BI.
- Development experience (C#) Python DevOps Jira Bitbucket
- Experience with Databricks on Azure or GCP GCP BigQuery Terraform Composer / Airflow Cloud SQL Vertex AI Looker or Azure a plus.
- Comfort working in both Windows and Linux environments.
- Experience with data warehouse design and system integration.
- Ability to consume and work with REST APIs.
- Exposure to AI-assisted coding tools and Git/GitHub Enterprise a plus
- Experience with Power Platform / Power Automate for automating workflows a plus
Whats 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!
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.
Required Experience:
IC
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
Scotiabank is one of the leading foreign banks serving large national and multinational corporations in the U.S. through its Global Banking and Markets, Global Transaction Banking and Wealth Management business lines.
