Senior Application Consultant - Azure Data Engineer

We are creating a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing right by our clients. At CIBC, we value your strengths and ambitions, allowing you to feel empowered at work. Our team members have what they need to make a meaningful impact and are genuinely valued for who they are and what they contribute. To learn more about CIBC, please visit CIBC.com. What You'll Be Doing: You'll join CIBC's Commercial Banking and Payments Technology, Smart Investigate application team. You'll be responsible for the design, development, and integration testing in support of various scale projects. You'll also provide production support when needed. Occasionally, you'll 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 oversee high-level design to ensure an optimal end-to-end solution is implemented. At CIBC, we enable an optimal work environment for you to excel in your role. The details of your work arrangement (proportion of on-site and remote work) will be discussed during your interview. How You'll Succeed: - Application Development: You will code and configure solutions using multiple tools and technologies, meeting code quality targets for data programs, ETL pipelines, data transformations, and other data engineering tasks. - Time Management: You will plan and manage multiple, individual, and/or team priorities to meet established timelines. - Requirement Analysis and Design: You'll help translate Business Requirements into Solution Requirements and Technical design, sometimes working directly with the Business to ensure the end solution meets their needs with minimal design defects. - Production Support: You'll participate in daily production support work and help business users with any production issues. You'll work with application support teams to analyze log files and resolve issues based on priority. Who You Are: - You can demonstrate over 5 years of experience in designing, developing, implementing, and supporting complex projects building data engineering solutions. - You have strong hands-on programming knowledge in Java/Object Oriented programming. - You have strong knowledge of working with relational databases like Microsoft SQL Server, Oracle. - You can write and troubleshoot complex SQL queries and Stored Procedures. - You have a working knowledge of partitioning, indexes, statistics, explain/execution plans, etc. - You're familiar with the Azure Portal and using different types of Azure Resources. - You have experience creating Power BI Reports and analytics. - You have experience building and integrating with external systems using REST API connectors. - You have knowledge and experience of using GIT and Azure Devops. - You're required to support production for this role. Good to Have: - Experience with any JavaScript framework. - Experience with Change Data Capture(CDC) tools and knowledge of how CDC works. - Good knowledge of working with message queue and stream processing systems. - Experience with Azure App service environment. - Azure certification is an asset. - API development experience. What CIBC offers: At CIBC, your goals are our priority. We value your strengths and ambitions as an employee and strive to create opportunities for you to realize your potential. We aim to give you a career, not just a paycheck. Location: Toronto-81 Bay, 11th Floor Employment Type: Regular Weekly Hours: 37.5 Skills Required: 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 Payments.