Note: The job is a remote job and is open to candidates in USA. Virtualan Software, LLC is seeking an experienced Cognos to Google Cloud Platform (GCP) Migration Consultant / Data & BI Engineer to modernize enterprise reporting, analytics, and data workloads. The role assesses and rationalizes Cognos environments, develops migration strategies, builds BigQuery data models and pipelines, rebuilds reports and dashboards, and supports validation, deployment, cutover, and stabilization.
Responsibilities
- Assess the existing IBM Cognos BI environment , including reports, dashboards, Framework Manager packages, data modules, cubes, schedules, security, and dependencies
- Perform inventory and rationalization of Cognos reports to identify reports for migration, consolidation, modernization, or retirement
- Develop a comprehensive Cognos-to-GCP migration strategy and roadmap
- Migrate enterprise data and reporting workloads to Google Cloud Platform
- Design and implement scalable data models in BigQuery
- Convert Cognos reporting logic, calculations, filters, prompts, and business rules into modern GCP-based analytics solutions
- Rebuild Cognos dashboards and reports using Looker, Looker Studio, or other enterprise visualization tools
- Develop and optimize ETL/ELT pipelines using tools such as: Google Cloud Dataflow; Dataproc; Cloud Composer; BigQuery; Cloud Storage; Pub/Sub
- Migrate data from relational databases, data warehouses, and legacy platforms into GCP
- Translate Cognos Framework Manager models into scalable semantic and dimensional models
- Perform source-to-target mapping and data validation
- Conduct report reconciliation to confirm migrated reports match Cognos business logic and results
- Optimize BigQuery queries, partitioning, clustering, and overall cloud data-processing performance
- Implement security models using GCP IAM, service accounts, row-level security, and column-level security
- Support automated scheduling, report distribution, alerts, and data-refresh processes
- Develop migration utilities and automation scripts using Python, SQL, Shell scripting, or APIs
- Troubleshoot data, reporting, performance, and migration issues
- Work closely with business users, data engineers, BI developers, architects, and application teams
- Create technical documentation covering architecture, migration mappings, data lineage, deployment, and operational procedures
- Support SIT, UAT, production deployment, cutover, and post-production stabilization
Skills
- 7+ years of experience in Business Intelligence, Data Engineering, Analytics, or Data Warehousing
- Strong hands-on experience with IBM Cognos Analytics
- Cognos Report Studio
- Cognos Analytics
- Framework Manager
- Cognos packages
- Data modules
- Dashboards
- Scheduled reports
- Bursting and distribution
- Strong knowledge of Google Cloud Platform
- Hands-on experience with BigQuery
- Strong SQL and data-analysis skills
- Experience designing dimensional models, star schemas, and enterprise reporting models
- Experience migrating reporting or analytics workloads from on-premises environments to cloud platforms
- Experience with ETL/ELT and data-pipeline development
- Strong understanding of data validation, reconciliation, and migration testing
- Experience working with large enterprise datasets and complex reporting environments
- BigQuery
- Google Cloud Storage
- Dataflow
- Dataproc
- Cloud Composer / Apache Airflow
- Pub/Sub
- Cloud Functions / Cloud Run
- Looker / Looker Studio
- IAM
- Secret Manager
- Cloud Logging and Monitoring
- Python
- SQL
- Shell scripting
- REST APIs
- Git
- CI/CD
- Terraform
- Jenkins / Cloud Build
- Oracle, SQL Server, DB2, PostgreSQL, or similar enterprise databases
- Cognos to Looker migration
- Cognos to BigQuery migration
- Cognos to Looker Studio migration
- Legacy BI modernization
- On-premises data warehouse to GCP migration
- Report rationalization and consolidation
- Semantic-layer modernization
- Data warehouse modernization
Company Overview
Company H1B Sponsorship