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
10158 Albany, NY 12205 Data Warehouse Architect: Star/Snowflake, TIBCO Spotfire, ETL, IBI Data Migrator, Worker's Comp 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=10158 (Data Warehouse Architect: Star/Snowflake, TIBCO Spotfire, ETL, IBI Data Migrator, Worker's Comp) in Albany NY 12205 (SJU)

Estimated Length: 24 months Full-Time 8:30 am to 5 pm

Mandatory Requirements

Senior (60-84 months)

Desired Requirements

  • At least 72-months Data Modeling experience in designing and creating DataMart, Data warehouse using Star & Snowflake Schemas in financial/Insurance industry
  • At least 24-months experience with developing and maintaining end to end ETL data pipeline using IBI Data Migrator.
  • At least 24-months experience with TIBCO Spotfire Analyst, Web Player and Business Authors, using Iron Python, Java Scripts
  • At least 18-months experience with Information Builders Software Toolset [WebFOCUS, iWay WebFOCUS Developer Studio, Data Migrator, and RSTAT]
  • At least 36-month experience in with WCRI data reporting.
  • At least 24-month experience in developing data warehouse in Workers’ Compensation Insurance industry (Medical Billing, Claims, DBL, PFL, Underwriting, Premium and payroll) 
  • At least 72-months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design and implementation.
  • At least 24-month experience with Innotas
  • At least 24-month experience with HP Quality Center
  • At least 24-month experience with Blueprint requirement tools

Responsibilities

  • Provide recommendations, guidance and actual implementation for new BI/DW projects, as well as improving and consolidating existing Data marts.
  • Participate and contribute to DW/BI projects throughout the project lifecycle.
  • Establish written best practices, procedures and generally provide guidance on DW/DM data model design
  • Create and maintain up-to-date documentation for all supported DW/DM, ETL…
  • Plan, create, modify, maintain, test and implement code in support of any of the following:
    • Source System extraction processes for the Data Warehouse.
    • ETL processes.
    • BI Dashboards and reports.
  • Extract business rules from existing Data Warehouse built with Information Builders software toolset: WebFOCUS, , RSTAT, Data Migrator, and Performance Management Framework (PMF). 
  • Develop and maintain Spotfire systems (including prediction models written in R, TERR and automation services)
  • Automation of source system data extraction processes and data loading of the Data Warehouse.
 
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