Data Analyst II

We work with Fortune 500 companies, federal agencies and large health systems. Our practices cover strategy, operations, technology implementation, risk and human capital. We write a lot: proposals, status reports, slide decks and final reports.

About the role

Our team is growing and we are hiring a Data Analyst II. We want an analyst who is comfortable pushing back when the numbers don't support the conclusion. Fully remote. You can work from anywhere in the US. We keep meetings to a minimum and work mostly async.

What you'll do

• Investigate data quality issues and work with data engineering to fix them at the source
• Analyze trends, cohorts and funnel drop-off and summarize findings in plain language
• Create forecasts and simple models in Excel or Google Sheets
• Field ad hoc requests through a ticket queue and prioritize them with your manager
• Track sales, inventory or service levels against targets and flag misses early
• Prepare weekly and monthly KPI reports for department leads
• Support A/B test readouts with basic statistical checks

Required qualifications

• Basic statistics: averages vs. medians, distributions, significance
• Experience with at least one BI tool such as Tableau, Power BI or Looker
• Strong SQL (joins, CTEs, aggregations, window functions)
• Habit of checking your own numbers before anyone else sees them
• Advanced Excel: pivot tables, XLOOKUP, Power Query
• Able to juggle several requests and say when a deadline isn't realistic
• Bachelor's degree in statistics, economics, business, math or a related field

Preferred qualifications

• Google Analytics 4 or Adobe Analytics
• Dbt or Snowflake
• Industry background in retail, healthcare or logistics

Compensation: $46.00-$52.00/hr

Why work with us

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

A resume is enough to apply. Cover letters are optional.

Duration: 12 months. Start: Immediately.

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