Company: Optimal Solutions and Technologies
Posted on: November 22, 2020
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
ENGAGEMENT LENGTH IN MONTHS:
WHAT ARE THE DAILY WORK HOURS*
WHERE IS THE PHYSICAL WORK OFFICE LOCATED*
15 Computer Drive West Albany NY 12205
DESCRIPTION OF SPECIFIC DUTIES IN A TYPICAL WORKDAY FOR THIS
The duties of the consulting resource
Provide recommendations, guidance and actual implementation for new
data marts, as well as improving and consolidating existing Data
Participate and contribute to DW/BI projects throughout the project
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
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 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.
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
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
5 years of experience in VB.Net, C#, .Net TFS, Visual Studio, Gits,
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
Didn't find what you're looking for? Search again!