Senior Information Reporting Manager
Toronto
Reporting – Reporting /
Full Time /
Hybrid
Join a Challenger
Being a traditional bank just isn’t our thing. We are big believers in innovating the banking experience because we believe Canadians deserve better options, and we challenge ourselves and our teams to creatively transform what’s possible in banking. Our team is made up of inquisitive and agile minds that find smarter ways of doing things. If you’re not afraid of taking on big challenges and redefining the future, you belong with us. You’ll get to work with people who will encourage you to reach new heights. We like to keep things fun, ask questions and learn together.
We are a big (and growing!) family. Overall we serve more than 370,000 people across Canada through Equitable Bank, Canada's Challenger Bank™, and have been around for more than 50 years. Equitable Bank's wholly-owned subsidiary, Concentra Bank, supports credit unions across Canada that serve more than 5 million members. Together we have over $100 billion in combined assets under management and administration, with a clear mandate to drive change in Canadian banking to enrich people's lives. Our EQ Bank platform (eqbank.ca) has been named the top Schedule I Bank in Canada on the Forbes World's Best Banks 2023, 2022, and 2021 lists.
The Work
Reporting to the Director, Information Reporting, the Senior Information Reporting Manager is responsible for the effective and efficient management of the Bank’s reporting system. The Senior Manager will provide guidance to other Financial and Senior Analysts.
This role requires the individual to possess a high degree of knowledge and experience in configuration, maintenance and governance of reporting systems and databases.
The individual will be required to have well developed interpersonal and communication skills, due to extensive work with other departments and external vendors. The ability to effectively gather and document reporting requirements and statements of work is also paramount to the success of the role.
Strong organization and multi-tasking skills are a must, and the individual should be able to work with a high degree of independence and initiative. As an individual contributor, the Senior Manager must also be willing to take a hands-on approach to the role together with a high level of attention to detail and a focus on control over data and databases.
Core Part's Of The Role Would Be:
- The Senior Information Reporting Manager is required to establish and maintain strong working relationships across the organization to help facilitate and coordinate reporting activities and identify areas for potential improvements.
- Data Processes and Reporting System Management (40%):
- Oversee the data processes to ensure data is reliably ingested, transformed and available for analysis within financial and management reporting capacity.
- Develop, maintain and implement methods and processes to maintain data integrity and detect the surface data quality issues.
- Responsible for data validation to ensure accuracy and integrity of reporting.
- Ensure the data cleansing activities follows the appropriate authorization and version control.
- Implement governance around the applicable shared drives, SharePoint, Reporting applications and data marts (limited access, data Integrity with the Enterprise Data warehouse)
- Continuously review and streamline reporting processes wherever possible.
- Develop and maintain system and process documentation with respect to Security, Change Management of Reports and the reporting system, data structure and month end procedures.
- Ensure any new data elements (GL Accounts and Company) are implemented correctly to the impacted reporting tools.
- Assist in build out of data marts as required as required by the various reporting applications (Tableau, Power BI)
- Work in liaison with the Enterprise Data Management Team for continually identify opportunity to improve the data quality and automate the manual processes.
- Partners with data governance team to ensure the processes followed adhere to the organization’s data principles and guidelines.
- Act as Finance data steward.
- Report Production (15%):
- Responsible for the review and approval of a number of the Bank’s critical reports; including, but not limited to Mortgage Sub-ledger, Arrears Reporting, Insurers Reporting (CMHC, Canada Guaranty, Sagen)
- Analyze operational and statistical data, develop and optimization of business intelligence and reporting solutions.
- Responsible for the fulfilment of information reporting requests received from various business units across the Bank.
- Meet with various levels of management across the organization to evaluate and understand the scope, goals and objectives of the reporting requests and design, develop and operationalize reporting solutions that fulfill these requirements.
- Corporate Initiatives (35%):
- Act as an SME on assessing the impact of various corporate initiatives on the database and the reporting applications.
- Responsible for developing a strong understanding of new project requirements, project timelines, and implications to the reporting system.
- Responsible for managing and providing guidance to the reporting resources to fulfil project objectives and implement required changes.
- Document business requirements and proposed reporting solutions.
- Provide assistance in implementing Power BI to align with the corporate roadmap for reporting solutions.
- Explore Robotic Process Automation to replicate the repetitive and rule-based manual tasks.
- Contribute to implementation of new tools and ensure the accuracy of the data on these tools.
- Identify process gaps to bring efficiencies and effectiveness to the existing processes.
- Engage department heads to identify reporting needs or areas for improvement
- Ad hoc Reporting and Analysis (10%):
- Develop financial analysis as requested by senior management.
- Provide ad hoc reporting and support to the various business units.
- Investigate and respond to ad hoc requests with a high degree of flexibility, attention to detail with the ability to prioritize workload effectively.
- Responsible for the review and approval of a number of the Bank’s critical reports; including, but not limited to Mortgage Sub-ledger, Arrears Reporting, Insurers Reporting (CMHC, Canada Guaranty, Sagen)
- Analyze operational and statistical data, develop and optimization of business intelligence and reporting solutions.
- Responsible for the fulfilment of information reporting requests received from various business units across the Bank.
- Meet with various levels of management across the organization to evaluate and understand the scope, goals and objectives of the reporting requests and design, develop and operationalize reporting solutions that fulfill these requirements.
Let's Talk About You!
- University degree in Statistics, Finance, Economics, Business or other quantitative field preferred.
- 8 years of experience in a technical Reporting Analyst role creating and analyzing reports using IBM Cognos TM1, Microsoft Excel and Access.
- People management experience an asset.
- In-depth knowledge of the Canadian residential and commercial mortgage industry, including regulatory requirements, is preferred.
- Knowledgeable of mortgage products and features, lines and letters of credit.
- Strong understanding mortgage insurer requirements, regulations, and reporting requirements.
- Demonstrated ability in using MS Office (Excel, Access and Word); strong knowledge of Excel and VBA is necessary (pivot tables, nested “if” functions; VLOOKUP, MATCH/INDEX, ISERROR, OFFSET functions).
- Experienced utilizing SQL databases and OLAP concepts is required.
- Ability to work extensively with formulas, numbers, and spreadsheets.
- Experienced utilizing technology to automate business processes and increase efficiencies.
- Knowledge of financial statements and reporting is required.
- Knowledge of financial modeling concepts is required.
- Possess strong problem-solving and analytical skills.
- Ability to clearly communicate technical, analytical/quantitative or conceptual information and ideas using language that is appropriate to the target audience.
- Strong two-way communication and leadership skills.
- Strong attention to detail and organizational skills.
- Ability to handle multiple competing priorities (multi-tasking).
- Enjoys working well in both team and individual environments.
What we offer [For full-time permanent roles]
💰 Competitive discretionary bonus
✨ Market leading RRSP match program
🩺 Medical, dental, vision, life, and disability benefits
📝 Employee Share Purchase Plan
👶🏽 Maternity/Parental top-up while you care for your little one
🏝 Generous vacation policy, personal days and even a moving day
🖥 Virtual events to connect with your fellow colleagues
🎓 Annual professional development allowance and a comprehensive Career Development program
💛 A fulfilling opportunity to join one of the top FinTechs and help create a new kind of banking experience
The incumbent will be working hybrid and in office time will be spent working from Equitable Bank’s additional office space located at 351 King Street East, Toronto, ON.
Equitable Bank is deeply committed to inclusion. Our organization is stronger and our employees thrive when we honour and celebrate everyone’s diverse experiences and perspectives. In tandem with that commitment, we support and encourage our staff to grow not just in their career path, but personally as well.
We commit to providing a barrier-free recruitment process and work environment for all applicants. Please let us know of any accommodations needed so that you can bring your best self to the application process and beyond. All candidates considered for hire must successfully pass a criminal background check and credit check to qualify for hire. While we appreciate your interest in applying, an Equitable recruiter will only contact leading candidates whose skills and qualifications closely match the requirements of the position.
We can’t wait to get to know you!
