Consultant, Application Development

CIBC • Toronto, ON

2d • Hybrid

About The Position

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.

Requirements

• Experience in Oracle SQL stored procedures and ETL development and automation
• Ability to create/update schemas, tables, views, triggers, and functions
• Ability to execute processes with dynamic conditions
• Ability to work interchangeably in waterfall and agile environments

Nice To Haves

• Development expertise in Alteryx, Tableau, Essbase, and Power BI
• VBA (Excel, MS Access advanced/automated macros)
• Advanced SAS including automated reporting

Responsibilities

• 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.
• 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.
• 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.

Benefits

• competitive salary
• incentive pay
• banking benefits
• a benefits program
• defined benefit pension plan
• an employee share purchase plan
• a vacation offering
• wellbeing support
• MomentMakers, our social, points-based recognition program
• Purpose Day; a paid day off dedicated for you to use to invest in your growth and development

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed