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

Software Architect Exp HBITS-07-14156 Day-to-day tasks to be performed by the Selected Candidate: 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. Model using IBM Cognos BI Framework Manager and Transformer to support mission-critical reporting initiatives, including all layers of model and package development. Secure the Framework Manager and Transformer models for data level, object level, and package access security. Create advanced reports using IBM Cognos Analytics 11.2, including multiple pages with conditional formatting and joining multiple queries to produce a single dataset. 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 through in-person training and electronic methods. Provide troubleshooting, end-user support, and problem resolution. Research and develop solutions utilizing new product functionalities to support Human Services Cluster business deliverables. Software Architect: OCFS Data Warehouse project Makes high-level design choices and sets technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of large-scale software systems. Expert 84+ months: Candidate provides guidance to large teams and/or has extensive industry experience, considered at the top of their field. 84 Months of Experience in 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 with 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 Human Services data sharing for State and Federal Government 84 Months of experience in social services-related reporting, including troubleshooting for user support Bachelor's Degree Required Documentation: Résumé Copy of Candidate Identification (e.g., Driver's License/Green Card/Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (e.g., professional certifications, degrees, etc.) #J-18808-Ljbffr