Senior Data Analyst

Company overview

Headquartered in New York City, the firm is employee-owned. Chesapeake Advisory is a management and technology consulting firm with 340 employees worldwide.

We are adding a Senior Data Analyst to our Analytics team. You'll own a set of dashboards and the data behind them, and be the go-to person when someone asks why a number looks off. We are headquartered in New York City and have been hiring remotely since 2020. We engage team members in Mexico as full-time contractors. Most of our contractors have been with us for more than two years. Core hours are 9:00 AM to 1:00 PM US Eastern. We talk mostly in Slack and hop on quick calls when something needs discussing.

Responsibilities

Define metric logic with stakeholders and document it. Automate recurring Excel reports with Power Query, Python or scheduled SQL. Build and maintain dashboards in Tableau, Power BI or Looker. Analyse trends, cohorts and funnel drop-off and summarise findings in plain language. Clean and reconcile data from CRM, ERP and spreadsheet sources. Prepare weekly and monthly KPI reports for department leads.

Minimum qualifications

Able to juggle several requests and say when a deadline isn't realistic. Basic statistics: averages vs. medians, distributions, significance. Clear written and verbal communication with non-technical stakeholders. Advanced Excel: pivot tables, XLOOKUP, Power Query. Bachelor's degree in statistics, economics, business, math or a related field. Strong SQL (joins, CTEs, aggregations, window functions).

What we offer

Salary range: $3,700 - $5,000 per month

Long-term engagement. Annual rate review.

Applications are reviewed on a rolling basis.

Duration: 9 months. Start: Flexible.

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