Data Analyst

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.

The role

Lakewood Advisory has an opening for a Data Analyst. The Business Intelligence team needs someone who can write SQL, build dashboards and explain what changed and why. You can work from home anywhere in the US. We have no office requirement. Normal working hours, Monday to Friday. Communication happens mostly in Slack and short video calls.

Your responsibilities

• Analyze trends, cohorts and funnel drop-off and summarize findings in plain language.
• Prepare weekly and monthly KPI reports for department leads.
• Present results to managers and answer follow-up questions.
• Define metric logic with stakeholders and document it.
• Investigate data quality issues and work with data engineering to fix them at the source.
• Automate recurring Excel reports with Power Query, Python or scheduled SQL.

What you need

• 2+ years of experience in a data or reporting analyst role.
• Bachelor's degree in statistics, economics, business, math or a related field.
• Basic statistics: averages vs. medians, distributions, significance.
• Advanced Excel: pivot tables, XLOOKUP, Power Query.

Nice to have

• Industry background in retail, healthcare or logistics.
• Dbt or Snowflake.
• Salesforce or NetSuite reporting.

Compensation: $97,000 to $125,000/year

Compensation and benefits

• Health savings account (HSA) with employer contribution.
• 401(k) with 4% match.
• Paid holidays.
• $1,000 home office setup budget.
• Life insurance.
• 401(k) with company match.

Lakewood Advisory provides equal employment opportunities to all employees and applicants.

Start: Flexible.

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