Software Architect (Business req gathering/analysis/logical design; Framework Mg

Overview

Software Architect Exp
HBITS-

Day-to-day tasks to be performed by the Selected Candidate are described below. Tasks that this position will be handling during the period the position is being requested.

Responsibilities

• Work collaboratively with OREPA 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.
• Mentor State staff and other contract resources as required.
• Lead data exchange efforts for Federal and State Reporting to content and file specifications (.xml).
• 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.

Qualifications & Experience

• 84 Months of Experience in working collaboratively on business requirement gathering, analysis and logical design
• 84 Months of Experience in creating and modifying Framework Manager & Transformer models with troubleshooting expertise
• 84 Months of Experience in JavaScript coding to enhance Cognos functionality
• 84 Months of Experience using relational databases including designing tables, applying constraints, functions, stored procedures, views, and complex SQL objects
• 84 Months of Experience working with data exchange standards for sharing Human Services related data for State and Federal Government
• 84 Months Experience in social services-related reporting including troubleshooting for user support
• Bachelor's Degree

Required Documentation

• Résumé
• Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)