Business Analyst II

Business Analyst IIThe Business Analyst II leads the onboarding of key forecasting models including promo sign-ups, subscription churn, and total customers into a financial forecasting platform built on TM1 and related planning tools. This role serves as the primary bridge between Finance stakeholders and TM1 engineering, translating finance reporting requirements and model logic into clear technical specifications, coordinating implementation, and owning user acceptance testing. The Business Analyst II also produces thorough documentation for each model build and enhancement, and establishes a repeatable framework for onboarding new models into the forecasting platform.ResponsibilitiesGather and document detailed finance reporting requirements from Finance stakeholders and translate them into precise technical specifications for TM1 and associated planning tool implementations.Define data requirements and source-data contracts for each forecasting model, identifying gaps between existing Finance Excel models and current system capabilities, and proposing solutions within TM1 and planning tool constraints.Design and wireframe user interfaces and user experiences for forecast adjustments to ensure that users can easily access only the adjustments they need to make, with complete reporting visibility after updates.Partner closely with TM1 engineering teams to design, build, test, and deploy updates to Finance models within the TM1 and planning analytics environment.Develop and execute comprehensive user acceptance testing (UAT) plans, validating that cube changes and model updates produce accurate and financially correct outputs before release to production.Document business rules, calculation logic, and data lineage for all onboarded forecasting dimensions to ensure transparency, consistency, and maintainability.Identify gaps in platform validation checks and collaborate with TM1 and planning tool teams, Data Science, and Data Engineering to strengthen validation and data quality controls.Trace metric discrepancies across multiple reporting surfaces back to pipeline-level or cube-level root causes, and work with relevant teams to resolve issues.Own the TM1 engineering ticket queue end to end, including intake, tracking, and closure of tickets, while prioritizing strategic work and new issues based on business impact in partnership with the Finance team.Maintain clear, structured documentation and communication around model changes, data requirements, and workflow improvements to support ongoing platform evolution.Essential Skills4 to 6 years of experience as a Business Analyst or Systems Analyst working with finance systems or enterprise planning tools.Proven experience translating business requirements into detailed technical specifications for engineering teams.Demonstrated ability to assess existing business processes and design improved workflows, including creating wireframes and UI/UX proposals.Advanced Excel skills, including complex formulas, pivot tables, data modeling, and scenario analysis.Working knowledge of SQL, with the ability to query relational databases to validate data and trace data lineage.Experience with planning, executing, and documenting user acceptance testing (UAT).Strong written and verbal communication skills, with the ability to articulate complex concepts to both technical and non-technical stakeholders.Solid understanding of financial reporting and forecasting concepts, with the ability to support accurate and reliable financial outputs.Additional Skills & QualificationsExperience with TM1, Planning Analytics, or similar enterprise planning and forecasting tools.Familiarity with ETL pipelines and data warehouse concepts, including platforms such as Redshift, Andes, or comparable technologies.Knowledge of FP&A concepts, including forecasting, actuals versus plan variance analysis, and dimensional modeling.Experience working within media, streaming, or subscription-based business models.Ability to collaborate effectively with Data Science, Data Engineering, and Finance stakeholders in a cross-functional environment.Work EnvironmentThis role is based onsite in Culver City and follows a standard full-time schedule of approximately 40 hours per week, Monday through Friday. The position operates within a collaborative office environment that works closely with Finance, TM1 engineering, Data Science, and Data Engineering teams. The work focuses on financial forecasting, data analysis, and model implementation within TM1 and related planning tools, with regular interaction across technical and business functions.Job Type & LocationThis is a Contract position based out of Los Angeles, CA.Pay and BenefitsThe pay range for this position is $35.00 - $38.00/hr. Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)Workplace TypeThis is a fully onsite position in Los Angeles, CA.Application DeadlineThis position is anticipated to close on Oct 2, 2026.