BI Migration Lead ( Cognos )

Résumé du poste

Lead the end-to-end migration of enterprise reporting from IBM Cognos to AWS QuickSight. This includes converting data models, migrating query logic, and rebuilding visualizations to ensure performance and logic parity.

Détails du poste

Position Name – BI Migration Lead Type of hiring – Subcon Location – Remote Canada Job Description: Seeking a BI Migration Specialist to lead the transition of enterprise reporting from IBM Cognos to AWS QuickSight preferably Owns data model conversion, query migration, and report rebuild end to end, ensuring parity of logic, performance, and user experience post migration. 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+ 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 Soft Skills Self-directed, able to move fast with minimal oversight Clear communicator across client and delivery teams

Ce que vous ferez

Lead the end-to-end migration of enterprise reporting from IBM Cognos to AWS QuickSight. This includes converting data models, migrating query logic, and rebuilding visualizations to ensure performance and logic parity.

Exigences

Requires over 5 years of BI experience with hands-on expertise in Cognos and AWS QuickSight. Candidates must be proficient in SQL, data modeling, and AWS data services.

Compétences indiquées

• SQL · Souhaitée
• Validation · Souhaitée
• Sens de l’organisation · Souhaitée
• Souci du détail · Souhaitée
• Teams · Souhaitée
• Client · Souhaitée
• Analyse de données · Souhaitée
• Reporting · Souhaitée
• Accuracy · Souhaitée
• Amazon Web Services · Souhaitée
• Mapping · Souhaitée
• Python · Souhaitée

Autres compétences pertinentes

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• IBM Cognos
• AWS QuickSight
• SQL
• Data Modeling
• Framework Manager
• Report Studio
• Cognos Analytics
• SPICE
• AWS Redshift
• AWS Athena
• AWS Glue
• AWS S3
• Star Schema
• Snowflake Schema
• Python
• Report Parity Validation

Domaines d’emploi

• Data & Analytics
• Technology
• Consulting
• Software
• Management & Leadership