*** In order to be considered for this position candidate must be serving permanently in the civil service title of Administrative Quality Assurance Specialist or be reachable on the open competitive civil service list or be eligible under the 55-a Program. ***

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 6300+ miles of roads, create and maintain official pavement marking and concrete island plans, and oversee the application and refurbishment of NYC’s 250+ 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 365 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.

Additional Information:
This position may be eligible for remote work up to 2 days per week, pursuant to the Remote Work Pilot Program agreed to between the City and DC37.

Work Location:
33-00 Northern Blvd, LIC, 11101

Hours/Shift:
Monday - Friday, 35 hrs.

To Apply:
All resumes are to be submitted electronically using one of the following methods:
External applicants, go to www.nyc.gov/careers and search for Job ID # 643636
Current city employees, log into Employee Self Service at www.nyc.gov/ess and follow the Careers link and search for Job ID # 643636
No phone calls, faxes or personal inquiries permitted.
Only those applicants under consideration will be contacted.
Most public libraries have computers available for use.
Note: New hires must reside in NYC for the first two years of employment. Appointments are subject to OMB approval.
For more information about DOT, visit us at: www.nyc.gov/dot.

1. A baccalaureate degree from an accredited college and four years of satisfactory full-time experience in purchasing and or inspecting supplies, materials, products and services such as: paints, linoleum, hose, sand, brick, wire, shades hardware and tools, plumbing, electrical machine shop, building and cleaning supplies; furnishings and furniture, lumber and wood related products, metals, equipment, foods, drugs and chemicals, fuel, textiles, printing, stationery, automotive equipment and/or repairs, transportation services and other comparable items and/or services; at least eighteen months of which must have been in a supervisory, administrative or managerial capacity; or

2. An associate degree from an accredited college, plus six years of satisfactory fulltime experience as described in "1" above, at least eighteen months of which must have been in a supervisory, administrative or managerial capacity; or

3. A four-year high school diploma or its educational equivalent and eight years of satisfactory full-time experience as described "1" above, at least eighteen months of which must have been in a supervisory, administrative or managerial capacity; or

4. A satisfactory combination of education and/or experience equivalent to "1", "2" or "3" above. Undergraduate college credit may be substituted for experience on the basis of 45 semester credits from an accredited college for one year of experience. However, all candidates must have a high school diploma or its educational equivalent and at least three years of satisfactory full-time experience as describe in "1" above, at least eighteen months of which must have been in a supervisory, administrative or managerial capacity.

1. Have working knowledge and experience with CRM applications, specifically Microsoft Dynamics 365 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.

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.