Data Analyst II

A bit about us:

Institutional clients include pension funds, endowments and insurance companies.

Overview:

Our New York City 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, but we prefer candidates within a few hours of Eastern time.

Your responsibilities:

• Write SQL queries against the data warehouse to pull and join data for analysis
• Clean and reconcile data from CRM, ERP and spreadsheet sources
• Prepare weekly and monthly KPI reports for department leads
• Field ad hoc requests through a ticket queue and prioritize them with your manager
• 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
• Analyze trends, cohorts and funnel drop-off and summarize findings in plain language
• Track sales, inventory or service levels against targets and flag misses early

You'll need:

• 3-5 years of experience in a data or reporting analyst role
• Habit of checking your own numbers before anyone else sees them
• Advanced Excel: pivot tables, XLOOKUP, Power Query

Bonus points:

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

What you get:

The base pay range for this position is $100,000 - $122,000/year. Actual pay depends on experience, skills and location.

• Health savings account (HSA) with employer contribution
• 401(k) with a 100% match up to 5%
• Three weeks of PTO to start
• Profit sharing

Dunmore 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 Dunmore Inc..