Senior Data Engineer

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

As a member of the U.S. Data Strategy team, you’ll work in a fast-paced environment where you will be responsible for the detailed technical design and development of applications using various technology platforms. The role performs tasks of technical depth and breadth, utilizing a solid understanding of business dynamics to conduct impact analysis and provide feedback on problems with recommended solutions. The Data Engineer determines methods and approaches to projects, transforming business requirements specifications into programming instructions, designing, coding and testing programs. In addition, the role plays a key role in the development and implementation of database management solutions, supporting the company’s backup plans. The role uses judgement and autonomy on day to day tasks, exercising considerable latitude to conduct data source analysis and negotiate with users regarding requirements.

• Configure and Develop custom ETL Solutions to ingest data into Azure SQL Data Warehouse.

• Code data quality and transformation logic for data movement within data warehouse

• Develop code to publish data from data warehouse to data mart for consumption by applications or BI tools

• Design and develop SQL Server data objects including tables, schemas, views, functions and stored procedures

• Designing and implementing data ingestion pipelines from multiple sources using Azure DataBricks Apache Spark and/or Azure DataBricks

• Developing scalable and re-usable frameworks for ingesting of data sets

• Integrating the end to end data pipeline - to take data from source systems to target data repositories ensuring the quality and consistency of data is maintained at all times

• Working with event based / streaming technologies to ingest and process data

• Working with other members of the project team to support delivery of additional project components (API interfaces, Search)

• Evaluating the performance and applicability of multiple tools against customer requirements

• Document and maintain data lineage

• Validate application code against unit and security tests, along with entitlement models

• Work with Technical experts at the platform and enterprise levels to define custom and integrated software solutions

• Work in an agile SDLC and contribute from discovery to delivery of a feature

• Interface with business partners to understand requirements and present solutions within the capabilities of the enterprise

• Collaborate directly with stakeholders, end-users, Product Owners, Business Analysts, and functional partners – Data, Information Security, Identity Management, Compliance, Legal, and Risk

• Develop proofs of concept (