Job Description 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 175,000 drivers, 115,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. With the introduction of new apps and technologies, 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. The successful candidate will serve as a Data Engineer / Architect reporting to the Director of IT in the IT division. Responsibilities will include: - Research, perform and manage the deployment of data and data objects changes to all TLC database environment. - Design and implement standards for resource provisioning in Azure Cloud. - Perform administrative duties for resources provisioned in Azure Cloud including monitoring of health, availability, reliability and performance. - Setup dashboards demonstrating current and forecasted cost of cloud (Azure) resources. - Ensure Installation, maintenance and configuration of database servers, Integration tools (SSIS, Informatica etc), Reporting tools (SSRS, PowerBI etc) on all environments meet TLC’s data processing requirements. - Research, design and develop current processes to automate standard data administration tasks to streamline manual processes. - Investigate root cause, monitor and respond to production issues, outages, etc. - Create and maintain database queries, stored procedures, SQL Jobs, SSIS packages, SSRS reports, and other data and database components required to support critical business and applications - Investigate, tune and troubleshoot SQL, queries to ensure they are performing optimally - Document data designs, processes, solutions and root cause analysis results - Research and support legacy applications data, and ad hoc reports from other divisions. - Analyze and organize raw data. - Build data systems and pipelines - Evaluate business needs and objectives - Investigate and interpret trends and patterns - Prepare data for prescriptive and predictive modeling - Combine raw information from different sources - Research ways to enhance data quality and reliability - Investigate and identify opportunities for data acquisition Qualifications 1. A baccalaureate degree from an accredited college and six years of satisfactory full-time experience related to the area(s) required by the particular position; or 2. Education and/or experience which is equivalent to "1" above. 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.