Role purpose:
Owns the enterprise data model for telco DWH, data lake and analytics platforms, sets modeling standards, and leads model design across domains so that reporting, data sharing and AI use cases run on one consistent, governed data foundation.
Key Responsibilities
- Own the enterprise conceptual and logical data model across telco business domains
- Lead design of DWH, data mart, data lake and lakehouse models (dimensional, 3NF and Data Vault)
- Align models with telco industry frameworks such as TM Forum SID
- Model complex telco areas: customer 360, subscriber lifecycle, product catalogue, usage / CDR, billing and revenue, network performance and partner / roaming data
- Set and enforce modeling standards, naming conventions and review processes
- Review and approve models and source-to-target mappings produced by Data Modeler team members
- Design models for performance and cost at scale (partitioning, clustering, aggregation strategy)
- Work with architects and data engineers on platform design and migration (on-premise to cloud)
- Define master and reference data structures and conformed dimensions across domains
- Partner with data governance on glossary, lineage, metadata and data quality rules
- Design data models that serve BI, regulatory reporting, data sharing and AI / ML feature needs
- Run impact assessments for source system, regulatory and business logic changes
- Present model designs and trade-offs to senior business and technical stakeholders
- Mentor junior modelers and manage several initiatives at once, tracked in Jira
Required Technical Skills & Tools
- 8+ years of data modeling experience in enterprise DWH / data lake environments
- 5+ years of telco industry experience (BSS / OSS, CDR / xDR, billing, CRM, network data) – required
- Expert SQL and deep knowledge of dimensional, 3NF and Data Vault 2.0 modeling
- Strong knowledge of TM Forum SID or telco industry data models (e.g. Teradata or IBM telco models)
- Expert use of modeling tools (Erwin, ER/Studio, SAP PowerDesigner, SqlDBM or similar)
- Strong experience with cloud data platforms, preferably GCP BigQuery (Snowflake, Databricks, Redshift or Teradata)
- Experience with lakehouse design and open table formats (Delta Lake, Apache Iceberg) – a plus
- Experience with data governance and metadata tools (Dataplex, Collibra, Alation or similar)
- Solid understanding of ETL / ELT design and tools (dbt, Dataflow, Informatica)
- Experience leading DWH migrations or enterprise data model rollouts
- Knowledge of data privacy and telco regulatory reporting requirements
- Strong documentation, stakeholder management and mentoring skills; working knowledge of Jira
