This Software Architect position will support the OTDA Child Support Datamart. The purpose of this project is to capture and load various source system data (application and mainframe) into a data mart to support OTDA analytical reporting requirements.

- 84 Months experience in IBM Cognos BI 11.0 or higher Administration, Installation, Server Configuration, and technical support including all components of the IBM Cognos Business Intelligence suite of tools.

- 84 Months experience with IBM Cognos BI 11.0 or higher Application Security integrating with\using Active Directory (AD), Lightweight Directory Access Protocol (LDAP), or Java Based Authentication.

- 84 Months experience developing and implementing complex data security, object security, and cube security with IBM BI 11.0 or higher Cognos Framework Manager and Transformer tools.

- 72 Months experience with IBM Cognos BI Framework Manager 11.0 or higher implementing best practices to model and develop Cognos Packages using relational, dimensional, data marts and transactional databases to support reports, score-carding, and analysis.

- 84 Months experience using industry best practices to create Data Cube models with IBM Cognos Transformer 11.0 or higher using existing relational and dimensional data marts.

- 84 Months experience developing Java scripting, SQL, Unix Scripting, and writing code (.NET,JAVA, JavaScript) to support Cognos SDK and Cognos Web- Service.

- 12 Months experience with Cognos BI 11.0 or higher Administration, Installation, Server Configuration, and technical support including all components of the IBM Cognos Business intelligence suite of tools.

- IBM Cognos BI 8 or higher Certification.

- Bachelor’s Degree in business intelligence, information science, criminal justice, health science, computer science, mathematics, or public/business administration.