Financial Analyst II - Data-Driven Modeling & Dashboards

HILGARTWILSON, LLC; Philadelphia, Conshohocken (Philadelphia County, Montgomery County); On-site; USD 70,000 - 95,000; Full time

Job summary

Colliers Engineering & Design is seeking a dynamic Financial Analyst II to join our finance team. This role focuses on data analytics, financial modeling, and strategic insight to support decision-making and improve reporting across the organization.

The ideal candidate has 2–3 years of financial analysis experience, strong Excel/Power BI skills, and familiarity with ERP systems. This full-time role is based in the United States, with a focus on quantitative analysis and cross-functional

Qualifications

• Bachelor’s degree in Finance, Accounting, Economics, or related field.
• 2–3 years of financial analysis experience in a data-driven or tech-enabled environment.
• Proficiency in Excel, Power BI, CoPilot, and ERP systems (BST, Deltek, SAP, Oracle).
• Strong GAAP knowledge, financial statements and forecasting techniques.

Responsibilities

• Build and maintain advanced financial models for budgeting, forecasting, and scenario planning across P&L, working capital, backlog, and KPIs.
• Create dashboards and reports using Power BI, Excel, CoPilot, and BST to deliver actionable insights to leadership.
• Conduct variance analysis and identify drivers of financial performance; highlight risks and opportunities.
• Partner with senior leaders to prepare executive-level presentations and shareholder materials.
• Contribute to process improvements to enhance data governance and timeliness of reporting.
• Support M&A analysis, integration planning, and ROI scenario development.

Skills

Analytical thinking

Communication

Problem solving

Education

Bachelor’s degree in Finance/Accounting/Economics

MBA or CPA preferred

Tools

BST ERP

Deltek

SAP

Oracle

Excel

Power BI

CoPilot

Job description

Colliers Engineering & Design is seeking a dynamic Financial Analyst II to join our finance team. This role focuses on data analytics, financial modeling, and strategic insight to support decision-making and improve reporting across the organization.

The ideal candidate has 2–3 years of financial analysis experience, strong Excel/Power BI skills, and familiarity with ERP systems. This full-time role is based in the United States, with a focus on quantitative analysis and cross-functional