Cognos to Google Cloud Platform Migration Consultant / Data & BI Engineer

Virtualan Software, LLC; United States; Remote; USD 120,000 - 150,000; Full time

Job summary

Virtualan Software, LLC is seeking a Cognos to Google Cloud Platform Migration Consultant / Data & BI Engineer to lead the modernization of enterprise reporting and analytics. You will analyze Cognos reports, data sources, and dependencies and design a migration strategy to Google Cloud Platform including BigQuery, Dataflow, Dataproc, Composer, and Looker/Looker Studio.

The role requires strong Cognos analytics, SQL, ETL/ELT, and cloud data modeling skills.

Qualifications

• 7 years of experience in BI, Data Engineering, Analytics, or Data Warehousing.
• Strong hands-on experience with IBM Cognos Analytics.
• Experience with Cognos Report Studio, Cognos Analytics, Framework Manager, Cognos packages, Data modules, Dashboards, 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 workloads from on-prem to cloud platforms.
• Experience with ETL/ELT and data-pipeline development.
• Strong understanding of data validation, reconciliation, and migration testing.
• Experience with large enterprise datasets and complex reporting environments.

Responsibilities

• Assess the existing IBM Cognos BI environment, including reports, dashboards, and dependencies.
• Perform inventory and rationalization of Cognos reports for migration or retirement.
• Develop a Cognos-to-Google Cloud Platform migration strategy and roadmap.
• Migrate data and reporting workloads to Google Cloud Platform.
• Design and implement scalable data models in BigQuery.
• Convert Cognos reporting logic to GCP analytics solutions.
• Rebuild Cognos dashboards using Looker/Looker Studio.
• Develop ETL/ELT pipelines with Dataflow, Dataproc, Cloud Composer, and BigQuery.
• Migrate data from relational databases and data warehouses to GCP.
• Translate Cognos models into scalable semantic and dimensional models.
• Perform source-to-target mapping and data validation.
• Conduct report reconciliation to match Cognos logic and results.
• Optimize BigQuery queries, partitioning, clustering, and processing.
• Implement security models with GCP IAM and access controls.
• Support scheduling, distribution, alerts, and data refresh processes.
• Develop automation scripts using Python/SQL/Shell/APIs.
• Troubleshoot data, reporting, and migration issues.
• Collaborate with business users, data engineers, BI developers, and architects.
• Create documentation covering architecture and deployment procedures.

Skills

Cognos Analytics

SQL

Data Modeling

ETL/ELT

BigQuery

Looker Studio

Report Studio

Framework Manager

Tools

Cognos Report Studio

Framework Manager

BigQuery

Job description

Cognos to Google Cloud Platform Migration Consultant / Data & BI Engineer

Location: Remote

Job Summary

We are seeking an experienced Cognos to Google Cloud Platform (Google Cloud Platform) Migration Consultant to support the modernization and migration of enterprise reporting, analytics, and data workloads from IBM Cognos to a cloud-based analytics environment on Google Cloud Platform . The ideal candidate will have strong experience with IBM Cognos reporting, dimensional/data modeling, SQL, ETL/ELT, and Google Cloud Platform services such as BigQuery, Cloud Storage, Dataflow, Dataproc, Composer, and Looker/Looker Studio . The consultant will analyze existing Cognos reports, packages, frameworks, data sources, and dependencies and design an efficient migration strategy to Google Cloud Platform.

Key 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-Google Cloud Platform 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 Google Cloud Platform-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 Google Cloud Platform.
• 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 Google Cloud Platform 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.

Required Qualifications

• 7 years of experience in Business Intelligence, Data Engineering, Analytics, or Data Warehousing .
• Strong hands‑on experience with IBM Cognos Analytics .
• Experience with:
• 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.

Preferred Google Cloud Platform Skills

• 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

Preferred Technical Skills

• Python
• SQL
• Shell scripting
• REST APIs
• Git
• CI/CD
• Terraform
• Jenkins / Cloud Build
• Oracle, SQL Server, DB2, PostgreSQL, or similar enterprise databases

Migration Experience

Candidates should preferably have experience with one or more of the following:

• Cognos to Looker migration
• Cognos to BigQuery migration
• Cognos to Looker Studio migration
• Legacy BI modernization
• On‑premises data warehouse to Google Cloud Platform migration
• Report rationalization and consolidation
• Semantic‑layer modernization
• Data warehouse modernization

Key Deliverables

• Cognos environment assessment
• Report and package inventory
• Migration complexity analysisSource-to-target mapping
• Google Cloud Platform target architecture
• BigQuery data models
• Migrated reports and dashboards
• Data‑validation and reconciliation results
• Performance optimization
• Security configuration
• Migration runbook
• Production cutover and stabilization support

Desired Profile

The ideal candidate combines strong Cognos functional knowledge with modern Google Cloud Platform data engineering and analytics expertise and can work across legacy BI analysis, cloud architecture, data migration, reporting modernization, and business validation.