BI Migration Lead

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

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.

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.

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

• 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

• Data & Analytics
• Technology
• Engineering
• Software
• Consulting

Expérience minimale

5+ ans

Langue de l’offre

anglais

Heures de travail

40 heures par semaine

Niveau d’expérience

Mid-Senior level

Mode de candidature

La candidature directe est offerte