Data Analyst - Finance

About the company

Since 1999, the firm has done strategy and operations work for utilities and public agencies. Environmental permitting and compliance consulting is the newest practice area.

Position summary

We need a Data Analyst - Finance. This is a full-time position based in Los Angeles, California. Analyst role with a mix of recurring reporting and project work. Most of your day will be in SQL, Excel and Power BI or Tableau. This position is on site in Los Angeles.

In this role you will

• Create forecasts and simple models in Excel or Google Sheets.
• Present results to managers and answer follow-up questions.
• Define metric logic with stakeholders and document it.
• Write SQL queries against the data warehouse to pull and join data for analysis.
• Analyze trends, cohorts and funnel drop-off and summarize findings in plain language.
• Track sales, inventory or service levels against targets and flag misses early.
• Automate recurring Excel reports with Power Query, Python or scheduled SQL.
• Field ad hoc requests through a ticket queue and prioritize them with your manager.

Who you are

• 3-5 years of experience in a data or reporting analyst role.
• Bachelor's degree in statistics, economics, business, math or a related field.
• Advanced Excel: pivot tables, XLOOKUP, Power Query.
• Clear written and verbal communication with non-technical stakeholders.
• Habit of checking your own numbers before anyone else sees them.
• Strong SQL (joins, CTEs, aggregations, window functions)

Why work with us

The salary range for this role is $98,000 - $118,000 per year. This range reflects base salary only.

• Medical, dental and vision insurance.
• 401(k) with 4% match.
• Paid sick leave.
• Referral program.
• Health, dental and vision coverage starting on day one.
• Annual bonus.

If this sounds like a fit, apply with a resume. A cover letter is optional.

Start: Flexible.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Lanternkit Partners, LLC.