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

Job Description

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. You 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. Additionally, 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 is required. As a part of your role, you work with other members of the project team to support delivery of additional project components (API interfaces, Search), evaluate 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. You 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 and interface with business partners to understand requirements and present solutions within the capabilities of the enterprise. The Senior Data Engineer, also collaborates directly with stakeholders, end-users, Product Owners, Business Analysts, and functional partners – Data, Information Security, Identity Management, Compliance, Legal, and Risk and develops proofs of concept (PoC) as needed to evaluate product and technical strategies, while owning technical and functional specifications as needed

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 2 days per week on-site at our Chicago office, while other days may be remote.

How you’ll succeed

• Programming Skills - Develop, code and test end-to-end stack of applications. Review, analyze, and modify programming systems, including coding, testing, and debugging.

• Systems Implementation - Participate and conduct technical design, development, and integration of cross functional, multi-platform application systems.

• Troubleshooting  and Technical Skills – Work closely with key business and technology partners to ensure that business and client impact issues are well understood and addressed. Ensure adherence to all regulatory and information