Sr. Consultant, Solution Design

CIBC; Toronto; On-site; CAD 110,000 - 170,000; Full time

Benefits offered by this job

Competitive salary

Incentive pay

Banking benefits

Benefits program

Defined benefit pension plan

Employee share purchase plan

Vacation offering

Wellbeing support

MomentMakers

Job summary

CIBC in Canada is seeking a Senior Data & Solution Architect to design and drive complex data platform initiatives. You will translate regulatory and business requirements into scalable designs, lead data integrity efforts, and mentor junior designers and developers.

You will collaborate with project teams, compliance partners, and oversight functions to ensure alignment with the technology roadmap and risk controls.

Qualifications

• 8–10 years of database technology experience (Oracle and SQL).
• Strong knowledge of ETL/data tools (Apache Spark).
• Databricks and Azure expertise required.

Responsibilities

• Coordinate and perform complex solution design activities across the EAML data and application platform.
• Lead audit-ready solutions ensuring data integrity, lineage, and traceability.
• Interface with project teams, compliance partners, and oversight functions; mentor junior designers and developers.

Skills

Oracle

SQL

ETL Tools

Apache Spark

Databricks

Microsoft Azure

Tools

Databricks

Azure Data Factory

Job description

* **Strategic Design & Execution -** Coordinate and perform complex solution design activities across the EAML data and application platform, translating business and regulatory requirements into system and application designs aligned with our technology roadmap.* **Regulatory & Data Integrity Leadership -** Lead the creation of audit-ready solutions that meet business objectives and rigorous data integrity, lineage, and traceability standards, championing control and quality across every artifact.* **Stakeholder Management -** Act as the solution lead by interfacing with project teams, compliance partners, and oversight functions, ensuring alignment with business requirements and mentoring junior designers and developers through collaboration and knowledge sharing.* **You're goal oriented.** You're motivated by accomplishing your goals and delivering your best to make a difference.* **You're passionate about people.** You find meaning in relationships and surround yourself with a diverse network of partners. You connect with others through respect and authenticity.* **You love to learn.** You're passionate about growing your knowledge. You have a strong sense of curiosity.* **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- **You demonstrate experience.** You have **8-10 years of experience** in database technology such as **Oracle and SQL.** Strong knowledge ETL Data tools (**Apache Spark)**. Knowledge in Databricks is necessary as well. Strong knowledge in **Microsoft Azure** is necessary for this role as well.* 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.* 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 [e-mail]* 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).At CIBC, we are in business to help our clients, employees and shareholders achieve what is important to them. Our ability to create value for all CIBC stakeholders is driven by a business culture based on common values: Trust, Teamwork and Accountability.Working with CIBC makes you a part of a work environment committed to our clients, employees and communities - a place where you can excel.Every day, our 48,000 employees help our clients achieve their financial goals, because what matters to our clients, matters to us.