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 , drivers, , vehicles, and 1, 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
Minimum 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.
Preferred Skills
The preferred candidate should possess the following skills : -Experience writing SQL Server Integration Services (SSIS) packages for ETL and SQL Server Reporting Services (SSRS) for reports-Experience in data modeling, database design and well versed with DBMS best practices-Experienced in on-premises and cloud SQL Servers installations-Experience optimizing and tuning queries-Experience administering databases is a plus-Experience with Power BI is a plus-Experience with Informatica is a plus- Ability to see tasks through to completion without significant guidance- Strong issue resolution and investigation skills- Ability to articulate and document the steps taken to resolve an issue.
- Strong oral and written communication skills and the ability to clearly articulate to all project members and stakeholders.
- Flexibility to work overtime as required (may need to work various shifts to support deployments or production validation activities during peak times).
One or more of the following certifications are preferred : -Microsoft Certified : Azure Database Administrator Associate-Microsoft Certified SQL Database Administrator
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 class "jobad-residencyRequirement">
Residency RequirementNew York City Residency is not required for this position