Data Architect Dallas Tx

Job Role: Data Architect - GCP / BigQuery / Power BI
Location: Dallas, TX
Experience: 10+ years in data engineering/architecture, including 4+ years designing GCP data platforms
No C2C only W2

Job Description:
Assess the client data landscape and design an end-to-end GCP platform spanning ingestion, GCS landing, BigQuery, transformations, semantic models and Power BI. Define scalable architecture, security, governance, cost controls and delivery standards, present trade-offs and guide implementation.

Important Skills to Cover:
1.BigQuery and Modelling:
Expert BigQuery modelling, partitioning/clustering, performance, and cost/slot management; dimensional modelling, SCD and layered data architecture.
2.GCP Ingestion and Processing:
GCS, Dataflow, DataStream, Pub/Sub, Cloud Composer and Cloud Run/Functions; ingest REST APIs, spreadsheets, semi-structured and HTML data.
3.PostgreSQL and ELT:
Deep PostgreSQL CDC/logical replication and TB-scale migration; strong SQL and Data form or dbt.
4.Power BI Architecture:
Semantic models, Import/Direct Query/Composite choices, gateways, incremental refresh, RLS and BigQuery performance.
5.Governance and Delivery:
IAM, VPC Service Controls, KMS/CMEK, policy tags and Dataplex; Terraform, CI/CD, architecture documentation, HA/DR and stakeholder workshops.

Preferred Skills:
GCP Professional Cloud Architect or Professional Data Engineer certification; Python; data observability tools; streaming analytics; telecom domain exposure.