Senior Data Warehouse Specialist (IBM Cognos Analytics - fully remote job)
Ateko, backed by Bell Canada Senior Data Warehouse Specialist (IBM Cognos Analytics - fully remote job)
Summary
Senior data warehouse specialist on a 12-month, fully remote contract to lead an IBM Cognos Analytics upgrade from v11 to v12: assess the current environment, plan migration with testing and rollback, update Framework Manager models and data modules, validate reports, and document/hand over. Core stack: Cognos, Framework Manager, SQL, enterprise DW platforms.
12 month contract fully remote
We are looking for a Senior Data Warehouse Specialist to lead and support the upgrade of IBM Cognos Analytics environment from version 11 to version 12. The ideal candidate has deep technical experience with data warehouses and Cognos, and can assess the current environment, plan the migration, resolve technical issues, and ensure reports and data models work reliably after the upgrade.
Responsibilities
- Assess the current IBM Cognos 11 environment, including reports, data modules, data sources, security, and scheduled jobs
- Plan and execute the upgrade to IBM Cognos 12, including the migration path, testing, and rollback procedures
- Review and update Framework Manager models, data modules, and queries to ensure compatibility
- Validate reports, dashboards, and scheduled outputs before and after the upgrade
- Work with the data warehouse team to confirm data sources, ETL dependencies, and performance
- Identify and resolve technical issues during the upgrade, and document solutions
- Coordinate with business users to confirm report accuracy and acceptance
- Prepare technical documentation, runbooks, and handover materials
- Support knowledge transfer to internal teams
Requirements
- 7+ years of experience in data warehousing, with strong knowledge of data modeling and ETL processes
- Hands-on experience with IBM Cognos Analytics (11.x) and experience with an upgrade to Cognos 12 or a similar major version upgrade
- Strong experience with Framework Manager, Report Studio, Query Studio, and Cognos administration
- Strong SQL skills and experience with enterprise data warehouse platforms (e.g., IBM Db2, Oracle, Teradata, Snowflake, SQL Server)
- Experience with performance tuning, security configuration, and scheduling in Cognos environments
- Strong problem-solving skills and attention to detail
ACCESSIBILITY
We’re committed to fostering an inclusive, equitable, and accessible workplace where every team member feels valued, respected, and supported, and has the opportunity to reach their full potential. We welcome and encourage applications from people with disabilities.
Accommodations are available on request for candidates taking part in all aspects of the selection process. For a confidential inquiry, simply email your recruiter directly or accessibility@fxinnovation.com to make arrangements.
If you have questions regarding accessible employment at Ateko please email our Human Resources team at accessibility@fxinnovation.com
Ateko
Derek Weber - Senior Recruiter
derek.weber@ateko.com
Skills
Sign in to read and join the discussion.