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
9970 Menands, NY 12204 Data Warehouse Architect - Medicaid/ MITA, ETl, PL/SQL, Unix, 3NF, Dimension, Hadoop, Vertica 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=9970 (Data Warehouse Architect - Medicaid/ MITA, ETl, PL/SQL, Unix, 3NF, Dimension, Hadoop, Vertica) in Menands NY 12204 (SJU)

Estimated Length: 24 months Full-Time Negotiable Hours

Mandatory Requirements

Expert 84+ Months

Desired Requirements

  • Bachelor’s Degree in Information Technology or Computer Science or similar field of study. 
  • 84 Months of experience with data modelling including 3NF and Dimensional/Data architecture for business intelligence and reporting in a Data Warehouse environment
  • 84 months’ professional experience in Information Technology designing / architecting / managing / directing medium to large data centric deployments including experience with Oracle, Vertica, Hadoop and such. 
  • 84 months’ professional experience in assisting with design, architecture, development, and implementation of medium to large critical business application (data centric) based deployments and environments. 
  • 48 Months of experience in decision support / real time data analytics / business intelligence environments utilizing Business Intelligence tools. 
  • 48 Months of experience in creating technical architecture artifacts for logical and/or physical data models, information architectures, large application architecture or similar for the critical business applications in health IT domain.
  • 84 Months of Experience in writing complex SQL, PL/SQL and UNIX code for Reporting and Data Extraction.
  • 48 Months Experience with Medicaid Data and MITA Information Architecture 
  • 84 Months of experience with data acquisition, cleansing, and integrations processes (ETL, ELT).

Responsibilities

  • Create an Information Architecture that supports the modernization of current MDW environment into alignment with MITA 3.0 framework as well as meeting business requirements.
  • Create a Data Models and Data Management Plan to meet Medicaid business requirements, by leveraging existing and emerging big data technologies. 
  • Create a Logical Data Model and Architecture plans that allows migration from existing MDW environment to next generation Medicaid Enterprise MDW and MAPP environment.
  • Create Data Standards that aligns with DSRIP and VBP business requirements as well as to support future data centric applications with Medicaid Enterprise.
  • Create an Information Capability Matrix and all other architecture artifacts required by the project.
  • Review the current documentation of the current vendor to facilitate the completion of the above
  • Perform collaborative research and provide recommendations to Medicaid Enterprise leadership.
  • Participate in Data Governance Meetings and support management team for overall architecture and design activities.
  • Review new and existing data designs including data lakes, SQL, No-SQL, and ETL, ELT applications to ensure correctness and provide required feedback, comments and recommendations as appropriate.
 
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