Finance Analyst Team Lead (with data analysis & SQL experience)

With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠.

• Lead and coordinate the day-to-day activities of the Finance Data Analyst team.
• Monitor team deliverables and ensure work is completed accurately and within established timelines.
• Provide coaching, guidance, and support to team members.
• Review and validate reporting, analysis, and reconciliation outputs.
• Act as the primary escalation point for complex reporting, reconciliation, and data-related issues.

• Support management and business stakeholders in producing analysis and reporting to drive business accountability and measure business performance against commitments and prior results.
• Analyze financial and operational data to identify trends, variances, and insights.
• Produce and review recurring and ad hoc reports for business and finance stakeholders.
• Utilize information from third parties and business units to report financial results in support of business management.

• Research and resolve premium, claims, and expense discrepancies between front-end systems and financial reporting systems.
• Perform and oversee financial analysis, general ledger reconciliations, and account analysis.
• Investigate and resolve complex data reconciliation issues.
• Ensure accuracy and integrity of financial information used in reporting.

• Develop strong working relationships with business units, operational leaders, and Finance stakeholders.
• Provide assistance, reconciliations, and support as required by internal and external partners.
• Serve as a key liaison between the analyst team and US Finance stakeholders.

• Identify opportunities to improve reporting quality, efficiency, and accuracy.
• Support special projects and ad hoc reporting requirements as needed.
• Promote best practices, consistency, and process discipline across the team.

• Advanced Microsoft Excel skills, including complex formulas, pivot tables, lookups, and data analysis.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Strong problem-solving skills with the ability to investigate and resolve data discrepancies.
• Ability to understand and apply standard practices and procedures.
• Strong time management skills with the ability to work under pressure and consistently meet deadlines.
• Excellent communication and interpersonal skills.
• Ability to work independently and collaboratively across multiple teams and stakeholders.
• Exposure to SQL for data extraction and analysis.
• Strong customer service focus.

• Property & Casualty Insurance experience.
• Experience supporting US-based stakeholders.
• Experience with financial systems such as Workday or similar platforms

• Financial Analysis
• Financial Reporting
• Reconciliations & Account Analysis
• Data Analysis
• Advanced Excel
• Leadership & Coaching
• Stakeholder Management
• Problem Solving
• Attention to Detail
• Customer Service Orientation
• Time Management

Do you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you. If this job isn’t the right fit but you’re interested in working for Arch, create a job alert! Simply create an account and opt in to receive emails when we have job openings that meet your criteria. Join our talent community to share your preferences directly with Arch’s Talent Acquisition team.