Financial Reconciliation & Automation Analyst
- Mississauga, ON, Canada
$25 to $31 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $25 to $31 CAD / hour
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Position Overview
Responsible for financial control and Insurance Finance Reconciliation.
The team consists of 3 FTEs, with a few other contractors working on different activities. The contractor being sourced will help the FTEs conduct reconciliations so that they can work on other tasks.
Key Responsibilities
- Responsible for the preparation of reconciliations and attestations per prescribed Standard Operating Procedures (SOPs) while applying solid knowledge of the operations, its procedures and systems to the reconciliations process.
- Ensure true breaks are identified, investigated / reported and items that represent a potential loss are escalated immediately.
- Support all questions pertaining to in-house reconciliations and support investigations for outages for outsourced reconciliations.
- Use in-house and online tools to do first-level investigation on outages in order to speed up resolution.
- Display good judgment and decision-making skills in dealing with breaks and reporting.
- Work with various stakeholders relating to various reconciliation functions.
- Do peer reviews on other reconciliations prepared by the team.
- Lead the charge on designing new reconciliations and amending existing reconciliations where needed.
- Use new and existing tools to automate and recommend solutions for data ingestion, analytics and visualization to create efficiencies in the reconciliation preparation process to reduce lead time.
- Create monthly and ad hoc statistic reporting.
- Posting journal entries where necessary.
- Demonstrate flexibility to assume ad hoc work outside of the general reconciliation process.
Daily Responsibilities – A Day in the Life
- Prepare daily reconciliations and attestations as per prescribed SOPs.
- Identify, investigate and report reconciliation breaks.
- Escalate potential financial losses immediately.
- Investigate reconciliation outages using in-house and online tools.
- Coordinate with different stakeholders to resolve reconciliation issues.
- Conduct peer reviews of reconciliations prepared by other team members.
- Work on designing new reconciliations and updating existing processes.
- Use automation tools to improve data ingestion, analytics and visualization.
- Prepare monthly and ad hoc statistical reports.
- Post journal entries whenever required.
Project Information
Project: Clean-up project after new accounting standard implementation.
Technical Skills and Applications
Must-have:
- Advanced working knowledge of Excel.
- Advanced working knowledge of Microsoft Office suite of products.
The selected candidate will use these tools for reconciliation preparation, data analysis, reporting and process automation.
Must-Have Skills, Experience and Education
- Must have 3 years+ of experience preparing reconciliations.
- 2 years+ of experience with data transformation and process automation.
- Graduate or post-graduate or professional designations such as MBA, CA, CFA. This mandate will benefit from the analytical and financial reporting understanding and skills commonly associated with accounting designations.
- 3+ years of experience with an accounting or similar role.
- Advanced working knowledge of Excel / Microsoft Office suite of products.
- Willingness to collaborate and build strong relationships across business functions.
- Excellent communication and interpersonal skills. Able to collaborate and build strong relationships with multiple stakeholders.
Nice-to-Have Skills and Experience
- Knowledge of how to use Tableau.
- Knowledge of Insurance products / operations, familiar with insurance accounting, together with willingness and interest to develop that knowledge.
Soft Skills
- Willingness to collaborate and build strong relationships across business functions.
- Excellent communication and interpersonal skills. Able to collaborate and build strong relationships with multiple stakeholders.
- Eagerness to investigate and learn.
- Must be able to take initiative and challenge the status quo.
The expected base salary range for this position is $25 – $31 per hour, depending on experience, skills, and internal equity.
The Company offers a total rewards package in accordance with all applicable federal, provincial, and local laws and requirements. Benefit eligibility and offerings vary based on role, employment status, and work location.
For contractor positions, benefits are limited to those entitlements and protections required by applicable law, which may include (as applicable) vacation pay, public holidays, leaves of absence, and other legally mandated benefits or payments.
We may use AI-enabled and/or automated tools to support parts of our recruitment process, including application screening, interview scheduling, and candidate communications. These tools are used to enhance consistency and efficiency. All hiring decisions involve human review and are not based solely on automated processing.
More about this job
Responsibilities
Prepare and review financial reconciliations and attestations, investigate and escalate breaks or potential losses, and coordinate with stakeholders to resolve issues. Design and improve reconciliation processes using automation and data tools, prepare statistical reports, and post journal entries when required.
Requirements
Requires at least three years of reconciliation and accounting-related experience, plus at least two years of data transformation and process automation experience. Candidates must have advanced Excel and Microsoft Office skills and a graduate or postgraduate qualification or professional designation; strong communication, collaboration, and investigative skills are also required.
Skills
- Financial Reconciliation
- Excel
- Microsoft Office
- Data Transformation
- Process Automation
- Financial Reporting
- Data Analysis
- Break Investigation
- Journal Entries
- Stakeholder Collaboration
- Peer Review
- Process Design
- Data Ingestion
- Analytics
- Tableau
- Insurance Accounting
Visa sponsorship
Not detected in the job text
Categories
- Finance & Accounting
- Data & Analytics
- Technology
Keywords
- Financial Reconciliation
- Insurance Finance
- Accounting
- Standard Operating Procedures
- Attestations
- Reconciliation Breaks
- Financial Loss Escalation
- Outage Investigation
- Excel
- Microsoft Office
- Data Transformation
- Process Automation
- Data Ingestion
- Data Analytics
- Data Visualization
- Statistical Reporting
- Journal Entries
- Tableau
- Insurance Products
- Insurance Operations
- Insurance Accounting
- Financial Reporting
- Peer Reviews
- Stakeholder Management
- Accounting Standards
- MBA
- CA
- CFA