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

Arch Capital; Philippines; On-site; PHP 600,000 - 900,000; Full time

Job summary

Arch Global Services (Philippines) Inc. seeks a Finance Data Analyst Lead to guide the daily operations of the analytics team and ensure accurate, timely reporting. You will partner with stakeholders to drive insights and improve financial processes while mentoring analysts across the function.

The role emphasizes data integrity, reconciliation, and proactive issue resolution, supporting US-based or multinational stakeholders within a dynamic, process-driven environment.

Qualifications

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

Responsibilities

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

Skills

Advanced Excel

Analytical skills

Problem solving

Time management

Communication

SQL (data extraction)

Customer service orientation

Independent and collaborative work

Tools

SQL

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 & CoachingStakeholder Management
• Problem Solving
• Attention to Detail
• Customer Service Orientation
• Time Management

10400 Arch Global Services (Philippines) Inc.