BI Migration Lead
Lead the migration of BI assets from Cognos to AWS QuickSight, including translating data models and rebuilding visualizations. Ensure data accuracy through validation and optimize dashboard performance and ingestion schedules.
- On-site
- Canada
- Posted Jul 28, 2026
- 1 position
Job summary
Key Responsibilities Assess existing Cognos landscape: Framework Manager models, report packages, dashboards, and scheduled outputs Translate Cognos data models into QuickSight datasets, SPICE structures, and calculated fields Migrate report logic, filters, prompts, and drill paths into QuickSight analyses and dashboards Convert Cognos queries and SQL into Quick Sight compatible datasets sourced from the target AWS data layer (Redshift, Athena, RDS, or S3) Rebuild visualizations to match or improve on legacy Cognos reports Validate data accuracy and reconcile output against source reports Optimize SPICE ingestion, refresh schedules, and dashboard performance Document mapping, transformation rules, and migration runbook Required Skills 5 plus years in BI and reporting, with hands on Cognos (Framework Manager, Report Studio, Cognos Analytics) Proven Quick Sight build experience: datasets, SPICE, calculated fields, analyses, dashboards Strong SQL and data modeling, including star and snowflake schemas Working knowledge of AWS data services (Redshift, Athena, Glue, S3) Experience with report parity validation and reconciliation Nice to Have AWS certification (Data Analytics or Solutions Architect) Python for data transformation and automation
What you’ll do
Lead the migration of BI assets from Cognos to AWS QuickSight, including translating data models and rebuilding visualizations. Ensure data accuracy through validation and optimize dashboard performance and ingestion schedules.
Requirements
Requires over 5 years of BI experience with expertise in Cognos and proven experience building in AWS QuickSight. Strong SQL skills and familiarity with AWS data services are essential.
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Cognos
- AWS QuickSight
- SQL
- Data Modeling
- AWS Redshift
- AWS Athena
- AWS Glue
- AWS S3
- SPICE
- Framework Manager
- Report Studio
- Cognos Analytics
- Star Schema
- Snowflake Schema
- Python
Job areas
- Data & Analytics
- Technology
- Engineering
- Software
- Consulting
Additional details
- Minimum experience
- 5+ years
- Posting language
- English
- Working hours
- 40 hours per week
- Seniority
- Mid-Senior level
- Application method
- Direct apply is available