Systems Architect DataMart Data warehouse Star amp Snowflake Schemas Worker Comp ETL Python

Profile

HBITS-04-12682
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, and BI Dashboards and reports.
Develop and maintain Spotfire systems (including prediction models and automation services)
Automation of source system data extraction processes and data loading of the Data Warehouse.
Operationalize prediction models
The consultant will adhere to NYSIF'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 Data Migrator
Systems Architect
Defines the architecture of a computerized system (i.e., a system composed of software and hardware) in order to fulfill certain requirement, including a breakdown of the system into components, the component interactions and interfaces (including with the environment, especially the user), and the technologies and resources to be used in the design.
Senior 60 - 84 months: Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education. 84 months Data Modeling experience in designing and creating DataMart, Data warehouse using Star & Snowflake Schemas in workers Compensation Insurance and disability industry.
84 months experience with developing and maintaining end to end ETL data pipeline using IBI Data Migrator.
60 months experience with TIBCO Spotfire Analyst, Web Player and Business Authors, using Python, Java Scripts.
18 months experience with Information Builders Software Toolset [WebFOCUS, iWay WebFOCUS Developer Studio, Data Migrator, and RSTAT]
48 months experience in with WCRI data reporting.
60 months developing, testing, and implementing data warehouse in Workers' Compensation Insurance industry
84 months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design and implementation.
48 months MS SQL Server and T-SQL experience
24 months experience in Active Batch, PowerShell and Visual Build Pro
60 months experience in VB.Net, C#, .Net TFS, Visual Studio, Gits, Azure DevOps
****
Local:
518-218-1700
Map
& visit our office
Corporate - Albany NY
435 New Karner Rd, Ste 202
Albany NY 12205
Chicago
63E Lake Street, Ste 201
Chicago, IL 60601
Florida
17258 SE 121st Ave
Summerfield, FL 34491
© 2018 MVP Consulting Plus. All Rights Reserved.

Company info

Sign Up Now - MiamiCrossing.com