CIBC is looking to build a relationship-oriented bank for the modern world and needs a Senior Data Engineer to work on the detailed technical design and development of applications using various technology platforms to support the company's data strategy.
Requirements
- Proficiency in the Data technology stack, including ETL, Azure SQL and REST APIs
- Expertise in designing and deploying data applications on cloud solutions, such as Azure or AWS
- Hands on experience in performance tuning and optimizing code running in DataBricks, Talend or similar ETL tools
- Proficient in programming languages like PySpark and Python
- Solid understanding of SQL, T-SQL and/or PL/SQL
- Hands on experience designing and delivering solutions using the Azure Data Analytics platform (Cortana Intelligence Platform) including Azure Storage, Azure SQL Data Warehouse, Azure Data Lake, Azure Cosmos DB, Azure Stream Analytics
- Exposure to Integration and BI Tools such as Tableau, Cognos or Power BI
Responsibilities
- 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
- Develop scalable and re-usable frameworks for ingesting of data sets
- Integrate 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
Other
- Degree/diploma in Computer Science, Engineering, Management Information Systems, or a related field of study
- 5+ years of experience as a Development Lead on Data Applications
- Ability to work in a hybrid work arrangement with 2 days per week on-site at the Chicago office
- No visa sponsorship offered
- Must be legally eligible to work at the location(s) specified
