Ascii Group, LLC · 9 hours ago
Cognos & Power BI Lead
Pleasanton, CA
Contract
Onsite
Lead/Staff
12+ years expAscii Group, LLC is seeking a Cognos & Power BI Lead to support their client. The role involves advanced proficiency in IBM Cognos Analytics and Power BI, focusing on designing complex dashboards, migrating legacy BI solutions, and ensuring data quality and governance.
Human ResourcesInformation TechnologyStaffing Agency
Hiring Manager
Ajay K.
Responsibilities
Advanced proficiency in IBM Cognos Analytics (11.x): Report Studio, Analysis Studio, Event Studio, Framework Manager, Dynamic Cubes, Transformer
Expertise in designing complex dashboards, visualizations, multidimensional reports, and report bursting
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
Strong experience in dimensional modeling (star/snowflake schemas), relational modeling, and building data warehouse layers
Hands-on experience with ETL processes, data mapping, data transformation, and documenting end-to-end data flows
Ability to perform deep data profiling, validation, cleansing, and quality checks
Expertise in working with SQL Server, Oracle, IBM DB2, ODS, Cognos Content Store
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
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
Qualification
Required
Advanced proficiency in IBM Cognos Analytics (11.x): Report Studio, Analysis Studio, Event Studio, Framework Manager, Dynamic Cubes, Transformer
Expertise in designing complex dashboards, visualizations, multidimensional reports, and report bursting
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
Strong experience in dimensional modeling (star/snowflake schemas), relational modeling, and building data warehouse layers
Hands-on experience with ETL processes, data mapping, data transformation, and documenting end-to-end data flows
Ability to perform deep data profiling, validation, cleansing, and quality checks
Expertise in working with SQL Server, Oracle, IBM DB2, ODS, Cognos Content Store
Must have skills: IBM Cognos Analytics 11.x, Power BI, SQL
Preferred
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
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
Company
Ascii Group, LLC
ASCII Group, LLC is a full service provider of comprehensive IT staffing services designed to fulfill the needs of local, regional and global companies.
501-1000 employees
H1B Sponsorship
Ascii Group, LLC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (5)
2024 (17)
2023 (8)
2022 (15)
2021 (18)
2020 (24)
Funding
Current Stage
Late StageLeadership Team
Hima Kolanagireddy
President & CEO
Recent News
Company data provided by crunchbase