HBITS-08-15044-Systems Developer-Expert

Knowledge Builders Inc; City of Rensselaer (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

Knowledge Builders Inc. seeks an experienced Project/Program expert to lead APS reporting initiatives.

The role focuses on creating and updating Federal APS reporting functions, real-time reporting, and dashboards using Cognos BI to meet OSC audit requirements. Responsibilities include collaborating with OREPA and APS staff, designing data models, writing complex SQL, validating reports, and transferring knowledge to staff while ensuring secure, scalable BI solutions for the Human Services

Qualifications

• 84+ months in business requirement gathering, analysis and logical design.
• 84+ months in creating and modifying Framework Manager models.
• 84+ months creating/modifying reports using Cognos tools.
• 84+ months using SQL for analysis and reporting with joins across tables/views.
• 84+ months testing reports, analytics, troubleshooting, presenting data challenges to stakeholders.
• 84+ months working in social services or related fields.
• Bachelor’s Degree.

Responsibilities

• Collaborate with OREPA and APS staff on BI requirements.
• Work with Business Analyst on analysis and logical design.
• Perform complex SQL coding for reporting and testing.
• Model using Cognos Framework Manager and Transformer.
• Secure models at data/object/package levels.
• Create advanced reports in Cognos Analytics 12.
• Test reports and dashboards in all environments.
• Transfer knowledge to Cognos users and provide end-user support.
• Research and develop BI solutions for new functionality.

Skills

SQL coding

Cognos Framework Manager

Cognos Transformer

Cognos Analytics

Reporting

Testing reports

End user support

BI solutions

Education

Bachelor’s Degree

Tools

IBM Cognos BI

Framework Manager

Transformer

Job description

Project/Program

OREPA Data Warehouse/System Developer Expert.

Job Description

The position will be responsible for creating and updating APS reporting functions to comply with new Federal APS reporting requirements. This includes updating system-generated reports as a result of OSC audits, addressing reporting backlogs, refining current caseload data reports to cover on-going cases, adding APS data to the Commissioners Dashboard, and creating new reports for payee, referrals, case timeliness, completion, clients, performance (using NAMRS data), as well as other LDSS requests. Reporting capabilities will also be enhanced to allow for real-time report generation.

Day-to-day Tasks

• 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 12, 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.

Mandatory Qualifications

Systems Developer–

Develops and implements applications and programs for the backend processing systems used in businesses and organizations.

Expert

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.

Requested Qualifications

• 84 Months of Experience in business requirement gathering, analysis and logical design; translating 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.
• 84 Months of Experience using SQL for analysis and reporting including conditional formatting and joining queries sourced from multiple tables or views.
• 84 Months of Experience testing reports, analytics, troubleshooting, problem solving, documenting and presenting data challenges to stakeholders.
• 84 Months of Experience working in social services or related fields.
• Bachelor’s Degree.

We provide equal employment opportunity for all applicants and employees regardless of race, color, sex, gender identity, gender expression, religion, age, national origin, citizenship, disability, medical condition, family care status, marital status, domestic partner status, sexual orientation, genetic information, military/veteran status, or any other protected basis.