Lead Data Analyst

Frontier Asset Management is a fee-only advisory practice with two advisors, a paraplanner and an office manager. Most staff have been with the firm for more than eight years.

Role overview

Frontier Asset Management has an opening for a Lead Data Analyst. The operations team needs someone who can write SQL, build dashboards and explain what changed and why. Remote, open to candidates across the US. Normal working hours, Monday to Friday. Please make sure you have a quiet place to work and a solid internet connection.

What you'll do

• Analyze trends, cohorts and funnel drop-off and summarize findings in plain language
• 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
• Prepare weekly and monthly KPI reports for department leads
• Support A/B test readouts with basic statistical checks
• Build and maintain dashboards in Tableau, Power BI or Looker

About you

• 8+ years of experience in a data or reporting analyst role
• Habit of checking your own numbers before anyone else sees them
• Able to juggle several requests and say when a deadline isn't realistic
• Advanced Excel: pivot tables, XLOOKUP, Power Query

Why work with us

Salary range: $53.00 - $65.50/hr

• $1,000 home office setup budget

We review applications on a rolling basis.

Duration: 6 months. Start: Immediately.

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