ITS53DataEHSFY14009Developer.docx

Specifications for ITS53 Staff Augmentation Posting [Document Number: ITS53_Data-EHS-FY14-009] Data Warehouse Developer X New Posting __ RePosting: __ No suitable resumes received, reposted with no changes (please do not resubmit resumes)

General Requirements:

CORI requirements: _X_MUST BE COMPLETED __ Other (including special requirements):

Interview requirements: __x in person __ Other:

Total number of positions sought: _1_

Maximum acceptable hourly rate: $_85

May be filled PRIOR TO CLOSE DATE: _x_Yes __No

Additional Resume Submission Specifications and Requirements:

· Maximum number of resumes per ITS53 Vendors: 4

· Resumes must be emailed to: EOHHS-ITContractorResumes@MassMail.State.MA.US

· The subject line of the email must read: ITS53_Data-EHS-FY14-009

· No phone calls please – email questions to: ___ kara.banderier@state.ma.us

· Indicate on resume if candidate is presently working for another State Agency or has worked for another State Agency within the past 12 months (if so, indicate State Agency name)

· Include candidate Pay Rate in the email that accompanies the resume

· Rates are all-inclusive (travel and any additional expenses are included in the rate)

· Must include exclusive Right to represent

· Third party status

Worksite Address: 100 Hancock Street, Quincy, MA Contract Length: June 30, 2014 Project(s) Duration: end of project Hours per Week: 40 Submission Deadline: February 21, 2014 Other Schedule Related:

Rate Card Title from the Rate Card posted on Comm-PASS: Data Warehouse Cognos Developer

Position Summary:

(Programmer III)/Data Reporting Analyst

The Commonwealth of Massachusetts is currently seeking exceptional individuals to join the Business Intelligence/Data Warehouse Team. This is an exciting opportunity to join a highly skilled team and contribute to a critical and highly visible project within the Executive Office of Health and Human Services.

We are seeking self starters who are highly motivated, efficient, professional, communicative and able to contribute to the team on day one. As a Cognos developer on our team you will participate in the development of Framework Manager Models, reports, cubes, dashboards and the design and implementation of overall BI solutions. Responsibilities include:

SPECIFIC DUTIES

· Draft business requirements and write technical specifications for Cognos report, cubes, Framework Manager Packages

· Develop Cognos packages using Cognos Modeling tool/ Framework Manager, including specific packages optimized for use by business users using Query Studio.

· Develop Cognos content, specifically Reports in Report Studio, Cognos Cubes using Transformer, Events in Event Studio. (Dashboard experience a plus)

· The candidate will work closely with the business analyst or the end user to define/refine the requirements.

· Assist business users in developing/ executing complex queries/ reports using Analysis studio, Query Studio.

· Assistance in the maintenance operations of large Cognos installation.

Required

· Development of Framework Manager Models and Query Packages

· Develop Complex Dashboards, Reports and Cubes using Report Studio and Transformer.

· Extensive Experience with Cognos Query Studio, Powerplay Studio, Event Studio.

· Thorough knowledge of the Cognos portal functionality.

· Extensive Knowledge in Oracle, SQL Server SQL writing skills.

· Strong problem solving & analytical skills.

· Knowledge of ETL Concepts.

Preferred

· Experience with Medicaid or Health care data would be beneficial.

· Cognos Administration and User Security Implementation experience

· Experience with TOAD preferred.

· Solid grasp of the requirements gathering process preferred.

· Cognos Installation and Configuration on Multi server Distributed Environment.

· Knowledge of Reports and Cubes scheduling operations.

· Knowledge of Metrics Studio a plus