AlbanyNYRecruiter Since 2001
the smart solution for Albany jobs

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

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


Need a gig? Deliver with Uber Eats
Description: Need a gig Deliver with Uber Eats Schenectady, NY 2854 C2-79720 Deliver with Uber. Earn on your schedule. Work on your schedule. Deliver for a few hours in the mornings, every night, or just on weekends (more...)
Company: Uber Eats
Location: Schenectady
Posted on: 12/2/2020

Information Technology Analyst II #20-4000-022
Description: State of Connecticut Judicial Branch East Hartford Information Technology Analyst II The State of Connecticut Judicial Branch is seeking an Information Technology Analyst II responsible for software (more...)
Company: State of CT Judicial Branch
Location: East Hartford
Posted on: 12/2/2020

Licensed Counselor - Work from home online
Description: Private practice with no doors and no overhead. br br Join the world's largest online counseling platform. br br We provide the marketing, the technology, and the additional income. You provide (more...)
Company: BetterHelp
Location: Utica
Posted on: 12/2/2020


Need a gig? Deliver with Uber Eats
Description: Need a gig Deliver with Uber Eats Austerlitz, NY 2854 C2-79759 Deliver with Uber. Earn on your schedule. Work on your schedule. Deliver for a few hours in the mornings, every night, or just on weekends (more...)
Company: Uber Eats
Location: Pittsfield
Posted on: 12/2/2020

Chiropractor
Description: FULL TIME Chiropractor DC Needed in Clifton Park, NY 12065 We are currently seeking a full-time Chiropractor DC to join a growing practice in Clifton Park, NY 12065
Company: Healthcare Recruitment Counselors
Location: Schenectady
Posted on: 12/2/2020

Deliver Food with Uber - Flexible Gig
Description: Deliver Food with Uber - Flexible Gig Schenectady, NY 2854 C2-150078 Deliver with Uber. Earn on your schedule. Work on your schedule. Deliver for a few hours in the mornings, every night, or just on weekends (more...)
Company: Uber Eats
Location: Schenectady
Posted on: 12/2/2020

Make up to $20/hour - Deliver with DoorDash
Description: Your time. Your Goals. What is DoorDash Available in over 4,000 cities in the U.S., Canada, and Australia, DoorDash is about connecting people with possibilities: bigger savings accounts, wider nets, (more...)
Company: Doordash
Location: Utica
Posted on: 12/2/2020

Immediate Openings Available - Merchandisers - No experience Needed
Description: Mondelez International is NOW HIRING - Immediate Openings Available br br br br Minimum age requirement for this opportunity is 18 years old br
Company: Mondelez International
Location: Pittsfield
Posted on: 12/2/2020

MERCHANDISING
Description: Job Description Merchandising Execution Associates: All Merchandising Execution Associates MEAs perform in-store merchandising service activities such as merchandising projects, planogram maintenance, (more...)
Company: The Home Depot
Location: East Hartford
Posted on: 12/2/2020

Fuel Station
Description: As a fuel station associate at Walmart,
Company: Connexus
Location: Schenectady
Posted on: 12/2/2020

Log In or Create An Account

Get the latest New York jobs by following @recnetNY on Twitter!

Albany RSS job feeds