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

Mandatory Requirements

Expert 84+ Months

Desired Requirements

• At least 84-months Data Modeling experience in designing and creating DataMart, Data warehouse using Star & Snowflake Schemas in financial/Insurance industry
• At least 48-months experience with developing maintaining predictive systems written in R, using TIBCO TERR and Automation services.
• At least 48-months experience with TIBCO Spotfire Analyst, Web Player and Business Authors, using Iron Python, Java Scripts
• At least 48-months experience with Information Builders Software Toolset [WebFOCUS, iWay WebFOCUS Developer Studio, Data Migrator, and RSTAT]
• At least 48-month experience in developing, documenting, maintaining end to end ETL data pipeline using IBI Data Migrator.
• 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 84-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.
• The consultant will adhere to the client’s application development standards, including, but not limited to, project management methodology, SDLC (software development life cycle), Enterprise Architecture standards and the IT governance process. Support the BI Data Warehouse using TIBCO Spotfire, Information Builders software toolset: Data Migrator, WebFOCUS.

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:

Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

Our Consultants love working for IIT

Follow us on LinkedIn or Twitter or Facebook

IIT is an Equal Opportunity Employer