Data Analyst, Supply Chain

The company underwrites workers' compensation for small and mid-sized employers. The role is new and comes from growth in our client base. This role supports operations and finance managers with weekly reporting, ad hoc analysis and KPI tracking. JG Mutual is hiring for the Data Analyst, Supply Chain role to answer business questions with data and turn the answers into reports people actually use. Remote position. Most of the team is in New York City, but nobody is required to come in. Hours are flexible, with one short team call each morning. A quiet workspace and good internet are required.

• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Build and maintain dashboards in Tableau, Power BI or Looker
• Clean and reconcile data from CRM, ERP and spreadsheet sources
• Investigate data quality issues and work with data engineering to fix them at the source

WHAT WE'RE LOOKING FOR

• 2+ years of experience in a data or reporting analyst role
• Advanced Excel: pivot tables, XLOOKUP, Power Query
• Strong SQL (joins, CTEs, aggregations, window functions)
• Experience with at least one BI tool such as Tableau, Power BI or Looker

The base pay range for this position is $81,000 - $107,000 a year. Actual pay depends on experience, skills and location.

We offer health, dental and vision coverage starting on day one, 401(k) with a 100% match up to 5%, paid time off, medical, dental and vision insurance, employee discount and referral program.

We read every application and reply within about a week.

Start: Flexible.

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