Senior Data Analyst

Overview

This candidate will serve as a Senior Data Analyst in NYC DOT’s Bike Share & Shared Mobility unit, which is responsible for planning and oversight of the Citi Bike program and other shared micro mobility services in New York City. Citi Bike is a public transportation service and a public-private partnership that is among the largest and most successful bike share systems in the world.

The program is in the latter stages of a five-year expansion that will ultimately double the size of its previous service area and put more than 40,000 bicycles within a five-minute walk of half of NYC residents. Other shared micro mobility services in NYC include dock less e-scooter services in the East Bronx and eastern Queens.

We are seeking a Senior Data Analyst to join our team and play a pivotal role in shaping how we understand, monitor, and optimize our shared mobility systems. This individual will combine data analytics, advanced visualization, and strategic storytelling to translate complex data from Citi Bike and Shared E-Scooter programs into actionable insights that inform planning and day-to-day operations. The ideal candidate thrives at the intersection of analytics and communication — able to uncover patterns, craft compelling narratives, and partner with internal team members at all levels to drive informed decision-making.

• Data Analytics & Research:
  Conduct research and analysis on bike share and shared mobility to inform current and future planning;
  Prepare reports and briefing materials based on the databases that underlie the bike share and shared mobility systems;
  Monitor vendor compliance with governmental regulations, DOT policies, and contract terms;
  Develop predictive models to answer complex and nuanced questions about the programs and anticipate future needs and behavior of the systems;
  Respond quickly and accurately to ad hoc data requests for internal and external stakeholders.

• Visualization & Storytelling:
  Develop and maintain dashboards to deliver insights to internal team members using software such as Power BI;
  Translate data into stories that resonate with senior staff, managers, and staff, highlighting both the "what" and the "why".

• Strategic Thinking & Partnership:
  Collaborate with leadership, Operations, Planning, and Policy teams to align analytics and research agendas with organizational priorities;
  Offer evidence-based recommendations to support system planning, managing existing service areas, and shaping future policy decisions;
  Act as a trusted advisor and build strong relationships with internal team members.

• Data Management:
  Monitor data quality, identify issues, and maintain data integrity;
  Document data management procedures (e.g., data dictionaries, business rules);
  Plan, design, maintain, and support unit internal databases.

Note:

CITY RESEARCH SCIENTIST - 21744

• For Assignment Level I, a master's degree from an accredited college or university with a specialization in an appropriate field of physical, biological or environmental science or in public health.
• To be appointed to Assignment Level II and above, candidates must have one of the following: a doctorate degree with specialization in an appropriate field of physical, biological, environmental or social science and one year of supervisory/administrative/research experience; or a master's degree with specialization and three years of responsible full-time research experience; or equivalent combination with at least a master’s degree and two years of additional qualifying experience.
  
  Two years as a City Research Scientist Level I can be substituted for the above.

• Mastery with spreadsheets and at least one coding language (Python, R) for data manipulation;
  Experience querying, cleaning, and maintaining large relational databases using SQL;
  Experience with data visualization software such as Power BI and/or Tableau;
  Statistics support including methodology, study design, and data analysis;
  Proficiency with presentation slides, data visualization, maps, and memos; ability to relate complex trends to policy issues; strong interpersonal and communication…