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

Arch Insurance Group Inc.; Cebu City; On-site; PHP 600,000 - 900,000; Full time

Job summary

Arch Global Services (Philippines) Inc. is seeking a Finance Data Analyst Team Lead to guide the daily activities of the analytics team, ensuring timely and accurate reporting, reconciliation, and data quality.

You will coach analysts, review outputs, and act as the primary escalation point for complex data issues. The role emphasizes collaboration with US-based Stakeholders and continuous improvement across financial reporting processes, leveraging SQL and Workday for data extraction and system

Qualifications

• Advanced Microsoft Excel with complex formulas, PivotTables and data analysis.
• Strong analytical skills to collect, organize, analyze and present large data sets.
• Excellent problem-solving abilities to investigate data discrepancies and issues.
• Effective time management to meet tight deadlines in a fast-paced environment.
• Strong communication and interpersonal skills for collaboration with multiple stakeholders.
• Ability to work independently and with cross-functional teams.

Responsibilities

• Lead and coordinate the day-to-day activities of the Finance Data Analyst team.
• Monitor team deliverables and ensure accuracy and timeliness of outputs.
• Provide coaching, guidance, and support to team members.
• Review and validate reporting, analysis, and reconciliation outputs.
• Serve as primary escalation point for complex reporting, reconciliation, and data issues.
• Develop strong relationships with business units and Finance stakeholders.
• Identify opportunities to improve reporting quality, efficiency, and accuracy.

Skills

Advanced Excel

Analytical skills

Problem solving

Time management

Communication

Interpersonal skills

Tools

SQL

Workday

Job description

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.

Team Leadership

• 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.

Financial Reporting & Analysis

• 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.

Reconciliations & Issue Resolution

• 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.

Stakeholder Support

• 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.

Continuous Improvement

• 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.

Required Qualifications & Experience

• 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.

Preferred Qualifications

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

Key Competencies

• 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

10400 Arch Global Services (Philippines) Inc.