About the role
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
Not the right fit? Search for BI Migration Lead jobs in Canada
About Yochana
Yochana: Your Trusted Workforce Partner Across North America & Beyond For over 15 years, Yochana has been a leading talent acquisition firm, connecting businesses with top professionals across industries. Headquartered in Farmington Hills, Michigan, we specialize in temporary workforce solutions, permanent placements, contract-to-hire, and recruitment process outsourcing (RPO) across the USA, Canada, Mexico, and India.
At Yochana, we go beyond traditional hiring agencies—our customized recruitment strategies and AI-driven talent solutions help businesses scale faster and smarter. Whether you need IT specialists, engineering professionals, healthcare experts, logistics personnel, or niche industry talent, our extensive candidate network ensures the right fit for your business needs.
Why Yochana? ➤ End-to-End Workforce Solutions – Temporary, Permanent, Contract, RPO & On-Site Talent Acquisition ➤ Industry-Specific Hiring – IT, Healthcare, Engineering, Finance, Logistics & More ➤ Diversity & Inclusion Focus – Promoting diverse hiring and equal opportunities ➤ Expansive Global Reach – Serving businesses across USA, Canada, Mexico & India ➤ Local Expertise – Proudly based in Farmington Hills, Michigan, connecting businesses with top professionals
Looking for recruitment agencies near me? Searching for workforce solutions in Michigan? Yochana is your trusted talent acquisition partner—connecting top companies with exceptional professionals.
📍 Learn more: www.yochana.com 📩 Contact us: hello@yochana.com | 📞 +1 248-213-6465
#TalentAcquisition #WorkforceSolutions #HiringExperts #ProfessionalRecruitment #BusinessGrowth #MichiganJobs #TopTalent #USACanadaMexico #HiringNearMe #CareerOpportunities
Similar Jobs
About the role
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
Not the right fit? Search for BI Migration Lead jobs in Canada
About Yochana
Yochana: Your Trusted Workforce Partner Across North America & Beyond For over 15 years, Yochana has been a leading talent acquisition firm, connecting businesses with top professionals across industries. Headquartered in Farmington Hills, Michigan, we specialize in temporary workforce solutions, permanent placements, contract-to-hire, and recruitment process outsourcing (RPO) across the USA, Canada, Mexico, and India.
At Yochana, we go beyond traditional hiring agencies—our customized recruitment strategies and AI-driven talent solutions help businesses scale faster and smarter. Whether you need IT specialists, engineering professionals, healthcare experts, logistics personnel, or niche industry talent, our extensive candidate network ensures the right fit for your business needs.
Why Yochana? ➤ End-to-End Workforce Solutions – Temporary, Permanent, Contract, RPO & On-Site Talent Acquisition ➤ Industry-Specific Hiring – IT, Healthcare, Engineering, Finance, Logistics & More ➤ Diversity & Inclusion Focus – Promoting diverse hiring and equal opportunities ➤ Expansive Global Reach – Serving businesses across USA, Canada, Mexico & India ➤ Local Expertise – Proudly based in Farmington Hills, Michigan, connecting businesses with top professionals
Looking for recruitment agencies near me? Searching for workforce solutions in Michigan? Yochana is your trusted talent acquisition partner—connecting top companies with exceptional professionals.
📍 Learn more: www.yochana.com 📩 Contact us: hello@yochana.com | 📞 +1 248-213-6465
#TalentAcquisition #WorkforceSolutions #HiringExperts #ProfessionalRecruitment #BusinessGrowth #MichiganJobs #TopTalent #USACanadaMexico #HiringNearMe #CareerOpportunities