Data Analyst - customer trends (Salt Lake City, UT)

Cedar Clear Transit Planning is a transit-planning firm in Salt Lake City working with agencies and riders, and we need a Data Analyst to lead our customer trends. You would join a small organisation of about 30 people based in Salt Lake City. What you will do • Answer ad-hoc questions with a short written summary, not a data dump. • Pull and clean data from several systems into one trustworthy dataset. • Build dashboards that managers actually open every week. • Document definitions so numbers mean the same thing everywhere. • Investigate trends in accessibility audits and explain what is driving them. What we are looking for • Strong SQL and spreadsheet skills. • Experience with a BI tool such as Power BI or Tableau. • The habit of checking a surprising number before presenting it. • Clear writing. Nice to have • Python or R for analysis. • Experience with data on route schedules. Working arrangement • Part-time, about 20 hours a week, spread across three days. • On site in Salt Lake City. • We will tell you what to expect at each step of the hiring process.