IIT Inc. Home

IIT Jobs Data Bank-Job Detail

Submit Resume For This Job (via email)
Follow us on LinkedIn or Twitter or Facebook
Follow us on Facebook Follow us on LinkedIn
ID Location Skills $$ Job Type Status
14120 Downtown Manhattan, NY 10004 Data Warehouse (DW): data modeling, architecture, ETL, SSIS, Azure Data Factory, Oracle, SQL, Python DOE Contract OPEN
If you are unable to click on links above to submit resume, you may email your resume to
jobs@iit-inc.com    

Subject=IIT Career Site/Resume for JobID=14120 (Data Warehouse (DW): data modeling, architecture, ETL, SSIS, Azure Data Factory, Oracle, SQL, Python) in Downtown Manhattan NY 10004 (ALL)

Estimated Length: 12 Months Work hours:40.00 Est. OT Hrs/Wk:

Requirements

*PLEASE NOTE THIS POSITION WILL ALLOW CONSULTANT TO WORK REMOTELY. HOWEVER, CONSULTANT WILL BE REQUIRED TO COME ONSITE AS NEEDED BY THEIR MANAGER/TEAM (AT THEIR OWN EXPENSE).


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.


REQUIRED 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.


SKILLS REQUIRED:

- 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.

 

 

 
Submit Resume For This Job (via email)
 
Don't See a Position Matching Your Skills?
Click here to Email / Register your resume and be notified of future job openings.
 
About IIT:

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

  • Consulting for projects / IT Outsourcing
  • IT staffing (Contract / Temporary / Contingent / Consulting)
  • Custom Workforce Solutions
  • Recruitment Process Outsourcing (RPO)
  • Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

  • Winner of Inc-500 award 2 consecutive years
  • Winner of Ernst & Young / USPAACC Fast-50 award 2 consecutive years
  • Winner of USPAACC Top-10 Award in the Northeast US
  • IBM Business Partner
  • Oracle Business Partner
  • Adobe Business Partner
  • NYSA Member - New York Staffing Association - Regional Affiliate of ASA / American Staffing Association
  • NYS MBE certified
  • Our Consultants love working for IIT

  • Competitive compensation
  • W2 or C2C
  • Biweekly Direct Deposit for W2 Consultants
  • Visa and Green Card sponsorship opportunities for qualified individuals
  • Local contact for you to meet and talk to anytime (not someone sitting overseas in a different time zone)
  • Follow us on LinkedIn or Twitter or Facebook

    IIT is an Equal Opportunity Employer