BI Migration Lead - Cognos & Power BI

Role Overview The BI Migration Lead will own the end-to-end strategy and execution for migrating legacy BI platforms (IBM Cognos / Tableau) to Power BI. This role combines hands-on technical leadership, data modeling expertise, and stakeholder communication, ensuring scalable, governed, and high-performance BI solutions aligned with business objectives. Key ResponsibilitiesCognos & Legacy BI Expertise Provide advanced hands-on expertise with IBM Cognos Analytics 11.x, including: Report Studio Analysis Studio Event Studio Framework Manager Dynamic Cubes Transformer Design and maintain complex dashboards, multidimensional reports, visualizations, and report bursting Support and rationalize legacy environments including: Cognos Series 6 → Cognos 8/10/11 BI Migration & Modernization Define and document the end-to-end migration strategy for transitioning: IBM Cognos → Power BI Tableau → Power BI Convert legacy Cognos/Tableau reports to Power BI: Business logic conversion Semantic layer redesign Visualization modernization Assess existing BI landscapes, identify dependencies, risks, and mitigation plans Create detailed migration playbooks, technical documentation, and user guides Power BI Architecture & Governance Design scalable and secure Power BI architecture, including: Datasets Dataflows Gateways Workspace design and management Establish best practices for: Data modeling Performance optimization Governance and lifecycle management Implement Row-Level Security (RLS) and manage user roles and access Recommend improvements for long-term scalability and maintainability Data Modeling & Engineering Design and build dimensional models: Star schema Snowflake schema Semantic models for BI Strong experience with: Relational modeling Data warehouse layers Hands-on involvement in: ETL processes Data mapping Data transformation Document end-to-end data flows Data Quality & Validation Perform deep data profiling, validation, cleansing, and quality checks Ensure consistency between legacy and modern BI outputs Support auditability and reconciliation requirements Databases & Platforms Work extensively with: SQL Server Oracle IBM DB2 ODS Cognos Content Store Stakeholder & Leadership Responsibilities Communicate complex technical concepts clearly to non-technical stakeholders Translate technical designs into business-friendly language Present migration strategies, architecture diagrams, and progress updates to senior leadership Lead and mentor cross-functional and offshore teams (data engineers, BI developers, analysts) Ensure adherence to BI standards, best practices, and delivery timelines Required Skills & QualificationsCore BI & Analytics Advanced proficiency in IBM Cognos Analytics 11.x Advanced knowledge of Power BI architecture Strong experience in BI migration programs Expertise in dimensional modeling and semantic layer design Hands-on ETL and data transformation experience Data & Governance Strong understanding of data governance frameworks and compliance standards Experience implementing security models including RLS Strong focus on data accuracy, quality, and consistency Soft Skills & Leadership Excellent communication and stakeholder management skills Strong analytical and problem-solving abilities Experience leading teams and mentoring BI developers Comfortable working with executive leadership and business users Good to Have Skills Tableau migration experience Power BI performance tuning

Created: 2026-03-10