Scotiabank

Integration Engineer

Scotiabank • $90K — $120K *
Toronto, ON M3C 0E3In-Person
Information Technology
5 - 7 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 6+ years experience as a Data Engineer or similar role
  • Strong expertise in SQL for writing and optimizing queries, stored procedures, and data transformations
  • Proficient in Azure cloud services such as SQL Database, Data Factory, and DevOps
  • Experience with large-scale ETL processes and data pipelines
  • Knowledge of data modeling and warehousing
  • Solid understanding of data security and compliance in cloud environments
  • Bachelor's degree in Computer Science, Engineering, or related field

Responsibilities

  • Design and optimize robust and scalable data pipelines for ETL processes
  • Gather requirements and design solutions with business stakeholders
  • Build and maintain data pipelines leveraging Azure services and SSIS 2019
  • Write complex SQL queries and develop stored procedures for data processing
  • Create ETL solutions using IBM DataStage and optimize performance
  • Integrate data from multiple sources to ensure seamless flow
  • Collaborate with teams to enhance data infrastructure and provide insights

Benefits

  • Diversity, Equity, Inclusion & Allyship initiatives to empower and respect employees
  • Commitment to accessibility and removing barriers for inclusion
  • Competitive rewards program with bonuses, flexible vacation, and immediate benefits
  • Dynamic work environment with amenities like free tea and coffee and collaborative spaces
Full Job Description
Requisition ID: 268187

Role

Results-driven Integrations Engineer with strong experience in designing, developing, and optimizing data pipelines and database solutions. Skilled in SQL, Azure data services, IBM DataStage, and database development, with a proven ability to build scalable ETL processes, integrate complex data sources, and ensure high data quality and performance. Experienced in developing data models, optimizing queries, and supporting analytics and reporting needs across enterprise environments. Adept at working with large datasets, implementing data governance practices, and collaborating with cross-functional teams to deliver reliable and efficient data solutions

Accountabilities

Data Engineering & Pipeline Development:
  • Design, implement, and optimize robust and scalable data pipelines for extracting, transforming, and loading (ETL) data.
  • Work with stakeholders to gather requirements and design solutions that align with business goals.
  • Build and maintain data pipelines using Azure services and SSIS 2019.

SQL Development:
  • Write complex SQL queries for data extraction, aggregation, and transformation.
  • Develop and optimize stored procedures, views, and functions to support data processing and reporting.
  • Manage and optimize relational databases and large datasets.

DataStage Development
  • Create ETL solutions using DataStage
  • Expert in DataStage solution conception design and development.

Cloud Data Solutions (Azure):
  • Build and maintain cloud-based data solutions using Azure technologies such as Azure SQL Managed Instance (SQL-MI), Azure Data Factory and Azure Blob Storage.
  • Leverage Azure tools for data warehousing and integration.
  • Optimize data processing and storage costs using Azure resources.

Data Integration:
  • Integrate data from various sources (internal and external) / files and databases to ensure seamless data flow within the organization.
  • Maintain and monitor the data quality and consistency across all integrated systems.

Collaboration:
  • Business stakeholders, analysts, and other engineers to ensure high-

quality data infrastructure.
  • Provide insights and recommendations on how to improve data processing and transformation and distribution.

Optimization and Performance Tuning:
  • Continuously monitor the performance of data systems and optimize them for speed, scalability, and cost.
  • Perform regular database and pipeline performance tuning and troubleshooting.
  • Continually acquire and enhance knowledge of the Division's business strategies and policies, risk management practices and methodologies, product offerings, financial markets, financial instruments, regulatory requirements, Back Office processes, and rapidly changing technology to be able to provide effective business solutions and services to the end user business lines.
  • Understand how the Bank's risk appetite and risk culture should be considered in day-to-day activities and decisions.


