Consultant, Application Development at CIBC in Toronto, Ontario, CA

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

What You’ll Be Doing

The Consultant, Application Development will be accountable for leading the functional design of measurement datasets tracking financial and non-financial key performance indicators, and for the application development in Oracle SQL, Alteryx and SAS of automated reporting solutions and analytics initiatives. The role will also provide ad-hoc second level support for data inquiries and production incidents from business and technology partners in the Personal & Business Banking Performance Management portfolio within Finance. In addition, the role provides consultation for senior management on a wide spectrum of existing and emerging technologies, comprehensive senior level technical expertise to other team members, and technical decisions that are often made in situations where business requirements might not be completely defined.

At CIBC we enable the work environment most optimal for you to thrive in your role. You’ll have the flexibility to manage your work activities within a hybrid work arrangement where you’ll spend 1-3 days per week on-site, while other days will be remote.

How You’ll Succeed

• Data and Analytics Solution Design and Development – consulting with peers, business systems analysts, business stakeholders and technology partners, translate user requirements to process and data models, create the solution design of data management systems, and provide technical leadership to develop solutions with far-reaching impact. Develop the code and automation of ETL and production processes, and perform maintenance and provide support of existing systems. Support the design rationale based on requirements analysis and  peer discussion; provide design walkthroughs to the team; document the code for existing and new applications; and perform unit testing.
• Data Quality and Integrity – partner with team members and business peers to provide input and support for quality assurance phases; provide first and second level support and fix variances as required, and document the resolution following internal guidelines.
• Business and Technology Partnership – interact with business and technology partners for clarification of business needs, and work with the intake management team to ensure clear, concise, and complete documentation for ongoing support.

Who You Are

• You can demonstrate experience in Oracle SQL stored procedures and ETL development and automation, ability to create/update schemas, tables, views, triggers, and functions, and execute processes with dynamic conditions. It’s an asset if you have development expertise in Alteryx, Tableau, Essbase, and Power BI, and VBA (Excel, MS Access advanced/automated macros), advanced SAS including automated reporting, and you have an ability to work interchangeably in waterfall and agile environments.
• You give meaning to data. You enjoy investigating complex problems and making sense of information. You're confident in your ability to communicate detailed information in an impactful way.
• You're digitally savvy. You seek out innovative solutions and embrace evolving technologies. You can easily adapt to new tools and trends.
• You love to learn. You're passionate about growing your knowledge, and you know that there is no limit to what you can achieve.
• You act like an owner. You thrive when you're empowered to take the lead, go above and beyond, and deliver results.
• Values matter to you. You bring your real self to work, and you live our values – trust, teamwork and accountability.

#LI-TA

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

• CIBC is committed to clarity in our hiring process. All roles posted are opportunities we’re actively recruiting for, unless stated otherwise.

• 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 test (such as simulation, coding, French proficiency).

• We use artificial intelligence tools during the recruitment process. 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, 26th Floor

Employment Type

Regular

Weekly Hours

37.5

Skills

Analytical Thinking, Business Effectiveness, Client Service, Communication, Detail-Oriented, Process Improvements, Relationship Management, Teamwork