Heitmeyer Consulting

Apply Now

Heitmeyer Consulting is looking to hire a Financial Data Analyst who has strong data modeling expertise.

Location: Columbus, Ohio

Details: Onsite 2 days a week

Job Description

  • Design and build complex financial models in excel, Power BI and preferably Tableau based on historical and projected information and other available industry-specific operating metrics.
  • Conduct advanced scenario analysis based on microeconomic and macroeconomic factors to access business risk.
  • Evaluate companies’ fair value of potential acquisitions and joint ventures using various financial valuation methods, such as DCF, comparable company analysis, capital structure analysis etc.
  • Ensure the accuracy of the new models while enhancing the quality of the existing models.
  • Recommend and implement finance and operational process improvement measures.
  • Conduct deep-dive scenario and sensitivity analysis with the intent to support investment activities such as Proforma statements.
  • Update the financial models after each earnings roll out or other similar corporate actions.
  • Analyze and identify data required to support model tracking.
  • Assist with automation/semi-automation of existing reporting utilizing Power Pivot, Power Query, Power Bi, Tableau etc.
  • Create ad hoc models that are dynamic and easily understood and manipulated by business leaders in order to make strategic business decisions.

Required Skills

  • Previous data modeling experience
  • Strong experience with Excel, Power BI, or Tableau
    • Power Query or Power Pivot are a nice to have but not required
  • Experience automating or semi-automating reporting

Apply Now

  Apply with Github   Apply with Linkedin   Apply with Indeed
  Stack Overflow