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, Global Wires and Payments Department. You will be part of Wires- Operational Data Store 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 intervie_ w. **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. + **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 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 with application 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 incident resolution, 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** . 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 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, 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 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.