Skills and Experience

  • Proven experience as a Data Engineer or similar role. (6+ years)
  • Strong expertise in SQL (e.g., T-SQL, PL/SQL) for writing and optimizing queries, stored procedures, and data transformations. (6+ years)
  • Proficient in Azure cloud services, including Azure SQL Database, Azure Data Factory, Azure Key Vault, Azure DevOps / BLOB Storage. (5+ years)
  • Experience working with large-scale ETL processes and data pipelines. (5 + years)
  • Knowledge of data modeling and data warehousing (5 + years)
  • Solid understanding of data security and compliance within cloud environments. (4+ years)
  • Expertise in IMBs DataStage development (2+ Years)
  • Familiarity with version control tools such as Git. (5+ years)
  • Ability to work in a collaborative, fast-paced environment.
  • Knowledge in Autosys Workload Automation (2+ years)
  • Bachelor's degree in Computer Science, Engineering, or related field.
  • Experience with DevOps practices, CI/CD pipelines, and automation tools.
  • English with Spanish is a plus.
  • Strong problem-solving skills and analytical mindset.
  • Excellent communication and teamwork skills.
  • Ability to prioritize and manage multiple tasks simultaneously.
  • Detail-oriented and proactive approach to identifying and resolving issues.


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 - We value the unique skills and experiences each individual brings to the Bank and are committed to creating and maintaining an inclusive 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.
  • Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
  • Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.


Location(s): Canada : Ontario : Toronto

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.

About Scotiabank

Scotiabankers are committed to helping individuals, companies, and communities to thrive in a changing world. From personal and business banking, brokerage, and insurance, to private wealth, and the most sophisticated commercial, corporate and institutional services, they serve the diverse needs of some 21 million customers in more than 55 countries. Founded in 1832 in Halifax, Nova Scotia, their growth has always been fuelled by the success of their customers and their longevity secured by an unshakable commitment to carefully and expertly managing risk and capital. That focus on doing what's right for customers—short- andlong-term—has made us a global financial services leader. Headquartered in Canada, they are over 86, 000 Scotiabankers strong. Each of us are committed to being the best at understanding their customers' needs and all of us working together to deliver practical advice and relevant solutions that help their customers become financially better off.

Scotiabank Careers

Join Scotiabank, a premier financial institution, and become part of a diverse and inclusive team that’s leading the way in global banking. At Scotiabank, we offer more than just job opportunities; we provide a platform for professional growth and innovation in the financial services industry.

Work You’ll Do

At Scotiabank, we’re not just filling positions; we’re cultivating leaders. Dive into a workplace where diversity training and leadership development shape the path to your future. Our commitment to professional growth is evident in our robust training programs and continuous learning opportunities that foster innovation and strategic thinking.

Explore a World of Opportunities

Whether you’re looking for a full-time position, an internship, or a leadership role, Scotiabank has a spectrum of opportunities to fit your career ambitions. Our team is composed of individuals who bring a wealth of skills and perspectives to our company, driving us forward with their creativity and strategic insights.

Innovative Work Environment

Scotiabank’s culture is one of collaboration and respect, where each team member’s contribution is valued. Engage in meaningful work that challenges you to leverage your skills and push the boundaries of what’s possible in the banking sector. Our innovative projects not only support the growth of the company but also ensure our position as a leader in the industry.

Benefits and Growth

Choosing a career at Scotiabank means opting for a life of growth and opportunity. Our employees enjoy competitive benefits, including comprehensive health coverage, retirement plans, and flexible working conditions, all designed to support your career and personal life. We believe in nurturing our team’s potential by providing them with the tools they need to succeed both professionally and personally.

Join Our Team

Ready to take the next step in your career? Explore the job opportunities at Scotiabank by searching our open positions that match your skills and interests. We are continuously hiring and looking for passionate, curious, and solution-driven team players.

Networking and Professional Development

Stay connected and advance your career through Scotiabank’s extensive networking opportunities. Participate in events that connect you with other professionals and leaders within the industry. Our career resources will help you prepare your resume, ace your interviews, and land the job that best suits your career goals.

Stay Ahead

Keep up to date with the latest in career tips, industry insights, and company news—all from the people who work here at Scotiabank. Personalize your experience by subscribing to job alert emails tailored to your preferences and be the first to know about new openings and exciting developments. Join Scotiabank and be part of a team that values integrity, respect, and accountability. Discover how your career can flourish in an environment committed to your professional development and personal growth.
Learn more about Scotiabank
Size
90,619 employees
Market Cap
$57.5 billion
Industry
Finance & Insurance
5 Year Trend
+7%
NASDAQ
BNS
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Scotiabank

More Information Technology Jobs

Find similar Integration Engineer jobs:

NationwideToronto, ON