Were building a relationship-oriented bank for the modern world. We need talented passionate professionals who are dedicated to doing whats 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
What Youll Be Doing
Youll be joining CIBCsCommercial Banking and Payments Technology Global Wires and Payments Department. You will be part of Wires- Operational Data Store application. Youllwill 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 addition you will sometimes act as an application specificwork 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 Youll 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.
- 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 workand 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 7 years of experience in designing developing and maintaining scalable and secure SQL database solutions on the Microsoft Azure platform. This role requires strong expertise in Azure SQL Database data integration and performance optimization to support business-critical applications and analytics. Design develop and maintain SQL Server databases including tables views indexes and stored procedures. Write optimize and troubleshoot complex SQL queries for data extraction transformation and reporting. Develop and manage ETL processes using Azure Data Factory and related Azure services. Integrate Azure SQL Databases with other Azure resources (e.g. Data Lake Event Hub Key Vault) and external systems. Collaborate withapplication developers and business analysts to translate business requirements into technical solutions. Monitor and tune database performance including query optimization and resource management. Ensure data integrity and security by implementing best practices for database design and access controls. Support production environments including incidentresolution root cause analysis and performance troubleshooting. Document database structures processes and procedures for ongoing maintenance and knowledge sharing. Participate in code reviews and contribute to continuous improvement of database development standards and practices. Work with cloud-based data solutions (such as Azure SQL Database and SQL Managed Instance) as required.
- You embrace and champion change. Youll continuously evolve your thinking and the way you work in order to deliver your best.
- Youre 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.
- Youre 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 dont. 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 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
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 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
Primary Recruiter
Anju Rani
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
Required Experience:
Senior IC