Dash Job - Data Analyst - NYC School Bus Umbrella Services (USA)

:mega: Plotly Dash Skills: Experience with front end development like Plotly Dash.

Company: NYC School Bus Umbrella Services

Title: Data Analyst

Category: Full Time

Location: Brooklyn, NY (On-site)

Experience: 1-2 years data engineering experience is required

Application: Link to apply

@OpenToWork


About the job

NYCSBUS (New York City School Bus Umbrella Services Inc.) is a newly formed not-for-profit corporation that provides school bus transportation services to New York City public and private school students, the majority of whom have Individualized Educational Programs. It operates approximately 800 school bus routes with a staff of approximately 1,800 people from six locations with a budget of $190 million. NYSCBUSs goal is to radically improve student bus transportation by innovating in all areas and by providing unprecedented transparency in bus operations to school districts that outsource this service.

We are excited to hire an early career Data Engineer to develop automated and data-centric workstreams for school bus operations. This position reports to the Head of Data Science and Analytics and will work closely with the CIO. The IT & Data team has decades of experience, developing and implementing data science and analytics infrastructure. You will be supported and actively mentored to succeed in your role.

Note, this is an on-site position, based primarily in our Greenpoint, Brooklyn depot. Travel to our depots in Jamaica, Bronx and Staten Island may be required on occasion.

Primary Responsibilities include but not limited to

  • Data modeling: design, extend and implement our data model.
  • Data infrastructure: Develop, deploy, monitor, and maintain ETLs on Airflow & Databricks
  • Data Cleaning: keep data clean and accurate with data sources (Internal & 3rd Party)
  • Data Transformations: implement the logic of the data pipeline (aggregations, projections, selections, etc.)
  • Design and implement end-to-end data automation flows: from data ingestions for data science modeling to creation of automated pipelines to external software.
  • Be expected to work alongside colleagues in our bus yards in Greenpoint, Jamaica, Bronx, and Staten Island

Education and Experience

  • Bachelors degree in IT, data science, or related field
  • 1-2 years data engineering experience is required

Qualifications

  • Strong Python and SQL skills
  • Strong Knowledge of data structures (DataFrames, RDDs, Dataclasses) and data formats
  • Experience installing data architectures on Cloud providers (e.g. AWS), using DevOps tools and automating data pipelines.
  • An ability to design, implement and deliver maintainable and high-quality code using best practices (e.g. git/github, secrets, configurations, yaml/json)
  • Experience with data modeling, design patterns, building highly scalable and secured solutions is preferred
  • Familiarity with data orchestration tools like Airflow or similar
  • Experience with implementing Data Quality checks
  • Experience with some front end development like Plotly Dash or R-Shiny is a plus