Reconcile policy-level premiums, commissions, receivables, and other policy details between Arch and MGAs. Prepare exhibits summarizing reconciling differences, maintain policy-level detail, track and age differences, and collaborate with accountants, underwriters, IT, and MGAs to resolve discrepancies.
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 DescriptionArch’s delegated authority programs are written by third party agencies referred to as Agencies or Managing General Agencies (MGA’s). Arch has a regulatory requirement to audit the MGA. The candidate will reconcile policy data between Arch financial systems and the systems of the MGA for the various programs. The candidate will create exhibits to identify the reconciling differences and work with various groups to resolve and clear the differences.
Responsiblities:
- Reconcile policy level premium, commissions, open receivables and other policy details between Arch’s systems and the MGA’s systems.
- Prepare exhibits summarizing the various reconciling differences with explanations describing the cause for the difference
- Maintain policy level detail which reflect the summarized differences in the exhibits
- Track and age differences
- Work with program accountant, Arch underwriter, Arch IT and MGA to resolve open differences
- Technical Skills: Microsoft Excel, Microsoft Office, Financial Systems, Accounting experience
- Strong analytical skills with the ability to collect and organize significant amounts of information with attention to detail and accuracy.
- Working knowledge and experience with financial systems.
- Strong verbal and written communication skills.
- Strong knowledge of Excel including complex functions and pivot tables to analyze data (sumproduct, vlookup, sumif, etc.)
- BS in Finance, Accounting, Mathematics, Economics, Statistics or related discipline.
Similar Jobs
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Architect and own marketing data infrastructure, Databricks pipelines, Gold Layer tables, semantic models, and AI-enabled data products. Lead complex cross-team initiatives, translate ambiguous business needs into scalable solutions, ensure data quality and reliability, and mentor engineers and analysts. Build, evaluate, and monitor production LLM and agent systems while automating marketing and go-to-market workflows with AI. Partner with BI, Data Science, Marketing, Sales, and R&D teams to support self-service analytics and trusted business KPIs.
Top Skills:
Ai AgentsBigQueryClaude CodeCursorData WarehousesDatabricksDbtEltETLLakehouse ArchitecturesLlmsPythonSalesforceSemantic LayersSnowflakeSQLStreamlit
An Hour Ago
Easy Apply
Easy Apply
Big Data • Fintech • Mobile • Payments • Financial Services
Leads Marketing and Consumer Privacy Engineering teams, developing engineers and establishing a shared operating model. Translates business and product priorities into engineering plans across logged-out web, experimentation, marketing integrations, attribution, measurement, consent, privacy experiences, and consumer data collection. Partners with Product, Marketing, Privacy, Legal, and Engineering stakeholders to deliver reliable, scalable, privacy-aware systems while balancing customer needs, quality, speed, and risk.
Top Skills:
AnalyticsAttributionAustralian Privacy ActCcpa/CpraConsent ManagementCookiesGdprInstrumentationMarketing TechnologyMeasurement SystemsTaggingWeb Experimentation
Agency • Digital Media • Legal Tech • Marketing Tech • Social Media • SEO
Own a portfolio of clients to maximize retention and growth: run client calls, analyze lead and performance data, spot retention risks and upsell opportunities, coordinate internal teams to deliver on strategy, and contribute process and AI-driven improvements to internal systems.
What you need to know about the Calgary Tech Scene
Employees can spend up to one-third of their life at work, so choosing the right company is crucial, not just for the job itself but for the company culture as well. While startups often offer dynamic culture and growth opportunities, large corporations provide benefits like career development and networking, especially appealing to recent graduates. Fortunately, Calgary stands out as a hub for both, recognized as one of Startup Genome's Top 100 Emerging Ecosystems, while also playing host to a number of multinational enterprises. In Calgary, job seekers can find a wide range of opportunities.
