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.

Overview:

Our team is growing and we are hiring a Data Analyst. We want an analyst who is comfortable pushing back when the numbers don't support the conclusion. Remote, open to candidates across the US. We use Slack, Notion and Google Meet. Cameras on for team calls.

Day to day:

Automate recurring Excel reports with Power Query, Python or scheduled SQL. Clean and reconcile data from CRM, ERP and spreadsheet sources. Track sales, inventory or service levels against targets and flag misses early. Create forecasts and simple models in Excel or Google Sheets. 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. Define metric logic with stakeholders and document it. Support A/B test readouts with basic statistical checks.

Qualifications:

3+ years of experience in a data or reporting analyst role. Strong SQL (joins, CTEs, aggregations, window functions). Advanced Excel: pivot tables, XLOOKUP, Power Query. Able to juggle several requests and say when a deadline isn't realistic. Habit of checking your own numbers before anyone else sees them. Basic statistics: averages vs. medians, distributions, significance.

Preferred:

Google Analytics 4 or Adobe Analytics. Dbt or Snowflake. Tableau Desktop Specialist or Microsoft PL-300 certification. Salesforce or NetSuite reporting.

Expected salary range: $99,000 - $119,000 per year, plus bonus eligibility.

Perks and benefits:

Health, dental and vision coverage starting on day one. 401(k) with a 100% match up to 5%. Three weeks of PTO to start.

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

Start: Within 30 days.

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