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

McNeil & Co.; Manila; On-site; PHP 600,000 - 900,000; Full time

Job summary

Arch Global Services (Philippines) Inc. is seeking a Finance Data Analyst Lead to supervise the team and ensure timely, accurate reporting and reconciliation across front-end and financial systems.

The role emphasizes strong Excel and analytical skills, collaboration with multiple stakeholders, and continuous improvement of reporting processes. Prior experience with US-based stakeholders and financial systems is preferred.

Qualifications

• High proficiency in Microsoft Excel with complex formulas, pivot tables and lookups.
• Strong analytical skills to interpret financial data and provide actionable insights.
• Proven problem-solving ability to investigate and resolve data discrepancies.
• Effective time management to meet tight deadlines and manage multiple tasks.
• Excellent communication and interpersonal skills for stakeholder interactions.
• Ability to work independently while collaborating across multiple teams.
• Familiarity with SQL for data extraction and analysis.
• Customer service focus in a finance context.

Responsibilities

• Lead and coordinate the day-to-day activities of the Finance Data Analyst team.
• Review and validate reporting, analysis, and reconciliation outputs.
• Act as escalation point for complex data issues and reporting discrepancies.
• Support management and stakeholders with financial analysis and reporting.
• Identify opportunities to improve reporting quality, efficiency, and accuracy.

Skills

Advanced Excel

Analytical thinking

Problem solving

Time management

Communication

Independence & collaboration

SQL exposure

Customer service

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

Do you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you.

10400 Arch Global Services (Philippines) Inc. Arch Capital Group Ltd. is a Bermuda-based specialty insurer that provides insurance, reinsurance and mortgage insurance on a worldwide basis. With a 20+-year track record of delivering results and a coveted position on the S&P 500 index, Arch is a great place to grow your career.

Attention Job Seekers: Arch Capital Group Ltd. (Arch) and its affiliates take your interest in working here very seriously.

Please be vigilant to fraudulent activity if you receive a communication or email asking you to submit any personal information. Do not send money or pass any details to someone suggesting they can provide employment with Arch. You should only enter your information into our official career portal.

Please know the following about our interviewing and hiring practices. We never make job offers without a formal, in person, interview process. We never ask you to send money of any kind.