Deputy Director of Data Engineering & Quality Management Systems - Design & Construction Unit

City of New York
QUEENS
$71.3K-$120K a year
Full-time

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.

30+ days ago
Related jobs
Promoted
LESC
New York, New York

Experience: Minimum of 10-15 years of experience in facilities management, preferably in a non-profit or healthcare setting. Team Leadership: Lead, mentor, and manage a team of facility mechanics and porters, ensuring high performance, effective communication, and professional development. Facility ...

Promoted
Salesforce
Queens, New York

Each of us has a responsibility to drive Equality in our communities and workplaces. We’re Salesforce, the Customer Company, inspiring the future of business with AI+ Data +CRM. This role is an opportunity to shape the future of work by infusing AI into our products to make them more intelligent, ef...

Promoted
startus
Queens, New York

In this role, you’ll help multiple teams find better ways to combine our understanding of music with our 140M+ users’ unique tastes and preferences, helping music fans listen longer, find new artists they love, and come back to Spotify more often. Work closely as part of a tight-knit team with your ...

Promoted
JellyFish
Queens, New York

We’ve got an exciting opportunity here at Jellyfish! We are looking for a Director of Integrated Project Management to join our Emmy Award-winning team, working with one of our partners - a top global streaming service. Director of Integrated Project Management. Jellyfish is a global digital marketi...

Promoted
C5ISR (Gichner Systems Group, Inc.)
New York, New York

Improve Mechanical Engineering Department effectiveness in the areas of quality, productivity and innovation in product design. This position is responsible for management of the Mechanical Engineering Department. Management responsibilities include assigning resources to the various Engineering Pro...

Promoted
City of New York
New York, New York

A baccalaureate degree in computer science, engineering or a related field from an accredited college and four years of satisfactory full-time experience related to IT automation engineering, monitoring engineering, management of infrastructure; or. Eight years of satisfactory full-time experience r...

Mediabistro
New York, New York

This role reports to the Vice President of Product Design of Commerce. Partner with Product Management, Engineering, and other internal partners to define the strategy & experience of consumer facing products. We believe that our workforce should represent the communities we live in, so that togethe...

Center for Justice Innovation
New York, New York

This includes collaborating with our Data Analytics and Applied Research team, the projects we collectively serve, and other administrative units to deliver solutions that put usability and utility at the forefront; Provide management, mentorship and guidance to the department’s software devel...

City of New York
Queens, New York

The NYC Department of Design and Construction, Safety and Site Support Division, seeks a Deputy Director in the Office of Construction Safety. The Deputy Director will be directly responsible for all construction safety related activities, including supervision of a group of Safety Accident Investig...

City of New York
New York, New York

Knowledge of and experience in transportation policy, transportation planning, transportation operations and management or transportation technology Knowledge of the technical aspects of transportation infrastructure the ability to think and act strategically experience analyzing, interpreting, and ...