Data Analyst

Were building a relationship-oriented bank for the modern world. We need talented passionate professionals who are dedicated to doing whats 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

What youll be doing

CIBC Bank USA seeks a Data Analyst to validate complex data mapping and transformation logic for financial applications and systems. Drive implementation and performance of analytical models across development testing UAT and production environments. Develop and implement advanced SQL queries and PySpark automation scripts to extract transform and validate raw data from diverse source systems. Design and implement advanced transactional models using banking data to assess credit risk optimize asset-liability management and support regulatory reporting. Translate business requirements into actionable modeling solutions deliver insights for executive decision-making and ensure all outputs meet compliance and audit standards. Participate in stress testing and scenario analysis to enhance financial performance and risk management. Convert raw operational data into dimensional models and data marts to support analytical reporting and business intelligence initiatives. #LI-DNI

Position requires a Bachelors degree in Computer Science Electronics Engineering Management Information Systems or a related STEM field followed by 5 years of progressively responsible experience with executing complex data analysis projects in a financial industry setting. Experience must include a minimum of: 5 years of experience with entity-relationship diagrams dimensional schema designs and conceptual logical and physical data modeling; 5 years of experience with advanced SQL queries; 3 years of experience with data lineage analysis; 3 years of experience with Python; 3 years of experience with SQL server; 3 years of experience with advanced formulas pivot tables and data visualization in Excel; and 2 years of experience with statistical analysis. Part-time telecommuting benefit available.

Job location: Chicago IL. RATE OF PAY: $160555.00 - $166300.00 per year. To apply please visit and enter Job Requisition ID ***Data Analyst ***. Alternatively please send your resume cover letter and a copy of the ad to: CIBC Attn.: H. Lazzaro 300 Madison Avenue New York NY 10017.

At CIBC your goals are a priority. We start with your strengths ambitions and strive to create opportunities to tap into your potential.

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

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

Expected End Date

Job Location

Employment Type

Weekly Hours

Skills