Job Description

AGSI was incorporated in April 2016. We are committed to supporting the goals of Arch divisions through exceptional service delivery. We pride ourselves on maintaining flexibility and responsiveness to adapt to business unit and industry demands while focusing on sound project management. We are dedicated to growing and developing our employees as we build strong teams with strategic leadership.

The business analyst is responsible for the collection, organization, interpretation, analysis, scrubbing, documentation, and dissemination/presentation of data. The candidate will provide analysis, will process and normalize the data to ensure data integrity, and will create queries, views, and reports. The candidate will also work in processing data and producing analysis supporting business unit reporting and planning, with a strong focus on accuracy, timeliness, and customer service. The candidate will be a part of the Canada Operations team and will also provide support to other teams, including Canada Finance and the Lenders Business Unit.

• Support senior management and business stakeholders in producing analysis and reporting to drive business accountability, measure business decisions against commitments and prior results, and be part an integral part of the strategic planning cycle.
• Day-to-day activities: review/scrub data, interpret data, analyze results/trends, provide ongoing reports, build/update/enhance dashboards, send out communications to internal/external parties, etc.
• Develop and implement report/dashboard improvements that optimize efficiency and data quality.
• Acquire data from primary or secondary data sources and maintain databases
• Work closely with other stakeholders and teams to reconcile data (such as premiums and claims) and investigate data incongruencies.
• Filter and scrub data, and review reports and performance indicators to locate and correct data issues
• Support the onboarding process for new business/programs.
• Identify and execute on new process improvement opportunities
• Provide assistance, reconciliations and other support as required for internal and external partners.
• Assist with special projects and ad hoc reporting as required by the department or other business units

Qualifications

• Technical skills: Microsoft Excel, Microsoft Office Suite, Microsoft Power BI
• Excellent communication and interpersonal skills
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Adept at queries, variance analysis, report writing, and presenting findings
• Attention to detail, ability to learn new tasks quickly, good with numbers, ability to work independently and as part of team, good problem-solving skills.
• Strong time management with the ability to work under pressure and consistently meet deadlines.
• Nice to have: insurance knowledge/background
• Desired Technical Skills
• Intermediate/advanced skills in excel (e.g., ability to create and use complex formulas and pivot tables to analyze data)
• Intermediate/advanced skills in Power BI (e.g., dashboards)
• Intermediate/advanced skills in data transformation (e.g., Alteryx) and data querying (e.g., SQL, Snowflake).

Additional Information

• Accounting, Finance, or a relevant designation (or working towards achieving) is an asset
• Bachelor’s degree in Accounting, Business, Finance (or relatable discipline)