Sr. Consultant, Data Developer

CIBC; Toronto; Hybrid; CAD 140,000 - 180,000; Full time

Benefits offered by this job

Competitive salary

Pension plan

Employee share purchase plan

Vacation offering

Wellbeing support

Job summary

CIBC is seeking a Sr. Consultant, Data Developer to lead end-to-end data solutions for CAM, spanning ETL, ODS, and large migrations in a Azure-centric SaaS/PaaS ecosystem. You will set technical direction, own data layer design, and partner with architecture and vendors.

You will drive delivery, ensure code quality, and mentor teams while balancing security, risk and cost considerations in a hybrid on-site/remote setup.

Qualifications

• Experience leading design, development, testing and implementation of enterprise-scale data solutions in financial services.
• Strong track record as technical owner on multi-vendor programs with metadata-driven data pipelines.
• Experience with data migration, data quality controls and CI/CD in a Azure-based environment.

Responsibilities

• Define and own target-state data architecture and engineering standards.
• Lead development of high-volume ETL pipelines and an operational data store.
• Own data migration strategy, including mapping, profiling and cutover activities.
• Provide technical leadership to developers and contract resources.
• Collaborate with enterprise architecture, data governance and information security.

Skills

Technical leadership

Data architecture

Cross-functional collaboration

Tools

Azure

Databricks

Azure Data Factory

Python

Spark

SQLMI

GitHub / DevOps

Azure Fabric

Job description

What you\'ll be doing

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

As a Sr. Consultant, Data Developer, you\’ll be a senior technical leader in CAM\’s technology transformation, modernizing the collections, recovery and insolvency platforms that support CIBC Retail, Small Business and Simplii clients. You\’ll own the end-to-end data solution for CAM, setting the technical direction and leading the design, development, testing and implementation of the CAM data layer, including ETL pipelines, an operational data store (ODS) and large-scale data migration. You\’ll do this across a cross-functional, multi-platform, multi-vendor SaaS/PaaS ecosystem built on Microsoft Azure, Databricks, Python, Azure Data Factory and DevOps (GitHub), and you\’ll act as the key technical point of contact for business partners, architecture and vendors. At CIBC we enable the work environment most optimal for you to thrive in your role. Details on your work arrangement (proportion of on-s\'ite and remote work) will be discussed at the time of your interview.

How you\'ll succeed

• Technical direction and architecture: Define and own the target-state data architecture, design patterns and engineering standards for the CAM data layer. Partner with Enterprise Architecture, Data Governance and Information Security to secure design approvals and make sound trade-off decisions on scalability, resilience, cost and risk.


• Engineering delivery: Lead and contribute to the development of complex, high-volume data engineering solutions, including metadata-driven ETL pipelines that transform inbound product partner files into vendor-standard formats. Set code quality, testing, performance tuning and CI/CD standards, and remain hands-on for the most critical components.


• Product ownership: Act as the accountable technical owner for CAM data applications, driving the roadmap, delivery planning, estimates, production stability and continuous improvement, and representing the platform in governance and steering forums.


• Systems integration and vendor oversight: Lead the technical design and integration of cross-functional, multi-platform systems, including batch file and API integrations between CIBC host systems, the CAM data layer and external vendors. Hold vendors accountable to technical requirements, SLAs and delivery commitments.


• Data migration and quality: Own the data migration strategy and approach, including mapping, profiling, transformation, reconciliation, mock conversions, cutover and post-implementation verification, and define data quality controls and sign-off criteria.


• Stakeholder leadership: Influence CAM business partners, technology lines of business, business systems analysts, QA, vendors, Information Security and governance teams. Translate business needs into technical solutions, proactively raise risks, issues and dependencies, and drive decisions to meet risk and compliance standards.


• Team leadership and mentorship: Provide technical leadership to developers and contract resources, assign and review work, conduct code reviews, coach team members, and lead production readiness, incident resolution and Day 2 operations.

Who you are

• You can demonstrate experience in: leading the design, development, testing, and implementation of enterprise-scale data solutions in financial services using Microsoft Azure Products, Databricks, Azure Data Factory, Python, Spark, SQLMI and Azure Fabric implementations.


• You have a proven track record of acting as technical lead or solution owner on complex, multi-vendor programs, building and orchestrating metadata-driven data pipelines, Bronze/Silver/Gold data lake patterns, operational data stores, and DevOps-based CI/CD deployment. Experience leading large-scale data migrations and with collections, recovery or lending data and vendor-hosted SaaS platforms is a major asset.


• You have experience with: Oracle RDBMS, ETL tools, REST APIs, SFTP/batch file integrations, Tableau, Alteryx, workload automation / job scheduling tools (e.g., Autosys), ServiceNow, Jira, Confluence, and/or other build & deploy tools, along with experience on Windows and Unix platforms.


• You embrace and champion change. You\'ll continuously evolve your thinking and the way you work in order to deliver your best.


• Your influence makes an impact. You know that relationships and networks are essential to success.


• You inspire outcomes by making yourself heard. You\'re driven by collective success.


• You know that collaboration can transform a good idea into a great one.


• You understand the power of an inclusive team that enjoys working together to create a shared vision.


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

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 [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). 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.

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.