Software Architect

Listed on: 5/26/2023 11:03:00 AMPST
Location: Albany, NY 12243
Industry: Information Technology
Salary: Open
Description: L.J Gonzer Associates is looking for individuals to join our pool of qualified candidates for potential assignment as a Software Architect. *Working closely with the project manager, core technical team members and other project stakeholders and providing guidance throughout the System Development Life Cycle (SDLC) *Model mission critical reporting requirements in IBM Cognos including all layers of the model and package development and securing models for data level, object level and package access security *Create advance level reports using Cognos, which include several pages with conditional formatting and joining multiple queries to produce a single dataset for reports *Create business documentation (Business Requirement documents that detail the technical requirements and deliverables for reporting structures, reports, dashboards, and ad hoc tools in accordance with the requirements *Work closely with Data Mart team members and various Agency Business Owners to assist in developing logical and physical dimensional data model reporting requirements and providing assistance in understanding the data requirements for proposed reporting *Create and execute test scripts, scenarios, and test plans to validate initial business requirements and report output through the DEV, QA and PROD migrations testing for accuracy and sign off on deliverables *Mentor State staff and other contract resources as required *Provide trouble shooting and end user support and problem resolution as needed
Requirements: 

• Bachelor degree in computer science, mathematics, business intelligence, engineering, or information science
• Certification in IBM Cognos Framework Manager, Metadata Models Design, Cognos Report Studio, or Author Professional Reports Fundamentals, or any other related certifications
• 6 years experience authoring and maintaining reports using IBM Cognos Business Intelligence 8.4 or higher suite of tools against relational, dimensional, and transactional databases
• 6 years experience using IBM Cognos Framework Manager 8.4 or higher using IBM Cognos best practices to model reporting packages against Oracle databases including administrative functions to create groups and roles, data source connections (including groups)
• 4 years experience using Framework Managers and authoring\maintaining reports using IBM Cognos Business Intelligence 10.0 or higher suite of tools against relational, dimensional, and transactional databases
• 6 years experience implementing complex data, object and package security filters within the IBM Cognos Business Intelligence suite of tools using Java based authentication provider and Cognos Groups and Roles
• 6 years experience writing queries using SQL, PL/SQL including tuning SQL within an Oracle environment to ensure timely and efficient execution of queries
• 6 years experience developing dimensional data models for Cognos data analytics
• 6 years experience working with PPI and SSA data security requirements (working with data contained in Employee Records in a State Agency, Federal Agency or Private Organization) in a data mart or data warehouse environments
• 6 years experience with Oracle 10/11G databases, Oracle Data Warehouse and Data Marts in a Business Intelligence environment and SQL coding

L. J. Gonzer Associates is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected Veteran status.

Apply Here