Data Analyst - dashboard development (remote)

Westbrook Fern Transit Planning Group helps transport agencies around Salt Lake City design routes and schedules. We are hiring a Data Analyst to take on dashboard development. You would join a large organisation of more than 1,000 people, working mostly from home. What you will do • Answer ad-hoc questions with a short written summary, not a data dump. • Document definitions so numbers mean the same thing everywhere. • Pull and clean data from several systems into one trustworthy dataset. • Recommend changes and measure whether they worked. • Investigate trends in fare systems and explain what is driving them. What we are looking for • Strong SQL and spreadsheet skills. • Clear writing. • The habit of checking a surprising number before presenting it. • Experience with a BI tool such as Power BI or Tableau. Nice to have • Experience with data on service alerts. • Python or R for analysis. Working arrangement • Full-time, Monday to Friday. • Fully remote, with quarterly visits in Salt Lake City. • We will tell you what to expect at each step of the hiring process.