The Senior Business Analyst collects, analyzes, and presents data to support business decision-making, reporting, and strategic planning within the organization.
Company 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.
Job DescriptionThe 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
- 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).
- Accounting, Finance, or a relevant designation (or working towards achieving) is an asset
- Bachelor’s degree in Accounting, Business, Finance (or relatable discipline)
Similar Jobs
Cloud • Security • Software • Cybersecurity • Automation
Design, maintain, and extend abuse detection and prevention systems for GitLab's SaaS platform. Serve as a core maintainer of a Ruby on Rails monolith, build anomaly detection and agentic AI mitigations, automate abuse response, collaborate with peer engineering and security teams, and produce runbooks and operational documentation.
Top Skills:
Agentic AiAWSGitlabGoogle Cloud Platform (Gcp)Large Language Models (Llms)RubyRuby On RailsSaaS
.png)
eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Lead analytics and measurement for a Sales subdomain: monitor KPIs, investigate performance issues, design experiments, build data foundations and self-serve dashboards, use agentic AI to automate workflows, and communicate results to senior sales, finance, and operations stakeholders.
Top Skills:
A/B TestingAgentic AiAirflowCausal TestingDatabricksDbtLookerMatched-Market TestingNumpyOmniPandasPythonSalesforceSnowflakeSQL
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Detect, contain, and remediate security incidents across Windows, macOS, and Linux. Perform malware analysis and forensic investigations, develop detection and remediation processes, produce customer-facing reports and recommendations, and contribute public thought leadership. Work a hybrid on-site 4x10 schedule with weekend coverage; US work authorization required.
Top Skills:
.NetAi TechnologiesCC#Computer ForensicsDynamic AnalysisIncident ResponseLinuxmacOSMalware AnalysisNetwork Analysis ToolsNetwork ForensicsPerlPythonRuby On RailsStatic AnalysisVisual BasicWindows
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
