Junior Financial Analyst, Capital Planning

Wealth management, mortgage and treasury services each operate as separate lines of business. Founded in 2000, we now have 680 employees. Business casual all week, jeans on Fridays.

The position:

The Junior Financial Analyst, Capital Planning builds budgets, forecasts and monthly variance reports for operating leaders. Joining the FP&A team in New York City, reporting to the FP&A Manager. You can work from home anywhere in the US. We have no office requirement.

Essential duties and responsibilities:

• Develop dashboards in Power BI or Tableau for leadership
• Build and maintain the annual budget and quarterly forecast models
• Track headcount and payroll costs against plan
• Present monthly results to operating leaders and explain key drivers
• Support board deck preparation with charts and commentary
• Answer ad hoc questions from the CFO with quick-turn analysis
• Reconcile forecast data with accounting after close
• Model pricing changes, capital projects and new business cases

Qualifications:

• 1+ years of FP&A, corporate finance or public accounting experience
• Clear written commentary for monthly reporting
• Bachelor's degree in finance, accounting or economics
• Advanced Excel: INDEX/MATCH, XLOOKUP, SUMIFS, pivot tables and linked three-statement models
• Familiar with an ERP such as NetSuite, SAP or Oracle
• Strong attention to detail in large models

Salary: $80,000 - $92,000 per year

Benefits:

• Health, dental and vision coverage starting on day one
• 401(k) with a 100% match up to 5%
• 12 weeks of paid parental leave
• Flexible spending account

We are unable to sponsor visas for this position.

Applications are reviewed as they come in.

Start: Within 30 days.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Black Hills Bank & Trust.