Overview Senior Cognos Architect sought for an onsite contract in Columbus, OH to guide Cognos integration with an Oracle data warehouse and support a large-scale BI rollout. You will shape data marts, cubes, and security, while coaching client staff and ensuring an efficient, high-availability reporting environment. You'll lead architecture decisions, performance tuning, and tool selection to meet business goals and enable a successful go-live. This role offers direct impact on a major Cognos deployment and reporting modernization.
Responsibilities- Advise on optimal data marts, cubes, and dashboards setup tied to business requirements
- Onsite engagement with client staff; provide training and mentoring
- Define Cognos security architecture and deployment strategy across levels
- Assist with performance analysis, tuning, and high-availability reporting environment
- Develop and enforce version control strategy for data marts, cubes, models, and reports
- Guide conversion from Hyperion/Brio to Cognos and oversee related migrations
- Determine which Cognos tools best support business needs
- Address security and architecture questions; ensure timely on-site support
- Plan and support disaster recovery considerations for BI environment
- Contribute to project governance and client communications
- Support 40-hour-per-week engagement and coordination with client teams
Key requirements- Three years of Cognos experience or higher
- One year of Cognos 10.x experience
- One year building Cognos cubes
- Experience building a Cognos data warehouse using cubes, data marts, data models, and reports
- At least one complete Cognos implementation (install, configure, tune) across multiple servers
- Experience migrating from another data warehouse tool to Cognos
- Preferred: Cognos with Oracle databases
- Preferred: knowledge of Cognos 10.2 features
- Preferred: IBM Cognos certifications (various) such as Administrator, Developer, Metadata/OLAP/Reports Designer
- Mentoring and training capability
- On-site collaboration and communication
- Problem-solving and analytical thinking
- Cognos architecture and deployment
- Cognos cubes, data marts, data models, and reports
- Performance tuning and indexing
