Senior Consultant, Data Architect/Modeller

Posted 5 Hours Ago
Be an Early Applicant
Toronto, ON, CAN
In-Office
Senior level
Fintech • Payments • Financial Services
The Role
Own data modeling continuity across legacy Oracle/Netezza warehouses and Azure modernization streams. Define conceptual, logical, and physical models; establish Azure Bronze, Silver, and Gold modeling standards; collaborate with application, business, and platform teams; and govern metadata, lineage, classification, quality, and reconciliation rules for risk and regulatory datasets.
Summary Generated by Built In

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 [email protected]

  • 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

Skills Required

  • 5+ years of experience in enterprise data modeling and data architecture
  • Experience with 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
  • Experience with banking risk and regulatory data domains, including auditability, traceability, and control requirements
  • Cross-functional delivery with Application Development, business, and governance partners
  • Experience producing data modeling standards, design artifacts, and documentation in regulated delivery environments
  • Unity Catalog governance experience, including lineage, metadata management, and access control design
  • Familiarity with OSFI-regulated reporting data structures, including BCAR and IFRS 9 domains
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Toronto, Ontario
43,351 Employees

What We Do

CIBC is here to help all our clients reach their goals. We know the importance of reliable financial products and services, and we’re dedicated to providing them in a way that lets you bank however you want, whenever you want. With innovative tools designed around your priorities and a team fully focused on your success, you’ll get the insights you need to get even closer to achieving your goals. This culture of innovation and shared values of trust, teamwork and accountability are why we’ve been named a top employer in Canada. They’re also why a career at CIBC is more than a job—it’s an opportunity to grow and work alongside some of the brightest in Canada. La Banque CIBC est là pour aider tous nos clients à atteindre leurs objectifs. Nous connaissons l'importance de produits et services financiers fiables, et nous nous engageons à les fournir d'une manière qui vous permette d'effectuer vos opérations bancaires comme vous le souhaitez, quand vous le souhaitez. Avec des outils innovants conçus autour de vos priorités et une équipe entièrement centrée sur votre réussite, vous obtiendrez les informations dont vous avez besoin pour vous rapprocher encore plus de vos objectifs. Cette culture de l'innovation et les valeurs partagées de confiance, de travail d'équipe et de responsabilité sont la raison pour laquelle nous avons été nommés l'un des meilleurs employeurs au Canada. C'est aussi pourquoi une carrière à la Banque CIBC est plus qu'un emploi : c'est une occasion de grandir et de travailler aux côtés de certaines des personnes plus brillantes au Canada

Similar Jobs

Mondelēz International Logo Mondelēz International

Project Engineer

Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Remote or Hybrid
East York, ON, CAN
90000 Employees
85K-106K Annually

Ericsson Logo Ericsson

Cloud Native Test FW SW Developer

Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
In-Office
Ottawa, ON, CAN
88000 Employees
102K-133K Annually

Ericsson Logo Ericsson

AI System Developer

Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
In-Office
Ottawa, ON, CAN
88000 Employees
85K-111K Annually

Mastercard Logo Mastercard

Manager, Legal Compliance

Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Hybrid
Toronto, ON, CAN
38800 Employees

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Artificial Intelligence • Fintech • Software
New York, New York
9 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
85 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account