Business Data Analyst (Marketing)

Company overview:

Merrimack Goods is a hardware and home improvement store selling tools, paint, lumber and lawn and garden supplies. The garden center opens in spring with annuals, shrubs, mulch and soil. Weekend availability is required.

We are replacing a colleague who is moving away. The Analytics team needs someone who can write SQL, build dashboards and explain what changed and why. This is a fully remote position open to candidates anywhere in the US.

What you'll be doing:

• Create forecasts and simple models in Excel or Google Sheets
• Prepare weekly and monthly KPI reports for department leads
• Present results to managers and answer follow-up questions
• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Track sales, inventory or service levels against targets and flag misses early
• Write SQL queries against the data warehouse to pull and join data for analysis
• Investigate data quality issues and work with data engineering to fix them at the source
• Build and maintain dashboards in Tableau, Power BI or Looker

Required qualifications:

• 2-4 years of experience in a data or reporting analyst role
• Bachelor's degree in statistics, economics, business, math or a related field
• Habit of checking your own numbers before anyone else sees them
• Experience with at least one BI tool such as Tableau, Power BI or Looker
• Clear written and verbal communication with non-technical stakeholders
• Basic statistics: averages vs. medians, distributions, significance

Pluses:

• Industry background in retail, healthcare or logistics
• Tableau Desktop Specialist or Microsoft PL-300 certification
• Google Analytics 4 or Adobe Analytics

Pay and benefits:

Pay range: $93,000 - $115,000 per year. Final offer will depend on experience.

• Medical, dental and vision insurance
• 401(k) with company match
• Paid holidays
• Annual bonus
• Gym membership reimbursement

Start: Flexible.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Merrimack Goods.