Transportation Planning and Management (TPM) is responsible for the safe, efficient, and environmentally responsible movement of people and goods on the City's streets, supporting the larger goals of economic and social vitality for people living, working, and doing business in New York City.
The Division’s responsibilities include roadway project planning, roadway design, technical analysis, maintenance of street signs, transit development, freight mobility, and roadway markings.
TPM’s Design & Construction (D&C) unit has professional engineering oversight for geometric design elements of NYC roadways.
We draw on expertise and talent of Civil Engineers, Urban Designers, Planners, Asset Managers, Inspectors, Administrators, Analysts, and others to evolve and maintain the curb geometry and street plans for all NYC’s + miles of roads, create and maintain official pavement marking and concrete island plans, and oversee the application and refurbishment of NYC’s + million linear feet of pavement markings (stripes, messages, colored surface treatments for bus / bike / plaza, etc.).
D&C is actively seeking a qualified candidate to fill the crucial role of Deputy Director of Data Engineering & Quality Management Systems.
In this pivotal position, the selected candidate will spearhead the development, management, and support of a sophisticated data platform, serving as the primary and trusted data source for structured and unstructured data within D&C in coordination with the larger agency.
This platform will play a vital role in enabling seamless data sharing among various stakeholders within the department and fostering collaborative efforts for analytics, reporting, and decision support.
The responsibilities for the Deputy Director position are multifaceted, covering various aspects of data management and governance.
This role involves designing, constructing, and maintaining data models, warehouses, lakes, and reporting solutions. A pivotal task is overseeing the implementation of an enterprise data lake house to establish a unified data source.
Infrastructure development for efficient data extraction, transformation, and loading from diverse sources is essential.
Additional responsibilities for the Deputy Director include implementing Data Management and Governance solutions, including relational and no-SQL technologies for on-prem and cloud deployments.
Managing an ETL development team, providing guidance and training, and collaborating with stakeholders to align data strategy with business objectives is vital.
Staying updated on ETL trends and improving development processes are key responsibilities. Active involvement in ETL development, query optimization, and support for testing phases is critical.
Collaborating with CADD / BIM teams to enhance project setups and maintaining quality standards is part of the role. Driving technological solutions to support survey, design, and construction divisions is essential.
Mentoring Junior ETL Developers and ensuring adherence to coding standards and best practices is integral to shaping the system's architecture and technology.
The Department of Transportation’s (DOT) mission is to provide for the safe, efficient, and environmentally responsible movement of people and goods in the City of New York and to maintain and enhance the transportation infrastructure crucial to the economic vitality and quality of life of our primary customers, City residents.
DOT is an equal opportunity employer, committed to recruiting and maintaining a diverse workforce in an open and inclusive environment.
Preferred Skills
1. Have working knowledge and experience with CRM applications, specifically Microsoft Dynamics CRM, and SQL database management tools specifically for implementing data transfer processes and mechanisms and content management.
2. Have working knowledge of Autodesk Vault, Civil 3D, AutoCAD, Microsoft Azure, Oracle OBIEE, Oracle OAS, Amazon Web Services, Socrata, or Cloudera.
3. Advanced experience with Excel (using complex functions, VBA, and similar functions), PowerPoint, Visio, Projects, and Power BI.
4. Ability to design system dashboards and reports and perform moderately complex analyses of agency services using Microsoft SQL Server, Microsoft Power BI, Citywide Performance Reporting (CPR) Analytics, or other business intelligence tools.
Train end users to create and manage customized dashboards. 5. Have experience modeling business process flows, workflow analysis, functional decomposition analysis, and data transfer processes.
6. Strong quantitative and problem-solving skills, and with ability to present data in various statistical formats. 7. Strong investigation, debugging, and issue resolution skills with the ability to set priorities.
8. Excellent interpersonal, verbal, and communication skills, with the ability to interface with senior management, and understand both business requirements and technical needs.
9. Excellent time management skills and the ability to independently prioritize. 10. Proficient with data defects / project tracking systems, such as JIRA, Azure DevOps, Test Rails, TFS, Microsoft Project Management, ServiceNow, or any similar systems.