This job listing has expired and the position may no longer be open for hire.

Business Analyst-11292 at Optimal Solutions and Technologies in Rensselaer, New York

Posted in Other 30+ days ago.





Job Description:
































Position:





Business Analyst-11292












Location:


Rensselaer, NY




Job Id:



5338-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:

24 Months

What are the daily work hours?

08:00am -05:00pm

Where is the physical work office located?

52 Washington St., Room 323 North Rensselaer, NY 12144

Description of specific Duties in a typical workday for this position:

Tasks:

* Work collaboratively with the current team of DJJOY/JJIS staff and participate in business requirement gathering for BI projects.

* Work with Business Analyst on analysis and logical design.

* Perform complex SQL coding to facilitate reporting and testing functions.

* Modeling using IBM Cognos BI Framework Manager and Transformer to support mission critical reporting initiatives including all layers of the model and package development.

* Securing the Framework Manager and Transformer models for data level, object level and package access security.

* Create advanced reports using IBM Cognos Analytics 11.1 R1, which include but are not limited to several pages with conditional formatting and joining multiple queries to produce a single dataset for the requested report.

* Complete testing of all reports, dashboards and analytics in all environments prior to business owner review/approval.

* Transfer knowledge to other Cognos users creating their own reports in person and using electronic technologies.

* Mentor State staff and other contract resources as required.

* Provide troubleshooting and end user support and problem resolution.

* Research and develop solutions utilizing new product functionality to integrate into Human Services Cluster business deliverables.

Position Requirements:

* 7 years of Experience in business requirement, gathering

* analysis and logical design

* 7 years of Experience in Creating and modifying Framework Manager & Transformer models

* 7 years of Experience in Creating and modifying reports using COGNOS tools

* 7 years of Experience in using SQL for analysis and reporting including conditional formatting and joining multiple queries

* 7 years of Experience testing all reports and analytics prior to moving to production

* 7 years of Experience in social service-related reporting including trouble shooting for user support

* Bachelor's Degree

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.





Apply for this Position





More jobs in Rensselaer, New York

General Business
about 6 hours ago

RetailData
Other
about 22 hours ago

BlueCrest
Other
1 day ago

BlueCrest
More jobs in Other

Other
less than a minute ago

Northern Montana Health
Other
less than a minute ago

Northern Montana Health
Other
less than a minute ago

Northern Montana Health