Senior Data Modeler & ETL Developer

CIBC; Toronto; Hybrid; CAD 104,000 - 114,000; Full time

Job summary

CIBC is seeking a Senior Data Modeler & ETL Developer to join their Capital Markets Technology group. The role involves developing database models, performing ETL processes, and providing strategic planning in alignment with the bank’s objectives. Ideal candidates will have significant experience with ETL tools, database management, and data modeling practices.

Benefits

Competitive salary

Employee share purchase plan

Defined benefit pension plan

Vacation offering

Wellbeing support

Qualifications

• 4+ years of experience with ETL tools and database management systems.
• Hands-on experience with Oracle, Postgres, and SQL Server.
• Experience in conceptual modeling and build automation is an asset.

Responsibilities

• Develop physical database models for database management systems.
• Coordinate database modeling and manage ETL processes.
• Lead strategic planning and stakeholder interactions for projects.

Skills

Data Modeling

ETL Development

Database Management

Tools

Informatica

Azure Data Factory

Databricks

Oracle

Postgres

Job description

Join to apply for the Senior Data Modeler & ETL Developer role at CIBC

Join to apply for the Senior Data Modeler & ETL Developer role at CIBC

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’ll be joining CIBC’s Capital Markets Technology group within Credit Adjudication Technology team. As a Sr Data Modeler & ETL Developer you will be responsible for developing physical database models for database management systems, providing subject matter expertise in production and non-production databases for data development and maintenance. The role works on complex issues involving one or more technical areas, mentoring employees in database development and ensuring consistency and integration with existing database infrastructure.

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-2 day per week on-site, while other days will be remote.

How You’ll Succeed

• Data Modeling– You give meaning to data! With very good technical skills, you will perform and coordinate complex database modeling in Oracle and Postgres databases. Design the application's data infrastructure using data modeling tools, utilities, and testing approaches. Lead the design, development & management of cost-effective and innovative solutions.
• ETL Development- Engage in designing and developing ETL processes using tools like Informatica, ADF, Databricks. Work on assigned tasks individually including database management, performance monitoring, troubleshooting, documentation and collaboration
• Strategic Planning - Develop multi-year technology roadmaps that align with the bank’s vision, strategy, and business objectives. Lead multiple complex projects involving backend systems, new technology, and the enhancement of existing applications. Effectively interact with stakeholders, end users, business analysts, and technical resources to gather requirements, prepare design specifications, and provide technical support for applications, as instructed by senior team members.
• Leadership Skills - Act as the database and ETL consultant and run discussions with the wider team to ensure the project is on track to meet objectives. Support and mentor intermediate and senior peers by sharing knowledge, collaborating and problem solving
  
  

Who You Are

• You can demonstrate experience with at least 4 years with: ETL Tools: Informatica, Azure data Factory and Data Bricks. At least 4 years with Oracle, PostGres and/or SQL Server. You have hands on experience with Conceptual Modeling: Develop conceptual models that represent the data requirements at a high level. Strong Asset if you have experience with Build Automation.
• You give meaning to data. You enjoy investigating complex problems, and making sense of information. You're confident in your ability to communicate detailed information in an impactful way.
• You're digitally savvy. You seek out innovative solutions and embrace evolving technologies. You can easily adapt to new tools and trends.
• You love to learn. You're passionate about growing your knowledge, and you know that there is no limit to what you can achieve.
• Values matter to you. You bring your real self to work and you live our values - trust, teamwork, and accountability.
  
  

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]
• 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 tests (such as simulation, coding, French proficiency, MS Office). 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, 23rd Floor

Employment Type

Regular

Weekly Hours

37.5

Skills

Azure Data Factory, Azure Devops, Database Development, Database Management Systems (DBMS), Database Modeling, Databricks Platform, Informatica Administration, Informatica Development, Informatica PowerCenter, Oracle, Oracle Management, PostgreSQL, PostgreSQL Administration

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Banking

Referrals increase your chances of interviewing at CIBC by 2x

Get notified about new Data Modeler jobs in Toronto, Ontario, Canada.

Data Quality Analyst (Fraud Investigation)

Data Labeling Associate - 6 Month Contract

Part-time Data Quality Analyst (Fraud Investigation)

Toronto, Ontario, Canada CA$104,000.00-CA$114,000.00 15 hours ago

Sr. Meter Data Management Analyst (1-Year Contract)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.