
Senior Strategic Finance & Business Intelligence Analyst
Cotulla Education
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Salary
💰 $150,000 - $200,000 per year
Job Level
About the role
- Own monthly revenue forecasting across campuses, brands, and programs using key operational drivers including starts, re-entries, drops, graduations, tuition yield, and fee assumptions.
- Build and maintain driver-based forecast models that tie student population assumptions directly to revenue and profitability outcomes.
- Support annual budgeting, rolling forecasts, and long-range planning with scenario analysis and sensitivity modeling.
- Develop and manage recurring executive scorecards, KPI tracking, and forecast variance reporting for the CFO and FP&A team.
- Own the student population dashboard, tracking beginning population, new starts, drops, graduates, ending population, and forecast versus actual trends.
- Partner with Finance and Operations to maintain a monthly student waterfall and validate enrollment and retention assumptions.
- Define and document forecasting logic, metric definitions, and reporting governance to ensure consistency and transparency.
- Reconcile forecast outputs to source systems and identify anomalies or inconsistencies in reporting.
- Write and manage SQL queries to join, validate, and reconcile data across systems.
- Partner with BI/Data teams to resolve data quality issues and improve reporting accuracy.
- Maintain and enhance executive dashboards in Tableau, Power BI, or similar BI tools.
- Produce actionable analysis on revenue performance, conversion, retention, and unit economics to inform capital allocation and operating decisions.
- Conduct root-cause variance analysis and trend evaluation for executive leadership.
- Translate complex financial and operational insights into concise executive-ready materials, including dashboards, one-pagers, and presentation decks.
- Establish repeatable reporting cadence and governance processes to support forecast updates and KPI reviews.
Requirements
- 5+ years of experience in FP&A, Strategic Finance, Business Intelligence, or a similar analytical role supporting senior finance leadership.
- Strong experience with revenue forecasting and driver-based financial models that translate operating metrics into P&L impact.
- Experience building monthly forecast frameworks in multi-site, high-volume, or education-adjacent environments preferred.
- Advanced Excel skills, including financial modeling, scenario analysis, and model quality control.
- Advanced Tableau, Power BI, or comparable BI tool experience for executive dashboards and recurring scorecards.
- Strong SQL skills for querying, joining, validating, and reconciling data across multiple systems. Experience with cloud warehouses (Snowflake or similar) preferred.
- Demonstrated ability to build and maintain student population, enrollment, or waterfall-style reporting.
- Strong understanding of core FP&A processes including annual budget, rolling forecast, variance analysis, and management reporting.
- Ability to manage sensitive financial and student data with discretion and sound judgment.
- Excellent written and verbal communication skills, with the ability to present insights clearly to executive and non-technical stakeholders.
- Highly organized, detail-oriented, and comfortable managing multiple priorities in a fast-paced environment.
- Strong interpersonal skills and ability to influence cross-functional teams without direct authority.
- Proficiency in Microsoft 365 (Excel, PowerPoint, Outlook, SharePoint, Teams). Familiarity with SIS/CRM/LMS data structures is a plus.
- Ability and willingness to occasionally work outside standard business hours for critical deadlines.
Benefits
- 401(k) and Matching: Secure your future with our competitive retirement savings plan.
- Comprehensive Health Coverage: Enjoy Health, Dental, and Vision insurance to keep you and your family healthy.
- Life Insurance: Peace of mind with life insurance options.
- Parental Leave: Support for new parents during important life transitions.
- Paid Time Off: Recharge with paid time off to promote work-life balance.
- Retirement Plan: Additional options to help you save for retirement.
- Employee Assistance Program: Access to resources for personal and professional support.
- Tuition Reimbursement: Invest in your future with financial support for further education.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
revenue forecastingdriver-based financial modelsfinancial modelingscenario analysisvariance analysisSQLdata reconciliationKPI trackingdata quality improvementroot-cause analysis
Soft Skills
communication skillsorganizational skillsdetail-orientedinterpersonal skillsinfluencing skillsjudgmentability to manage multiple prioritiespresentation skillsanalytical thinkingcollaboration