Estimated Length: 24 months Full-Time 8 hour work days with start time at or after 7:30 am

Mandatory Requirements

Senior 60-84 months

Desired Requirements

• 72 Months Demonstrated hands-on experience authoring and maintaining reports using IBM Cognos Business Intelligence 8.4 or higher suite of tools against relational, dimensional, and transactional databases.
• 72 Months Demonstrated hands-on experience using IBM Cognos Framework Manager 8.4 or higher using IBM Cognos best practices to model reporting packages against Oracle and SQL databases including administrative functions to create groups and roles, data source connections (including groups).
• 48 Months Demonstrated hands-on 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.
• 72 Months Demonstrated hands-on 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.
• 72 Months Demonstrated hands on experience writing queries using SQL, PL/SQL including tuning SQL within an Oracle environment to ensure timely and efficient execution of queries
• 72 Months Demonstrated hands on experience developing dimensional data models for Cognos data analytics.
• 72 Months Demonstrated 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 warehouse environment.
• 72 Months Demonstrated hands on experience with Oracle 10/11G databases, Oracle Data Warehouse and Data Marts in a Business Intelligence environment and SQL coding
• IBM Congos Framework Manager: Design Metadata Models (V10.2) and Cognos Report Sutdio: Author Professional Reports Fundamentals & Advance Certification  
• Bachelor degree in computer science, mathematics, business intelligence, information science, criminal justice, Accounting, or health science.

Responsibilities

• Working closely with the project manager, core technical team members and other project stakeholders and providing leadership throughout the System Development Life Cycle (SDLC).
• Model mission critical reporting requirements in IBM Cognos 10.2 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 10.2 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 and protocol of the client's EIM Division.
• Work closely with Data Warehouse and Business Intelligence technical 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.
• Interact with cross functional teams (Application, Technology, and Enterprise Solution) and staff to ensure requirements are thoroughly and accurately documented and to design and develop analytics and reports for improved business processes that enable the organization to achieve its goals.
• 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.

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

Our Consultants love working for IIT

Follow us on LinkedIn or Twitter or Facebook

IIT is an Equal Opportunity Employer