Data Analyst

NYC Department of Health and Mental Hygiene; New York (NY); On-site; USD 60,000 - 100,000; Full time

Benefits offered by this job

Public Service Loan Forgiveness

Diverse Work Environment

Community Engagement Opportunities

Job summary

An established agency is seeking a motivated Data Analyst to join their dynamic team. This role involves working with large datasets to analyze and visualize trip data for taxis and for-hire vehicles in New York City. You will leverage your analytical skills to identify trends and anomalies, contributing to critical projects that shape transportation policy. The ideal candidate will possess strong problem-solving abilities, proficiency in SQL and Python, and a passion for using data to inform public service initiatives. Join a collaborative environment where your insights will drive impactful changes in the city's transportation landscape.

Qualifications

• 2 years of experience in community work or related activities.
• Strong background in SQL and Python for data analysis.

Responsibilities

• Conduct statistical analysis and produce maintainable code.
• Build dashboards and manage complex data projects.
• Present findings to senior staff and stakeholders.

Skills

Statistical Analysis

SQL Queries

Python Programming

Data Cleaning

Data Visualization

Problem-Solving

Communication Skills

Education

Baccalaureate Degree

High School Graduation

Tools

Power BI

Tableau

Version Control Tools

Job description

Please note that candidates must have U.S. work authorization, as visa sponsorship is not available.

The New York City Taxi and Limousine Commission (TLC) is the city agency responsible for regulating for-hire transportation in New York City, including taxis, street hail liveries, high-volume for-hire services such as Uber and Lyft, black cars, luxury limousines, livery vehicles, commuter vans, and paratransit vehicles. The TLC licenses about 180,000 drivers, 116,000 vehicles, and 1,000 businesses, which together transport more than a million passengers a day, making TLC the most active for-hire transportation regulatory agency in the world with oversight of a key component of the City’s transportation network. TLC is on the front lines of a rapidly changing mobility landscape and our innovative efforts--whether regulating driver pay, ensuring wheelchair accessibility, working to eliminate traffic fatalities, or preventing discriminatory service--often serve as a model for other cities.

We are looking for a motivated Data Analyst to join our Data Analytics Unit within the Policy Division. You'll be working with large datasets, including detailed trip data for every taxi and for-hire vehicle in New York City. The Data Analyst will work closely with other team members to analyze, visualize, and validate trip data. This role is crucial in processing and analyzing large amounts of trip records, requiring prior experience with big data analysis. The data includes detailed information on passenger wait times, pickup and drop-off locations, minute-level breadcrumb pings, passenger costs, and driver pay.

We’re seeking a Data Analyst who is excited to work with big data to help shape transportation policy in NYC. Your work will involve critical thinking to identify any missing data anomalies and interesting trends in the data. You will be working both individually and with other team members on data analyses on our team’s ongoing projects such as fare regulation, driver pay, vehicle electrification, and charging infrastructure.

The Data Analyst will perform the following tasks:

1. Conduct statistical analysis and produce maintainable and reproducible code to inform policy.
2. Build dashboard pages.
3. Manage complex data projects.
4. Monitor data quality and completeness of trip data.
5. Present to senior staff and outside stakeholders.

Minimum Qualifications

1. A baccalaureate degree from an accredited college and two years of experience in community work or community centered activities in an area related to the duties described above; or
2. High school graduation or equivalent and six years of experience in community work or community centered activities in an area related to the duties as described above; or
3. Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least one year of experience as described in "1" above.

Preferred Skills

• Excellent research, writing, and verbal communication skills, effective problem-solving and data skills.
• Strong background writing SQL queries to extract meaningful data and answer small and big questions.
• Thoughtfulness about ensuring data accuracy and quality assurance.
• Prior experience with Python to read and transform large amounts of data and deliver clean and well-organized code.
• Experience with a version control tool and data documentation.
• Passionate about analyzing big data to inform policy in government or public service.
• Solid foundation in data cleaning and Exploratory Data Analysis.
• Solid foundation in statistical analysis, math, and probability.
• Ability to translate quantitative analysis into actionable insights through presentations, reports and dashboards using BI tools such as Power BI or Tableau and writing Python and SQL scripts.
• Willingness to learn new technologies.
• Collaborative mindset.

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

Residency Requirement

New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview.

Additional Information

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.