Database Administration - Data Warehouse (DW) Consultant (hybrid remote / onsite in NYC)
New York City, NY
JOB TITLE: Database Administration - Data Warehouse (DW) REQUIREMENT # 2334 LOCATION: HYBRID (one week in NYC / one week remote) DURATION: 12+ months
NOTE This is a 40 hour work week RATE: $65-$70 per hour ** we can work EITHER w2 or C2C – candidates choice **candidates MUST currently be local to the NYC area
SUMMARY OF ROLE & RESPONSIBILITIES:
The C&D (Construction & Development) team is developing a central data warehouse called the ISIM-B Program (Integrated Service Information and Management “B” Division) with the goal of building analytics that aims to improve the passenger experience for riders by pursuing and addressing various elements of the subway system.
The Data Warehouse is intended to provide NYCT with information about the effectiveness, timeliness and quality of the various services that NYCT delivers and to provide operational insights to management at various levels.
This position will be responsible for developing data pipelines to move data between source and target systems. (Extracting data from the source systems and transforming/loading it into the Data Warehouse, which is our target). These pipelines can be ETL/ELT jobs for building data warehouse/reporting solutions.
Responsible for requirement-gathering, analyzing and developing requirements and design specifications, data modeling building the data pipelines and performance optimization for Data warehouse/data lake.
7-9 years overall experience
Significant experience with data modeling (conceptual, logical and physical model design), architecture, and performance optimization.
Expert level understanding of ETL fundamentals and building efficient data pipelines using Extract Transform Load (ETL) tools such as SSIS.
Experience with cloud data movement and compute technologies including Azure Data Factory, Logic App, Data Bricks and storage technologies including Azure Managed instance, Azure Data Lake, Azure synapse analytics.
Experience with major database platforms including Oracle, SQL Server as well as Cloud databases. NOSQL experience is a plus.
A deep understanding of relational database technologies, dimensional Modeling, Operational Data Stores, Enterprise Data Warehouses and Data Marts.
Advanced data processing, programming skills using SQL-based technologies, as well as other languages like Python.
Experience in modern DevOps practices (including Git, CI/CD)
Experience in designing, enhancing, and/or modifying data warehouses
Experience working in an Agile environment.
ETL (Extract Transform Load) - 6 + Years- Oracle - 6 + Years SQL - 6 + Years SQL Server - 6 + Years Data Analysis - 6 + Years Data Modeling - 6 + Years Data Warehousing - 6 + Years Python Scripting - 6 + Years
If you are interested in pursuing this opportunity, please respond back and include the following: • Full MS WORD Resume • Current and required compensation • Contact information • Availability
Upon receipt, one of our managers will contact you to discuss in full