Cognos & Power BI Lead

The following requirement is open with our client. Title : Cognos & Power BI Lead Location : Pleasanton CA Duration : 12+ Months Position : W2 Position Relevant Experience (in Yrs.): 12+ Advanced proficiency in IBM Cognos Analytics (11.x): Report Studio, Analysis Studio, Event Studio, Framework Manager, Dynamic Cubes, Transformer. · Required -Expertise in designing complex dashboards, visualizations, multidimensional reports, and report bursting. · Required -Skilled in migrating legacy BI solutions (Series 6 → Cognos 8/10/11) and converting reports to Power BI including logic conversion and visualization redesign. · Advanced knowledge of Power BI architecture, including datasets, dataflows, gateways, and workspace management. · Required -Strong experience in dimensional modeling (star/snowflake schemas), relational modeling, and building data warehouse layers. · Required -Hands-on experience with ETL processes, data mapping, data transformation, and documenting end-to-end data flows. · Required -Ability to perform deep data profiling, validation, cleansing, and quality checks. · Required - Expertise in working with SQL Server, Oracle, IBM DB2, ODS, Cognos Content Store. Good to have skills · Implementing Row-Level Security (RLS) and managing user roles. · Understanding of data governance frameworks and compliance standards. · Expertise in star schema, snowflake schema, and semantic modeling for BI solutions. Communicate technical concepts clearly to non-technical stakeholders. · Create migration playbooks, technical documentation, and user guides. · Stay updated on BI trends and Power BI enhancements. · Recommend improvements to reporting processes and architecture for long-term scalability. · Define and document the end-to-end migration strategy for transitioning Tableau and Cognos reports to Power BI. · Assess existing BI landscape and identify dependencies, risks, and mitigation plans. · Design scalable and secure Power BI architecture, including datasets, dataflows, gateways, and workspaces. · Establish best practices for data modeling, performance optimization, and governance. Generic Managerial Skills · Ability to translate technical concepts into business language for non-technical stakeholders. · Skilled in gathering requirements and aligning solutions with business objectives. · Experience leading cross-functional teams, mentoring developers, and ensuring adherence to best practices. · Comfortable presenting migration strategies, architecture diagrams, and progress updates to senior leadership. · Strong interpersonal skills to work with Offshore data engineers, analysts, and business users. · Provide inputs to create clear technical documentation, migration playbooks, and training materials Must have skills • IBM Cognos Analytics 11.x • Power BI • SQL