Scotiabank

Lead Developer with Azure Data Factory and ETL

Scotiabank$100K — $130K *
Enterprise Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in ETL development, specifically with Azure Data Factory and SQL Managed Instance.
  • Strong SQL Server skills, particularly in designing stored procedures and optimizing SQL code.
  • Familiarity with Cloud security practices and Identity Access Management (IAM) within Azure.
  • Experience with developing CI/CD pipelines in Azure DevOps for software deployment.
  • Practical knowledge of scripting in Linux and .NET Core development (C#, ASP).
  • Excellent analytical skills for troubleshooting complex issues in a technology environment.

Responsibilities

  • Develop and enhance ETL processes for collections data using Azure technologies.
  • Provide various levels of technical support (L1/L2/L3) for ETL systems.
  • Collaborate with infrastructure teams to manage system upgrades and migrations.
  • Solve complex problems affecting collections processes and make design recommendations.
  • Coordinate with multiple teams and vendors for issue resolution.
  • Ensure quality data management across the bank's platforms.
  • Facilitate documentation of processes, solutions, and findings for future reference.

Benefits

  • Opportunity to work in a strategic technology-driven environment focused on innovation.
  • Inclusive and collaborative workplace that supports creativity and recognition of achievements.
  • Access to mentorship from experienced industry leaders.
  • Emphasis on continuous learning and professional development.
  • Flexible work arrangements empowered by employee well-being initiatives.
Full Job Description
Requisition ID: 266162

The Team

Global Operations Technology - Fraud, Collections & System Reliability Office provides solutions and support to the retail Collections business operations in Canada, LATAM and Caribbean countries. We support mission critical applications and technology processes across the global landscape of the bank to help our business partners provide customer service excellence with regards to the collection of delinquent payments.

The Role

A key technical contributor to the Cloud migration journey for Global Collections. Designs and develops ETL processes on pipelines using Azure Data Factory/Azure SQL Managed Instance platforms. Refines processes and pipelines for code and infrastructure delivery, ensuring protection of sensitive Bank data as it relates to Collections data processing,

Provides Azure ETL processing on-call support for Canada Collections.

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

  • Develop new solutions and improve existing technology capabilities to ensure Collections data processing activities are executed in accordance with business requirements
  • Provide L1/L2/L3 support for ETL processes built on SSIS, DataStage and PLSQL
  • Provide Cloud technology support to Collections, including new and existing portfolios, ad hoc queries, and assisting with the design and implementation of systems enhancements
  • Work with Infrastructure teams to co-ordinate infrastructure/environment related upgrades, patches and migration activities
  • Resolve highly complex, multi-faceted problems to meet Collections business needs, providing recommendations on design, methodologies and system solutions
  • Co-ordinate and follow up with various other different teams, vendors and third party for issue resolution
  • Liaise with appropriate teams Bank wide to fix data quality issues
  • Provide input to the continuous improvement of processes and adopting latest technologies and methodologies
  • Ensure the documentation of issues, solutions, root cause and findings for use in future problem resolutions
  • Understand how the Bank's risk appetite and risk culture should be considered in day-to-day activities and decisions
  • Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge
  • Champions a high-performance environment and contributes to an inclusive work environment.
  • Actively pursues effective and efficient operations of his/her respective areas in accordance with Scotiabank's Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk


What You Will Bring to Succeed

  • Hands on experience on Azure Data Factory/Synapse ETL pipelines creation from scratch and troubleshooting cloud configuration issues
  • Strong SQL Server development experience including (but not limited to) designing efficient stored procedure-based dataflows, building DB objects such as tables, indexes, partitions
  • Strong knowledge on SQL code optimization techniques, leveraging tools such as SQL execution plans
  • Strong fundamentals of security and IAM on Azure Cloud
  • Solid practical understanding of Active Directory, Service principles, Secrets, Private End Points, Azure Key Vault
  • Experience developing CI/CD pipelines on Azure DevOps for deployment of Azure Data Factory/SQL Ml code base to higher environments (UAT/PROD)
  • Development techniques, such as debugging, testing, coding, use of version control tools like TFS
  • 2 years Azure Data Factory pipeline development experience (highly desirable)
  • Performance tuning skills are considered to be an asset
  • DevOps process oriented
  • Experience in Linux SSH Scripting
  • Experience in .NET Core Development (C#, ASP)
  • Practical experience of technology integrations, using best practice methods to establish secure connectivity (i.e. APIs/Microservices) for data exchange
  • Support/integration experience with SaaS solutions and vendor driven technology
  • Basic knowledge of Jira and Confluence
  • Excellent analytical, problem solving and trouble shooting skills in order to quickly and effectively resolve problems in a demanding environment
  • Strong communication skills (written and verbal) related to technology solutions, project deliverables and on-going communication


What's in it for you?

  • We are strategic technology partners dedicated to transforming the way our global workforce operates.
  • Our inclusive and collaborative work environment fosters creativity, curiosity, and celebrates achievements.
  • You will have the opportunity to collaborate with and learn from diverse industry leaders who have experience at top technology companies worldwide.
  • We cultivate a culture of innovation and continuous learning.
  • We prioritize the well-being of our employees, empowering them to design their work processes to achieve outstanding results.
  • We offer a competitive total rewards package, which includes a performance bonus, company matching programs (for pension and profit sharing), and generous vacation benefits.

#LI-Hybrid

Location(s): Canada : Ontario : Toronto

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
5 Year Trend
+7%
NASDAQ

Similar Jobs

More Jobs at Scotiabank

More Enterprise Technology Jobs

Find similar Lead Developer with Azure Data Factory and ETL jobs: