Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

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.

Responsibilities

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

Requirements

• Bachelor’s degree in Computer Science, Electronics Engineering, Management Information Systems, or a related STEM field.
• 5 years of progressively responsible experience with executing complex data analysis projects in a financial industry setting.
• 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.
• 2 years of experience with statistical analysis.
• Must be legally eligible to work at the specified location(s).
• May be required to complete an attribute-based assessment and other skills tests (such as simulation, coding, MS Office).

Skills

• Agile Thinking
• Business Requirements Analysis
• Communication
• Critical Thinking
• Domain Knowledge
• Operational Efficiency
• Problem Solving
• Process Design
• Python (Programming Language)
• Advanced SQL queries
• PySpark automation scripts
• Statistical analysis
• Excel (advanced formulas, pivot tables, data visualization)

Location

• Chicago, IL
• 70 W Madison St, 8th Fl

Work Type

• Part-time telecommuting benefit available
• Regular
• 40 hours per week

Experience Level

• 5 years of progressively responsible experience

Education Level

• Bachelor’s degree in Computer Science, Electronics Engineering, Management Information Systems, or a related STEM field

Salary/Compensations

• $160,555.00 - $166,300.00 per year

Benefits

• Part-time telecommuting benefit available

About the Company

• We’re building a relationship-oriented bank for the modern world.
• 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.
• At CIBC, your goals are a priority.
• We start with your strengths, ambitions and strive to create opportunities to tap into your potential.
• 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.
• At CIBC, we are in business to help our clients, employees and shareholders achieve what is important to them.
• Our ability to create value for all CIBC stakeholders is driven by a business culture based on common values: Trust, Teamwork and Accountability.
• Working with CIBC makes you a part of a work environment committed to our clients, employees and communities - a place where you can excel.
• Every day, our 48,000 employees help our clients achieve their financial goals, because what matters to our clients, matters to us.

Equal Opportunity

• 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 Mailbox.careers-carrieres@cibc.com