Forecasting Model BA II — TM1/Apliqo Onboarding Lead

Us Tech Solutions; Culver City (CA); On-site; USD 100,000 - 167,000; Full time

Job summary

US Tech Solutions seeks a Business Analyst II to lead onboarding of forecasting models—Promo Sign Ups, Subscription Churn, and Total Customers—into a TM1/Apliqo-based forecasting platform. You will create documentation and establish a repeatable onboarding framework, bridging Finance stakeholders and TM1 Engineering, translating requirements into technical specs and owning UAT.

Responsibilities include defining data needs, validating outputs, and coordinating with data teams to ensure accurate,

Qualifications

• 4–6 years of experience as a Business Analyst or Systems Analyst in finance systems.
• Translate business requirements into technical specifications for engineering.
• Design improved workflows with wireframes and UI/UX proposals.
• Advanced Excel skills with complex formulas and data modeling.
• SQL querying for data validation and data lineage tracing.
• Experience with UAT planning and execution.
• Strong written and verbal communication skills.

Responsibilities

• Gather and document finance reporting requirements; translate to TM1/Apliqo specs.
• Define data requirements and source-data contracts for each model.
• Identify gaps between Finance Excel model needs and system capabilities; propose solutions.
• Wireframe and propose UI/UX for forecast adjustments and reporting.
• Partner with TM1 Engineering to design, test, and deploy finance model updates.
• Define and execute UAT plans and validate outputs before production.
• Document business rules, calculation logic, and data lineage.
• Identify validation gaps; coordinate with TM1/Apliqo and data teams.
• Own the TM1 Engineering ticket queue from intake to closure.

Skills

Advanced Excel

SQL

UAT planning

Communication

Tools

TM1

Apliqo

Redshift

Job description

US Tech Solutions seeks a Business Analyst II to lead onboarding of forecasting models—Promo Sign Ups, Subscription Churn, and Total Customers—into a TM1/Apliqo-based forecasting platform. You will create documentation and establish a repeatable onboarding framework, bridging Finance stakeholders and TM1 Engineering, translating requirements into technical specs and owning UAT.

Responsibilities include defining data needs, validating outputs, and coordinating with data teams to ensure accurate,