Job Title: Financial Modeling Analyst

Employment Type: Part-time; Remote

Schedule: US Time zone

Industry: Financial and Strategic Advisory Services

We are looking for a highly skilled Financial Modeling Analyst to support our business operations and strategic decision-making through accurate and insightful financial models. The ideal candidate will have advanced Excel skills, strong business acumen, and experience working with KPIs, revenue projections, and operational metrics.

Key Responsibilities

• Build Financial Models: Design and develop dynamic financial models from scratch to support forecasting, budgeting, and strategic planning.
• Data Analysis & KPIs: Analyze business performance metrics and KPIs to identify trends, risks, and opportunities.
• Revenue & Cost Projections: Prepare revenue forecasts and scenario analyses to support business growth and operations.
• Advanced Excel Functions: Utilize complex formulas, including OFFSET, INDEX, MATCH, nested functions, and macros to enhance model functionality.
• Operational & Strategic Support: Provide insights for operational efficiency, profitability, and long-term strategy.
• Automation & Optimization: Improve existing financial processes, automate repetitive tasks, and ensure scalability of models.
• Output Tracking: Create dashboards and trackers to monitor model outputs and key performance indicators over time.

Requirements

• Proven experience in financial modeling and analysis.
• Advanced Excel skills, including pivot tables, OFFSET, INDEX/MATCH, dynamic ranges, and formula optimization.
• Strong understanding of business operations, finance, and strategy.
• Ability to handle large data sets and perform accurate reconciliations.
• Excellent problem-solving, analytical, and communication skills.
• Ability to work independently and meet tight deadlines.

Preferred Qualifications

• Experience with forecasting and scenario planning.
• Familiarity with business intelligence tools (e.g., Power BI, Tableau) is a plus.
• Knowledge of financial planning & analysis (FP&A) best practices.