Job Description Summary

We are looking for a technically adept FP&A Intern to transform raw financial data into predictive insights. Unlike a traditional finance role, you will apply statistical modeling and Python automation to move the department from "what happened" (descriptive) to "what will happen" (predictive). You will be responsible for building scripts that handle large-scale datasets and developing models that improve the accuracy of our financial forecasts.

Job Description

Key Responsibilities

• Automated Data Pipelines: Utilize Python (Pandas) to clean, transform, and merge disparate datasets from Salesforce, Data Lake, and ERP systems.
• Statistical Forecasting: Apply regression analysis and time-series modeling to project future revenue streams and operational expenses.
• Variance Attribution: Build statistical models to identify the "signals" vs. "noise" in budget variances, helping leadership focus on high-impact anomalies.
• Data Visualization: Design advanced dashboards in Tableau/Power BI/Excel that incorporate statistical trend lines and confidence intervals.
• Predictive cost/Revenue : Using historical cost/ billing data (leveraging their experience with 250+ weekly invoices), the intern will build a Linear Regression or Time-Series model to predict next month’s revenue/Cost projections

Technical Requirements

• Programming: Intermediate Python (Pandas, NumPy, Matplotlib/Seaborn), Advance Excel and PowerBI
• Statistics: Understanding of correlation, linear regression, and probability distributions within a corporate finance context.
• Systems: Experience with Oracle ERP, Hyperion

Additional Information