Analysis & Consulting - Data and Reporting Analyst - Expert

Position Title: Sr. Data Analyst

Duration: 12 months

Possibility of extension: Yes

Working Hours: 8-4pm or 9-5pm

Working Location: Chicago (320 S Canal St) - Hybrid (1-2 days in office, flexible but HM in Mondays/Wednesdays)

Join our team in the vibrant city of Chicago, where you will have the opportunity to work in a dynamic hybrid environment, combining both in-office and remote work for a balanced lifestyle. Chicago offers a rich cultural scene, diverse culinary experiences, and numerous opportunities for professional growth.

Role Mandate

The selected candidate will be supporting the data analysis and data clean-up needs for the North American Commercial Bank, the US Emerging Middle Market (EMM), US Lower Middle Market (LMM), and the Canadian Mid Market (MM). They will work to support a data cleanup project in the initial stages brought about by the BOTW merge. The selected candidate will have a previous background in data clean-up and data migration projects, strong critical thinking skills, and previous banking experience.

Role Responsibilities Include (but are not limited to):

• Review duplicated data sources and cleanse based on given protocols.
• Breaks down strategic problems, and analyses data and information to provide insights and recommendations.
• Provides value through insights, reporting and data visualization techniques. Selects, configures and implements analytics solutions for consistency and repeatability.
• Researches and applies continuous improvement in datasets by identifying trends and patterns to transform raw data into actionable business insights.
• Exercises judgment to identify, diagnose, and solve problems within given rules.
• Works independently and regularly handles non-routine situations.
• Broader work or accountabilities may be assigned as needed.
  
  

Must-Have Skills:

• 5 yrs Data Analytics experience
• Relevant post-secondary degree preferred
• Previous experience with data clean-up/data migration projects
• Intermediate Programming, Query, Modeling and Analytical Tool skills (SQL)
• Comfortable in a fast-paced and ambiguous environment, and is a quick learner
• Ability to work independently with limited supervision
• Strong relationship-building and cross-functional collaboration skills
• Excellent critical thinking/analytical/problem solving and organizational skills; ability to analyze issues/requests and determine next steps
• General understanding of data and how it’s used to inform business decisions; data-driven decision-making
• Python/SAS a nice to have
• Power BI a nice to have
• Previous banking experience required and former employee an asset
• Background in Lending or Operations an asset.
  
  

Interview Process:

First Round - 45min Teams meeting with HM

Interview format will consist of behavioral/situational and getting to know you type questions.