Junior Financial Analyst

Delivery centers in California and overseas support large implementation programs. Consultants are staffed across industries early on, then specialize after a few years.

The position:

Trestlekit Consulting is looking for a Junior Financial Analyst to join a small, steady team. Joining the Commercial Finance team in Los Angeles, reporting to the FP&A Manager. Remote position. Most of the team is in Los Angeles, but nobody is required to come in. Strong written English is important, since much of our work is async.

Job duties:

• Reconcile forecast data with accounting after close
• Develop dashboards in Power BI or Tableau for leadership
• Improve forecasting processes and cut manual steps out of the model
• Track headcount and payroll costs against plan
• Prepare monthly variance analysis against budget and prior year
• Partner with department heads to understand spending and headcount plans
• Present monthly results to operating leaders and explain key drivers
• Update KPIs such as gross margin, CAC and revenue per employee

Qualifications:

• 1-2 years of FP&A, corporate finance or public accounting experience
• Advanced Excel: INDEX/MATCH, XLOOKUP, SUMIFS, pivot tables and linked three-statement models
• Comfortable presenting to non-finance managers
• Clear written commentary for monthly reporting

Preferred qualifications:

• SQL for pulling your own data
• Power BI or Tableau
• Manufacturing cost analysis
• SaaS metrics experience (ARR, churn, LTV)

Salary: $36.00 - $42.00/hr

What you get:

• Flexible schedule
• $1,000 home office setup budget

We read every application and reply within about a week.

Please include a short note on why this role interests you.

Duration: 9 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Trestlekit Consulting LLC.