Sr. Cognos BI Developer/Administrator

DatamanUSA has an exciting opportunity for a Sr. Cognos BI Developer/Administrator to work on-site with one of our direct clients in Sacramento, CA. We love referrals! Please refer us to your friends, family, and colleagues for this opportunity. DatamanUSA gives referral bonuses (up to $500) if they get selected and perform well for our clients. Job Details: Title: Sr. Cognos BI Developer/Administrator Duration: 12+ months with highly possible extension Location: Sacramento, CA Job Description:

• Meet with customers, gather requirements, do the business analysis and create Report Specification documents
• Design and develop reports using Cognos or OBIEE tool.
• Design and develop SQL for reports
• Integrate external Application to Cognos/OBIEE to trigger/run reports
• Integrate Cognos to batch processes to be able to run/create and save reports using Cognos SDK
• Maintain the existing package(s) and suggestions for ways of improving the performance and maintainability
• Performance tuning of Cognos and OBIEE applications - both on reports, framework side and server/infrastructure aspects
• Maintain existing Framework Manager packages and build new packages as per reporting needs
• Maintain existing Oracle Repository (RPD) metamodels and build new models as per reporting needs
• Design, develop and deliver data extracts from databases and data warehouses
• Update design and technical specification documents for ongoing report modifications
• Maintain security of Cognos and OBIEE Objects and implement data level security on reports to restrict data visible to users
• Maintain security of data assets through the administration of Cognos and OBIEE features
• Maintain knowledge of data models and data dictionary for the purpose of maintaining Cognos and OBIEE reports and enhancing user awareness of business data
• Work with the Application team to identify performance issues and suggest improvement plans
• Work with Middle-Tier team and manage software upgrades, patches and back-up as needed
• Work with product vendors to provide application support and bug fixes as needed
• Work with Database team to create and update Report Data column mapping to database tables and columns
• Work with Business Intelligence (BI) Delivery Leads/Data Warehouse/report developers to build/assist in redesigning the reports to source from warehouse
• Educate and provide knowledge transfer to report developers and business users on Cognos and OBIEE tools and best practices
• Provide weekly accomplishment/status report to management every week
• Attend project and team meetings as requested.

• 6 years of applied experience developing reports using Cognos Report Studio and Framework Manager.
• 6 years of applied experience with Cognos functional administration and version upgrade
• 6 years of applied experience production reporting system support using Cognos, Oracle
• 6 years of applied experience with SQL development, Oracle 11g database, and JavaScript for reports
• 3 years of applied experience using Oracle Business Intelligence Enterprise Edition (OBIEE)
• 3 years of applied experience with OBIEE functional administration and Oracle Repository (RPD)
• 5 years of CalPERS, or similar retirement systems, business knowledge