The New York City Taxi and Limousine Commission (TLC) is the agency responsible for regulating New York City's taxicab and for-hire vehicle industry. TLC licenses and regulates over 130,000 vehicles and more than 175,000 drivers, making it the most active taxi and limousine regulatory agency in the United States. Aside from vehicles and drivers, TLC also regulates taxicab agents and for-hire vehicle bases, including popular app-based transportation services. The TLC plays a pivotal role in furthering public safety within New York City and is a lead agency in a citywide effort to reduce traffic-related injuries. One of the largest components of TLC’s operations is the enforcement of agency and administrative code regulations.

The Prosecution Division investigates and prosecutes all summonses issued by TLC which amounts to over 100,000 summonses each year. Under the supervision of the Director of Administrative Summonses and Data Analytics, the Data Analyst will be responsible for generating administrative violations and otherwise supporting prosecutors by providing relevant data reports and information.

Selected candidate responsibilities may include, but are not limited to:
- Create server data sets and re-usable queries using Microsoft SQL Management Studio.
- Prepare data reports as needed using Microsoft Excel
- Download and electronically distribute various documents from various electronic data sources.
- Use an in-house web-based CRM system for importing and tracking various violations.
- Create violation templates and import files for the in-house CRM system.
- Work with appropriate parties on legally acceptable language used in generated violations.
- Contact licensees to provide technical support for various electronic data submission streams.
- Generating scheduled and on-off TLC administrative violations
- Updating various information in TAMIS system upon request
- Downloading and analyzing NYS DMV abstracts or related database information
- Suspending and unsuspending licensees’ TLC license upon request

ADMINISTRATIVE STAFF ANALYST ( - 1002D

1. A master's degree from an accredited college in economics, finance, accounting, business or public administration, human resources management, management science, operations research, organizational behavior, industrial psychology, statistics, personnel administration, labor relations, psychology, sociology, human resources development, political science, urban studies or a closely related field, and two years of satisfactory full-time professional experience in one or a combination of the following: working with the budget of a large public or private concern in budget administration, accounting, economic or financial administration, or fiscal or economic research; in management or methods analysis, operations research, organizational research or program evaluation; in personnel or public administration, recruitment, position classification, personnel relations, employee benefits, staff development, employment program planning/administration, labor market research, economic planning, social services program planning/evaluation, or fiscal management; or in a related area. 18 months of this experience must have been in an executive, managerial, administrative or supervisory capacity. Supervision must have included supervising staff performing professional work in the areas described above; or

2. A baccalaureate degree from an accredited college and four years of professional experience in the areas described in "1" above, including the 18 months of executive, managerial, administrative or supervisory experience, as described in "1" above.

- An Associate's degree in Computer Science, Computer Information Systems or an equivalent degree. - Two or more years of relevant paid work experience with computerized data. - Working knowledge of Microsoft Excel. - Familiarity with Microsoft Access or Microsoft SQL Management Studio preferred. - Self-motivated, quick and assertive. - Uses different forms of communication in order to get the correct message across. - Uses different forms of data analysis. - Work with people, develop and maintain work relationships, communicate and manage conflict. - Ability to prioritize. - Ability to aggregate notes and data. - Ability to work in a team as well as independently. To Apply: Please go to cityjobs.nyc.gov and search for Job ID# 703433 or click the "Apply" button below. SUBMISSION OF A RESUME IS NOT A GUARANTEE THAT YOU WILL RECEIVE AN INTERVIEW. APPOINTMENTS ARE SUBJECT TO OVERSIGHT APPROVAL. Location: Lng Island City

This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.

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/.

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.

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.