Data Modeler-10936

Company: Optimal Solutions and Technologies
Location: Albany
Posted on: November 22, 2020

Job Description:

POSITION: Data Modeler-10936

LOCATION: Albany, NY

JOB ID: 4860-RCAT-4

# OF OPENINGS: 1

-------------------------

Optimal Solutions & Technologies (OST, Inc.) is focused on excellence. We specialize in providing Management Consulting, Information Technology, and Research Development and Engineering services. OST is one of an elite set of companies worldwide to be externally appraised CMMI Level 5.

The fundamental distinction of the OST team is its business knowledge in both the public and private sectors. We serve the aerospace & transportation, association & nonprofit, defense, education, energy, financial, healthcare, and technology & telecommunications industries. OST is successful because we listen to our clients, we learn from our clients, and we know our clients.

ENGAGEMENT LENGTH IN MONTHS:

30 Months

WHAT ARE THE DAILY WORK HOURS*

08:30am 5:00pm

WHERE IS THE PHYSICAL WORK OFFICE LOCATED*

15 Computer Drive West Albany NY 12205

DESCRIPTION OF SPECIFIC DUTIES IN A TYPICAL WORKDAY FOR THIS POSITION:
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:
o Source System extraction processes for the Data Warehouse.
o ETL processes.
o 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 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 toolset: Data Migrator, WebFOCUS.

POSITION REQUIREMENTS:
6 years Data Modeling experience in designing and creating DataMart, Data warehouse using Star & Snowflake Schemas in workers Compensation Insurance and disability industry.
At least 5 years of experience with developing and maintaining end to end ETL data pipeline using IBI Data Migrator.
4 years of experience with TIBCO Spotfire Analyst, Web Player and Business Authors, using Iron Python, Java Scripts
1.6 years of experience with Information Builders Software Toolset [WebFOCUS, iWay WebFOCUS Developer Studio, Data Migrator, and RSTAT]
At least 4 years of experience in with WCRI data reporting.
4 years developing, testing, and implementing data warehouse in Workers' Compensation Insurance industry
6 years of experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design and implementation.
4 years of experience with Innotas
2 years of experience in Active Batch, PowerShell and Visual Build Pro
5 years of experience in VB.Net, C#, .Net TFS, Visual Studio, Gits, Azure DevOps

OST is an equal opportunity employer. Applicants are considered for positions without regard to race, religion, gender, native origin, age, disability, or any other category protected by applicable federal, state, or local laws.

Keywords: Optimal Solutions and Technologies, Albany , Data Modeler-10936, Other , Albany, New York