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
You will be joining the Enterprise Technology team within CIBC. As the Senior Consultant, Data Architect/Modeller, you will be a senior individual contributor in the Strategic Solutions Design team, responsible for data modeling continuity across legacy data warehouses and Azure modernization streams. You will partner with Application Development (AD), business partners, and platform teams to ensure model decisions are accurate, auditable, and delivery-ready across Oracle/Netezza and ADLS/Databricks environments. You will help us modernize safely: preserving what works in on-prem delivery while building future-ready model and governance capabilities for Azure.
At CIBC we enable the work environment most optimal for you to thrive in your role. Details on your work arrangement (proportion of on-site and remote work) will be discussed at the time of your interview.
How you’ll Succeed
- Act as the model design authority for assigned risk and regulatory domains across on-prem and Azure platforms.
- Maintain and evolve conceptual, logical, and physical models for legacy warehouses to support ongoing releases.
- Define model contracts and modeling standards for Azure Bronze, Silver, and Gold layers.
- Collaborate with Application Development to ensure implementation aligns with model intent and control requirements.
- Define governance requirements for metadata, lineage, and classification in Unity Catalog for Azure streams.
- Define model-level quality and reconciliation rules for regulatory-critical datasets.
Who you are
- You can demonstrate 5+ years of strong experience in enterprise data modeling and data architecture across relational and analytical platforms, physical and logical modeling on Oracle and/or Netezza data warehouses, cloud lakehouse modeling using Databricks and Delta Lake, SQL and transformation design for risk and regulatory workloads, banking risk and regulatory data domains including auditability, traceability, and control requirements, cross-functional delivery with Application Development, business, and governance partners, and producing data modeling standards, design artifacts, and documentation in regulated delivery environments; nice to have: Unity Catalog governance including lineage, metadata management, and access control design, and familiarity with OSFI-regulated reporting data structures including BCAR and IFRS 9 domains.
- 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.
- You embrace and champion change. You'll continuously evolve your thinking and the way you work in order to deliver your best.
- You live your values. You bring high standards, genuine care to your relationships, and want to grow with an employer that shares your values and brings out your best.
#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, 15th Floor
Employment Type
Regular
Weekly Hours
37.5
Skills
Business Requirements, Business Technology Strategy, Change Management, Data Governance, Data Management, Data Model Design, Data Modeling, Digital Technology Strategy, Enterprise Risk Management (ERM), Enterprise Technologies, IT Modernization, Microsoft Azure Databricks, Technical Leadership, Technology Strategy Development, Technology Strategy Planning, Work Collaboratively