Data Analyst II

Commercial lines, personal lines and specialty programs are run as separate business units.

The position:

We are backfilling a position after an internal move. 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. Analyst role with a mix of recurring reporting and project work. Most of your day will be in SQL, Excel and Power BI or Tableau. This role is fully remote within the US. Normal business hours, Monday to Friday, with some flexibility. You will need a reliable internet connection and a quiet place to work.

Duties:

• Define metric logic with stakeholders and document it.
• Build and maintain dashboards in Tableau, Power BI or Looker.
• Analyze trends, cohorts and funnel drop-off and summarize findings in plain language.
• Prepare weekly and monthly KPI reports for department leads.
• Track sales, inventory or service levels against targets and flag misses early.
• Investigate data quality issues and work with data engineering to fix them at the source.
• Clean and reconcile data from CRM, ERP and spreadsheet sources.

What we're looking for:

• 3+ years of experience in a data or reporting analyst role.
• Able to juggle several requests and say when a deadline isn't realistic.
• Strong SQL (joins, CTEs, aggregations, window functions)
• Clear written and verbal communication with non-technical stakeholders.
• Advanced Excel: pivot tables, XLOOKUP, Power Query.
• Experience with at least one BI tool such as Tableau, Power BI or Looker.

Also helpful:

• Google Analytics 4 or Adobe Analytics.

Compensation and benefits:

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

• Health, dental and vision coverage starting on day one.
• 401(k) with a 100% match up to 5%.
• 12 weeks of paid parental leave.
• Annual bonus.

Galbraith Mutual provides equal employment opportunities to all employees and applicants.

Applicants must be authorized to work in the U.S.

Start: Immediately.

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