Director, Financial Planning & Business Intelligence

Rainforgrowth; Northern (KY); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical, Dental, and Vision insurance

401(K) plan with employer match

4–6 weeks PTO

Monthly Work-From-Home allowance

Job summary

Rain is seeking a Director, Financial Planning & Business Intelligence to strengthen FP&A, business partnering, reporting, and BI capabilities. Remote position with periodic travel across time zones; reports to the CFO and partners with senior leaders.

Responsibilities include leading annual plans and quarterly forecasts, performing performance analysis, supporting monthly reporting, and building scalable data models and Power BI dashboards to drive data-driven decisions.

Qualifications

• Bachelor's degree in Finance, Accounting, Economics, Business Analytics, or related field.
• 7+ years of progressive FP&A, corporate finance, financial analytics, or business finance experience.
• Advanced Power BI, Power Query, Power Pivot, and DAX experience required.

Responsibilities

• Lead or support the Annual Plan and Quarterly Forecasts for corporate and leadership review.
• Prepare financial analysis of performance trends, key business drivers, revenue, profitability, staffing, utilization, and cash flow.
• Support monthly and quarterly financial reporting for executive and department leaders.
• Develop scenario models supporting strategic decisions, growth initiatives, and investment opportunities.
• Own development and enhancement of Power BI reporting and dashboard solutions for Finance.
• Design and maintain scalable financial data models using Power BI, Power Pivot, Power Query, DAX, and related tools.

Skills

Financial modeling

Forecasting

Budgeting

Variance analysis

Executive communication

Education

Bachelor's degree in Finance, Accounting, Economics, Business Analytics, or related field

CPA/CFA/MBA or equivalent advanced experience preferred

Tools

Power BI

Power Pivot

Power Query

DAX

Job description

Current job opportunities are posted here as they become available.

Director, Financial Planning & Business Intelligence

The Director, Financial Planning & Business Intelligence is responsible for strengthening the agency's financial planning, business partnering, management reporting, and business intelligence capabilities. This role will ensure Finance has the tools, capabilities, and data to support strong performance management practices, improved budgeting and forecasting, and stronger commercial decision support across the organization.

The Director, Financial Planning & Business Intelligence is a director-level position on the Finance team, reporting to the CFO. The role will partner closely with the VP Financial Operations, Controller, and business leaders, with a focus on improving Finance business continuity, reporting automation, and data-driven financial analysis.

While this is a remote position, periodic travel and accommodating meetings in different time zones is expected.

What does a Director, Financial Planning & Business Intelligence do at Rain?

Corporate FP&A Responsibilities:

• Lead or materially support the Annual Plan and Quarterly Forecasts for corporate and leadership review
• Prepare financial analysis of performance trends, key business drivers, revenue, profitability, staffing, utilization, and cash flow
• Support monthly and quarterly financial reporting for executive and department leaders
• Develop scenario models supporting strategic decisions, growth initiatives, and investment opportunities
• Support Board reporting packages, M&A evaluations, and other CFO-level analysis as needed

Business Line Finance Partnership:

• Serve as a financial partner to business unit and department leaders, helping translate financial results into operational decisions
• Lead regular financial reviews focused on performance against plan, key drivers, risks, opportunities, and action steps
• Improve budgeting discipline by helping business leaders connect operational plans to financial outcomes
• Support commercial modeling for growth initiatives, client opportunities, staffing decisions, and profitability improvement
• Build financial accountability throughout the organization through clear reporting, consistent metrics, and actionable analysis

Financial Systems, Business Intelligence and Finance Process:

• Own development and enhancement of Power BI reporting and dashboard solutions for Finance
• Design and maintain scalable financial data models using Power BI, Power Pivot, Power Query, DAX, and related tools
• Automate recurring reporting processes and reduce dependency on manual spreadsheet work
• Partner with Finance, Technology, Analytics, and operational teams to improve data quality, reporting consistency, and alignment of financial definitions
• Drive process improvements, workflow changes, and reporting enhancements needed to support agency objectives

What do we look for in a Director, Financial Planning & Business Intelligence at our agency?

• Bachelor's degree in Finance, Accounting, Economics, Business Analytics, or related field. CPA, CFA, MBA, or equivalent advanced experience preferred
• 7+ years of progressive FP&A, corporate finance, financial analytics, or business finance experience
• Advanced Power BI, Power Query, Power Pivot, and DAX experience required
• Demonstrated ability to build financial dashboards, data models, automated reporting, and performance management tools
• Strong financial modeling, forecasting, budgeting, and variance analysis skills
• Excellent communication and interpersonal skills, with the ability to support executive, operational, and commercial leaders
• Position based in Pacific time zone, periodically requires travel and accommodation of other US time zones
• Appreciation of our Core Values

Why work at Rain?

• We are a national leader in DTC marketing and a fully integrated creative and media agency. With a 25+-year history and around 250 employees, we are established enough to have all the bells and whistles, but small enough for an entrepreneurial and welcoming culture where everyone is heard.
• Our Flexible First environment empowers us to work from where we’d like but still connect with one another virtually and in-person when possible.
• We proudly invest in our employees, technology, and tools, ensuring the best possible work experience. As such, we offer a rich benefits package including the following:
  • Medical, Dental, and Vision insurance
  • Quarterly profit-sharing program
  • 401(K) plan with employer match (and immediate eligibility)
  • 4-6 weeks PTO
  • 12 paid holidays
  • 12-18 weeks fully-paid Family and Medical Leave
  • Monthly Work-From-Home allowance
  • Additional benefits details can be found here
• Transparency is valued. We actively ensure employees know how we are doing and where we are going. We encourage open communication, share our successes, and hold each other accountable.
• We are passionate about our clients and deliver simultaneously on their brand and sales objectives, an approach we call Transactional Brand Building. To learn more about our work and proprietary philosophy, please check us out here.