Remote Cognos to Google Cloud Migration Architect

Virtualan Software, LLC; United States; A distancia; USD 120.000 - 150.000; Jornada completa

Descripción de la vacante

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.

Formación

• 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.

Responsabilidades

• 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.

Conocimientos

Cognos Analytics

SQL

Data Modeling

ETL/ELT

BigQuery

Looker Studio

Report Studio

Framework Manager

Herramientas

Cognos Report Studio

Framework Manager

BigQuery

Descripción del empleo

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.