Project Financial Analyst at Walbridge in US-MI-Detroit

Job description

• Walbridge Aldinger LLC hires a Project Financial Analyst in Detroit, MI. This position qualifies for an employee referral monetary incentive under our standard employee referral program.

Responsibilities

• Perform comprehensive financial statement and ratio analysis of third-party project partners (including vendors or subcontractors) to evaluate liquidity, solvency, and creditworthiness. Develop and monitor project-level budgets, including forecasting capital expenditures, and perform variance analysis of actual project costs versus underwriting.
• Build and enhance complex financial models using scenario and sensitivity analyses to evaluate strategic alternatives and optimize investment decisions. Analyze project-based risk insurance accounts (such as Subcontractor Default Insurance - SDI) and evaluate financial exposure and default risk across diverse portfolios.
• Advise senior leadership on financial risk management strategies and intervention methods based on predictive modeling and risk scoring. Prepare monthly and quarterly financial performance reports for senior leadership to identify trends in partner defaults, utilization, or project variances.
• Create reporting parameters and deliver ad hoc analytical reports to guide insurance strategy, risk pricing, or investment initiatives. Deliver internal reports and presentations regarding financial risk exposure and default scenarios to cross-functional teams and senior management.
• Develop business cases to support acceptable risk levels and aid in pricing for existing and new financial or insurance products. Work closely with project executives, finance directors, and legal counsel on risk mitigation strategies and default scenarios.
• Ensure compliance with prequalification policies and risk procedures using Vendor Management Systems (VMS), ERP data (e.g., JD
• Edwards), and other financial indicators.

Requirements

• Education: Bachelor’s degree in Accounting, Finance, Economics, Business Administration, Business Analytics, or a closely related quantitative field.
• Experience: 36 months of experience as a Financial Analyst, Financial Manager, Risk Analyst, Data Scientist, or related occupation.
• Special Skills: Requires 36 months of experience in financial analysis, risk assessment, or data science. Experience must include the following specific skills: m astery of liquidity, solvency, and leverage ratios to evaluate third-party or vendor credit risk.; proficiency in building financial models utilizing scenario and sensitivity analysis for project underwriting; technical proficiency in Tableau or Power BI for developing executive-level risk and performance dashboards; practical experience using SQL and Python for automated data manipulation and risk scoring; expertise in multi-year financial forecasting, including capital expenditure (CapEx) and net operating income (NOI) analysis; hands-on experience with enterprise systems such as JD Edwards, Alteryx, or Oracle BI.

Skills

Required

• Advise senior leadership
• Tableau
• Power BI
• SQL
• Python
• JD Edwards
• Alteryx
• Oracle BI