Overview
This role involves advanced business intelligence and quantitative analysis to support reporting, monitoring, and insights related to portfolio credit quality, operations, and performance. Responsibilities include building dashboards, conducting descriptive and predictive analytics on large datasets, and translating business questions into actionable reporting and decision-support tools.
Responsibilities
- Develop and publish complex reports using Power BI Desktop.
- Create and deliver comprehensive reporting and monitoring of the portfolio’s credit quality, operations, and performance.
- Design and perform analysis using programming of data and/or statistical software to identify and understand new credit risk trends.
- Conduct quantitative analysis that supports improvements to credit strategy and policy.
- Provide data, reporting, and analysis to support the Indirect business as needed.
- Proactively identify opportunities to improve data and automate analytic processes.
- Use descriptive and predictive analytics techniques to analyze large datasets and generate insights and recommendations.
- Design dashboards and analyses, selecting appropriate visualization and analytics tools.
- Identify trends and patterns to address business questions and provide insights through reporting and data visualization.
- Partner with other data and analytics professionals to optimize, refine, automate, and scale analysis into repeatable analytics solutions and decision-support tools.
- Build reporting dashboards using appropriate data extraction, data cleaning, and data visualization techniques.
- Select, configure, and implement analytics solutions to support consistency and repeatability.
- Drive continuous improvement in data visualization by transforming raw data into actionable business insights.
- Work with teams, management, and stakeholders to improve the usability and visual quality of deployed analytics solutions.
- Translate business needs into technical specifications and evaluate existing data visualization systems to improve them.
- Develop data visualizations for large volumes of data to support intuitive presentation for decision makers.
- Document data flows, systems, and processes to improve the design, implementation, and management of business/group processes.
- Develop tools and deliver training programs for reporting tools and self-serve analytics by non-analytical end users (including delivery of training to audiences, as needed).
- Provide specialized consulting, analytical, and technical support.
- Apply judgment to identify, diagnose, and solve problems within established rules.
- Handle non-routine situations independently and regularly.
- Follow risk management requirements by applying the Risk Management Framework in line with risk culture and approved risk appetite, making sound and risk-informed decisions aligned to business strategy and applicable policy documents, laws, and regulations.
Qualifications
Foundational level of proficiency
- Technical design optimization
- Decision making
- Systems thinking
Intermediate level of proficiency
- SQL
- Power BI
- Python
- Data visualization
- Data storytelling
- Data mining
- Illustration
- Creative thinking
- Problem solving
- Verbal and written communication skills
- Collaboration and team skills
- Analytical and problem-solving skills
- Data-driven decision making
Advanced level of proficiency
- Insights design
- Insights development and reporting
- Typically 5 - 7 years of relevant experience and post-secondary degree in a related field of study, or an equivalent combination of education and experience
- Deep knowledge and technical proficiency gained through extensive education and business experience
Compensation & Benefits
- Salary: $75,000.00 - $160,000.00
- Pay Type: Salaried
- The provided pay range reflects the employer’s pay range and type. Salaries vary based on factors such as location, skills, experience, education, and qualifications, and may include a commission structure.
- Total compensation may include performance-based incentives and discretionary bonuses, as well as other perks and rewards.
- Benefits may include health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans.
Location
US (BMO U.S.)