Current Openings

Systems Architect

Albany, NEW YORK | Contract
Post Date: 10/26/20
Job ID: 20-01019
Job Type: Contract

Job Description

Job Title : Systems Architect
Location : Albany NY
Duration : 30+ Months (More Likely to Extend)
Interview : Either Webcam Interview or In-Person

Job Description:
Continue the effort of building Enterprise Data Warehouse, consolidating/retiring multiple existing legacy Data marts with the goal of eliminating unnecessary duplication and establish single source of truth to increase efficiency in BI team and reduce maintenance cost.

The duties of the consulting resource
  • Provide recommendations, guidance and actual implementation for new data marts, 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. (R, Python)
  • 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 (analysis, dashboards and automation services)
  • Automation of source system data extraction processes and data loading of the Data Warehouse.
  • Support and maintain the yearly WCRI Data Request.
The consultant will adhere to application development standards, including, but not limited to, project management methodology, SDLC (software development life cycle), Enterprise Architecture standards e process. Support the BI Data Warehouse using TIBCO Spotfire, Information Builders software toolset: Data Migrator, WebFOCUS.
Desired Skills:
  • 72-months Data Modeling experience in designing and creating DataMart, Data warehouse using Star & Snowflake Schemas in workers Compensation Insurance and disability industry.
  • At least 60-months experience with developing and maintaining end to end ETL data pipeline using IBI Data Migrator.
  • 48-months experience with TIBCO Spotfire Analyst, Web Player and Business Authors, using Iron Python, Java Scripts
  • 18-months experience with Information Builders Software Toolset [WebFOCUS, iWay WebFOCUS Developer Studio, Data Migrator, and RSTAT]
  • At least 48-months experience in with WCRI data reporting.
  • 48-month developing, testing, and implementing data warehouse in Workers' Compensation Insurance industry
  • 72-months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design and implementation.
  • 48-month experience with Innotas
  • 24-month experience in Active Batch, PowerShell and Visual Build Pro
  • 60-month experience in VB.Net, C#, .Net TFS, Visual Studio, Gits, Azure DevOps