Data Modeler

Capgemini
United States
18 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Compensation
$82,909.0 - $129,563.0
Working hours
Regular working hours
Job source

Tech stack

Adobe InDesign Artificial Intelligence Data Analysis BigQuery Cloud Storage Customer Data Management Data Validation Data Dictionary Data Integrity Extract Transform Load (ETL) Data Systems Data Warehousing
+17 more
Database Design Software Design Patterns Dimensional Modeling Data Flow Control Metadata Standard Sql SQL Databases Freeform SQL Google Cloud Cloud Platform System Data Lineage Star Schema Apache Kafka Physical Data Models Stream Processing Data Pipelines Legacy Systems

Job description

Experienced Data Modeler and Analyst with a strong background in the telecom domain and deep expertise in Google Cloud Platform (GCP). Responsible for leading end-to-end solution design, building scalable data models, and driving architectural decisions to support complex telecom data ecosystems.

Data Modeling & Database Design

  • Develop robust conceptual, logical, and physical data models for telecom datasets, including:
  • Call Detail Records (CDRs)
  • Network performance metrics
  • Service assurance
  • Customer 360
  • Billing
  • Provisioning
  • Optimize data models for high-performance analytics in BigQuery and cloud-scale environments.
  • Collaborate with ETL/ELT teams to translate data models into efficient, scalable implementations.
  • Maintain comprehensive data documentation, including data dictionaries, data lineage, and metadata.
  • Ensure data integrity, consistency, and performance across all data pipelines and systems., * Write complex SQL queries for data validation, profiling, and transformation of telecom datasets.
  • Ensure data models support efficient querying, reporting, and analytics use cases.
  • strong SQL and analytical skills to support solution design and data-driven decision-making., * Design and support the delivery of end-to-end data solutions on GCP aligned with telecom business and technical requirements.
  • Establish design standards, frameworks, best practices, and reusable design patterns for telecom workloads.
  • Conduct architecture and design reviews, ensuring compliance with enterprise standards.
  • Drive modernization initiatives to migrate legacy systems to cloud-based platforms.
  • Make architectural decisions that enhance scalability, performance, and maintainability.

Collaboration & Implementation

  • Collaborate with data engineers and ETL/ELT teams to implement scalable data pipelines.
  • Work closely with business stakeholders and analysts to translate business requirements into effective data models.
  • Participate in design reviews and ensure alignment with enterprise data architecture standards.

Stakeholder Engagement

  • Partner with business stakeholders, product owners, and engineering teams to gather requirements and deliver scalable data solutions.
  • Clearly communicate architectural decisions, trade-offs, and solution designs to both technical and non-technical audiences.
  • Lead and facilitate technical workshops, architecture discussions, and data model review sessions.

Requirements

  • Strong experience in conceptual, logical, and physical data modeling.
  • Advanced proficiency in SQL and data analysis.
  • Hands-on experience with GCP services, including:
  • BigQuery
  • Cloud Storage
  • Dataflow
  • Strong understanding of telecom data domains, including CDRs, network, billing, and customer data.
  • Knowledge of data warehousing concepts and dimensional modeling (star and snowflake schemas).

Preferred Skills

  • Experience with real-time data processing technologies such as Kafka and Google Pub/Sub.
  • Understanding of TM Forum standards, including SID and eTOM.
  • Experience with cloud migration initiatives (on-premises to GCP).
  • Exposure to AI/ML use cases within telecom analytics

Benefits & conditions

3.73.7 out of 5 stars Remote $39.86 - $62.29 an hour - Contract, Pulled from the full job description

  • Retirement plan
  • Vision insurance
  • Dental insurance, The pay range that the employer in good faith reasonably expects to pay for this position is $39.86/hour - $62.29/hour. Our offered benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

1:47 min

Comparing Egeria to alternative open metadata solutions

Ferd Scheepers · WWC 2022

3:27 min

Explaining query execution overhead and caching limitations in BigQuery

Adnan Rahic · JS Congress

2:36 min

Integrating business experts and conceptualizing analytical use cases

Stefan Donsa Stefan Donsa +1 · LIVE

2:08 min

Creating standard APIs via the Egeria open metadata project

Ferd Scheepers · WWC 2022

2:30 min

Leveraging BigQuery ML for scalable SQL-based segmentation experiments

Julian Joseph · LIVE

Videos

See all

Related articles

See all