Job Information
CIBC Senior Application Consultant- Azure Data Engineer in Toronto, Ontario
We’re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what’s right for our clients.
At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are and what they contribute.
To learn more about CIBC, please visit CIBC.com (https://www.cibc.com/en/about-cibc.html)
What You'll Be Doing
You’ll be joining CIBC’s Commercial Banking and Payments Technology, Smart Investigate application. You’ll will be responsible for the design, development and integration testing, in support of small to large scale projects. You will be responsible for providing production support when required. In addition, you will sometimes act as an application specific work package lead or as a project-level and cross-functional Technical Lead. Technical Leads liaise with other application work package leads and provide high-level design oversight to ensure an optimal end-to-end solution is implemented.
At CIBC we enable the work environment most optimal for you to thrive in your role. To successfully perform the work, details on your work arrangement (proportion of on-site and remote work) will be discussed at the time of your interview.
How You'll Succeed
Application Development - You will code and configure solutions using multiple tools and technologies while meeting code quality targets for data programs, ETL pipelines, data transformations and other data engineering development tasks.
Time Management - You will plan and manage multiple, individual and/or team priorities to meet established timelines.
Requirement Analysis and Design - You will help translate Business Requirements into Solution Requirements and Technical design. This may include working directly with the Business to gain a complete understanding of their request to ensure the end solution meets their needs with minimal design defects.
Production Support – You will be taking part in day to day production support work and support business users if there are any production issues. You will work with application support teams to analyze log files and resolve the issues based on priority.
Who You Are
You can demonstrate 5+ years of experience in designing, developing, implementing and supporting complex projects building data engineering solutions including data processing, data warehousing, data mapping and transformations, other ETL processes and reporting applications is an asset
Strong Azure cloud development and design working knowledge on at least the below items:
Azure Network Security groups : To identify the NSG rules that are required to be allowed or denied
Azure monitor : To configure alerts on various metrics and analyze for troubleshooting
Azure data lake : Reading from and writing to from different sources using Azure SDK/APIs/configuration
Azure data factory : Pipelines, data sets, linked services, integrated with Self-hosted integration runtime, mapping, authoring and monitoring data flows
Azure SQL/Azure SQL MI: Azure SQL feature differences and SQL programming
Azure Function App: HTTP Triggered apps, Timer triggered apps
Azure Key Vault : Storing and retrieving secrets programmatically.
Azure App services: Web apps, API Apps, Frontend SPA apps
Strong knowledge in working with relational databases like Microsoft SQL Server, Oracle.
Writing and troubleshooting complex SQL queries and Stored Procedures is required
Working knowledge in partitioning, indexes, statistics, explain/execution plans, etc is a plus
Experience in creating Power BI Reports and analytics
Experience building and integrating with external systems using REST API connectors
Knowledge and experience of using GIT and Azure Devops
Production support is required for this role on need basis.
Good to Have :
Experience with any JavaScript framework
Experience with Change Data Capture(CDC) tools and how CDC work
Good knowledge working with message queue and stream processing systems
Working experience with Azure App service environment
Certification in Azure is an asset
API development experience
You embrace and champion change . You'll continuously evolve your thinking and the way you work in order to deliver your best.
You're driven by collective success. You know that collaboration can transform a good idea into a great one. You understand the power of an inclusive team that enjoys working together to bring a shared vision to life.
You're digitally savvy. You seek out innovative solutions and embrace evolving technologies. You can easily adapt to new tools and trends.
You understand that success is in the details. You notice things that others don't. Your critical thinking skills help to inform your decision making.
Values matter to you. You bring your real self to work and you live our values – trust, teamwork and accountability.
What CIBC Offers
At CIBC, your goals are a priority. We start with your strengths and ambitions as an employee and strive to create opportunities to tap into your potential. We aspire to give you a career, rather than just a paycheck.
We work to recognize you in meaningful, personalized ways including a competitive salary, incentive pay, banking benefits, a benefits program, defined benefit pension plan, an employee share purchase plan, a vacation offering, wellbeing support, and MomentMakers, our social, points-based recognition program.
Our spaces and technological toolkit will make it simple to bring together great minds to create innovative solutions that make a difference for our clients.
We cultivate a culture where you can express your ambition through initiatives like Purpose Day; a paid day off dedicated for you to use to invest in your growth and development.
*Subject to plan and program terms and conditions
What you need to know
CIBC is committed to creating an inclusive environment where all team members and clients feel like they belong. We seek applicants with a wide range of abilities and we provide an accessible candidate experience. If you need accommodation, please contact Mailbox.careers-carrieres@cibc.com
You need to be legally eligible to work at the location(s) specified above and, where applicable, must have a valid work or study permit.
We may ask you to complete an attribute-based assessment and other skills tests (such as simulation, coding, French proficiency, MS Office). Our goal for the application process is to get to know more about you, all that you have to offer, and give you the opportunity to learn more about us.
Job Location
Toronto-81 Bay, 11th Floor
Employment Type
Regular
Weekly Hours
37.5
Skills
Atlassian Confluence, GitHub, IBM WebSphere MQ, J2EE Platform, J2EE Web Services, Java, Java Enterprise Edition, JIRA Tool, Linux, Oracle, Software Development Life Cycle (SDLC), SWIFT Payments, Wire Transfer
At CIBC, we are in business to help our clients, employees and shareholders achieve what is important to them. Our ability to create value for all CIBC stakeholders is driven by a business culture based on common values: Trust, Teamwork and Accountability.
Working with CIBC makes you a part of a work environment committed to our clients, employees and communities - a place where you can excel.
Every day, our 44,000 employees help our clients achieve their financial goals, because what matters to our clients, matters to us.