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
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 Bachelor’s 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: $160,555.00 - $166,300.00 per year. To apply, please visit https://www.cibc.com/en/about-cibc/careers.html and enter Job Requisition ID ***2612718 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 [email protected]
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
2026-08-28Job Location
IL-70 W Madison St, 8th FlEmployment Type
RegularWeekly Hours
40Skills
Agile Thinking, Business Requirements Analysis, Communication, Critical Thinking, Domain Knowledge, Operational Efficiency, Problem Solving, Process Design, Python (Programming Language)Skills Required
- Bachelor's degree in Computer Science, Electronics Engineering, Management Information Systems, or related STEM field
- 5 years progressively responsible experience executing complex data analysis projects in a financial industry setting
- 5 years experience with entity-relationship diagrams, dimensional schema designs, and conceptual, logical, and physical data modeling
- 5 years experience with advanced SQL queries
- 3 years experience with data lineage analysis
- 3 years experience with Python
- 3 years experience with SQL Server
- 3 years experience with advanced formulas, pivot tables, and data visualization in Excel
- 2 years experience with statistical analysis
- Experience designing and implementing advanced transactional models using banking data for credit risk, ALM, and regulatory reporting
What We Do
CIBC is here to help all our clients reach their goals. We know the importance of reliable financial products and services, and we’re dedicated to providing them in a way that lets you bank however you want, whenever you want. With innovative tools designed around your priorities and a team fully focused on your success, you’ll get the insights you need to get even closer to achieving your goals. This culture of innovation and shared values of trust, teamwork and accountability are why we’ve been named a top employer in Canada. They’re also why a career at CIBC is more than a job—it’s an opportunity to grow and work alongside some of the brightest in Canada. La Banque CIBC est là pour aider tous nos clients à atteindre leurs objectifs. Nous connaissons l'importance de produits et services financiers fiables, et nous nous engageons à les fournir d'une manière qui vous permette d'effectuer vos opérations bancaires comme vous le souhaitez, quand vous le souhaitez. Avec des outils innovants conçus autour de vos priorités et une équipe entièrement centrée sur votre réussite, vous obtiendrez les informations dont vous avez besoin pour vous rapprocher encore plus de vos objectifs. Cette culture de l'innovation et les valeurs partagées de confiance, de travail d'équipe et de responsabilité sont la raison pour laquelle nous avons été nommés l'un des meilleurs employeurs au Canada. C'est aussi pourquoi une carrière à la Banque CIBC est plus qu'un emploi : c'est une occasion de grandir et de travailler aux côtés de certaines des personnes plus brillantes au Canada
