Must Have Skills :
| •Strong hands -on and architectural expertise in BigQuery (schema design, optimization, cost management). •Proven experience designing large -scale Telco data platforms. •Expert in GoogleSQL, Python, PySpark, and Airflow DAGs. •Strong understanding of data warehousing, ELT/ETL, dimensional modeling, and analytics patterns. •Experience with CI/CD, Git, and Infrastructure -as -Code (Terraform preferred). •Hands -on with streaming and high -volume data ingestion (Pub/Sub, Dataflow). CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodation for people with disabilities in accordance with provincial legislation. Please let us know if you require reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.
|
Roles and Responsibilities :
| •Design and own BigQuery -based data warehouse and lakehouse architectures for Telco use cases (Network, CDR, Billing, OSS/BSS, Customer 360). •Define data modeling standards (dimensional, wide tables, data products) optimized for Telco analytics workloads. •Establish partitioning, clustering, cost -control, and performance optimization strategies in BigQuery. •Experience on on -prem and cloud data warehouses like Oracle, Postgres, SQL Server, Teradata, Databricks, Snowflake preferred •Application and Data Migration experience mandatory •Architect and oversee end -to -end data pipelines using BigQuery, Dataflow, Cloud Composer (Airflow), Dataproc, Data Fusion, Pub/Sub, and Cloud Storage. •Design batch and streaming ingestion frameworks for high -volume Telco data (CDRs, alarms, KPIs, logs). •Guide implementation using GoogleSQL, Python, PySpark, and Airflow DAGs. •Experience on on -prem and cloud data warehouses like Oracle, Postgres, SQL Server, Teradata, Databricks, Snowflake preferred •12 -15 years of experience in Data Engineering / Data Architecture, with 3+ years on GCP BigQuery.
|