Home

HIRING NOW::OREPA Data Warehouse Developer ::NY at Remote, Remote, USA
Email: [email protected]
From:

Sam,

Adventa Tech Inc

[email protected]

Reply to:   [email protected]

Job Description -

Job Title: OREPA Data Warehouse/System Developer Expert

Location: : (50% REMOTE-after 3 months) - Rensselaer, NY

Duration: 12 Months

Visa: NO H1B/CPT/OPT

Client: Office of Children and Family Services

This resource will work on reporting, analysis and measurements for Adult Protective Services in New York State. This includes needed development of data structures and extractions that are necessary for the continued support of Local Districts of Social Services (LDSSs). Specifically, this resource will work on these areas: 1) update current system generated reports identified through OSC Audit as lacking accurate coding, 2) review and revise all remaining existing system reports for accuracy, 3) refine current caseload data reports to cover on-going cases, 4) add APS data to Commissioner Dashboard, create a Rep Payee report, referral month log, and address a large backlog of LDSS requested monitoring reports related to: case timeliness, completion dates, client needs and demographics, and return clients.

Provide a complete list of the day-to-day tasks to be performed by the Selected Candidate: Tasks that this position will be handling during the period the position is being requested:
Work collaboratively with OREPA and APS 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.2, 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.
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 Skill Level Description: 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

List all the Position REQUESTED Qualifications:
84 Months of Experience in using SQL for analysis and reporting including conditional formatting and joining multiple queries
84 Months of Experience testing reports, analytics, troubleshooting, problem solving, documenting and presenting complex data challenges to stakeholders
84 Months of Experience working in social services or relating fields
84 Months of Experience in business requirement gathering, analysis and logical design; understanding and translating complex issues both in oral and written communication
84 Months of Experience in creating and modifying Framework Manager models
84 Months of Experience in creating and modifying reports using COGNOS tools
Bachelor's Degree

Keywords: business intelligence New York
HIRING NOW::OREPA Data Warehouse Developer ::NY
[email protected]
[email protected]
View all
Wed Sep 04 00:52:00 UTC 2024

To remove this job post send "job_kill 1716628" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 0

Location: ,