Financial Data Analyst
Employment Type: Direct Hire/Perm
Workplace Type: Hybrid (Monday & Friday WFH)
Location: Temecula, CA
Industry: Marketing Services
Compensation: $90,000 - $110,000
Duties and Responsibilities:
- Working with a cross functional team to help enhance & create KPI's and reporting packages using both financial and operational based metrics.
- Assist in developing and maintaining SaaS business metrics that help drive business success
- Work closely with Information Technology and CFO to leverage existing corporate systems and recommend enhancements, changes, or new systems to support SaaS KPIs and reporting
- Perform variance and trend analysis between actual, budget and forecast targets for our SaaS business
- Gain an understanding of our SAAS Dashboard within SageIntacct, auditing and reconciliation of data and building of online dashboard within the tool
- Assist with in-depth analysis including new bookings (ACV), Upgrades, Downgrades and churn to monitor Gross and Net Revenue retention
- Create monthly forecasts (bookings, revenue, expense, capital and headcount) that incorporates current data and any relevant functional input
- Ensure off-line or batch reporting reconciles with existing system-based management reporting (SageIntacct and Salesforce)
- Create ad hoc analysis as needed
- KPI Reporting:
- Report on weekly KPI's such as ACV (Orders), Recurring revenue, customer and unit roll forwards, attrition rates, CAC, LTV and customer retention.
- Investigate variances vs. plan and meeting with department managers for input.
- Utilize Salesforce and ERP systems (SageIntacct), together with BI tools (Intacct's ICRW, Power Pivot) for consolidation of data.
- Financial Modeling:
- Develop complex financial models and present analytics to support Sales, Marketing, and R&D teams
- Assist in developing complex models that support the financial modeling related to potential Mergers & Acquisitions activity.
- Build analytical models that utilize both financial and non-financial data to forecast operating results, scenario modeling.
- Develop, interpret, and implement financial concepts for financial planning
- Prepare various industry and market analyses and benchmarking, as required
- Accounting/Financial Systems:
- Access SageIntacct general ledger system and financial reporting systems to pull actual financials for use in trending and forecasting analyses and play a key role in developing and enhancing SageIntacct Reporting.
- Prepare the monthly financial report with Director of Financial Planning & Analysis and executive commentary
- Develop, communicate, and manage requirements for reporting and SAAS system enhancements and serves as point person to facilitate business support throughout the technical development process as it relates to the SAAS Dashboard and metrics.
- Regular and reliable attendance is expected as this is a full-time position
- Other duties as assigned by management
REQUIRED SKILLS:
- Bachelor's degree in Finance, Accounting, or Data Analytics
- 5 years of expeirnece working in an analytics role in the SaaS vertical and advanced skills with reporting SaaS metrics for KPIs
- Experience in financial modeling, business analysis, FP&A, business integration, and analytics reporting
- Strong skills with MS Excel (INDEX, VLOOKUP, PIVOT TABLES, NPV, IRR, DATA TABLE, WHAT-IF ANALYSIS)
- Experience with CRM analytics and creating dashboards and reports within Salesforce Analytics
- Strong understanding of analysis and reporting data in ERP systems. Experience SageIntacct would be a HUGE plus. Familiarity with MS Dynamics Great Plains, Oracle NetSuite would also be preferred
- Proven ability to create financial models, including database manipulations and data visualization with Power Pivot, Excel, ICRM, or Tableau.
- Strong analytical and problem-solving skills
- Excellent communication skills
BONUS REQUIREMENTS:
- MBA in Finance, Accounting, and Analytics
- Accounting & Finance certifications (CPA, ACA, CFA)
- Experience analyzing, extracting, manipulating, and querying in SQL
- Understanding of Finance principles such as accounting debits & credits and P&L
All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.