What are the responsibilities and job description for the Data Modeler position at capgemini?
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.
Data Analysis & SQL
Perform detailed data analysis to understand source systems and business requirements.
Write complex SQL queries for data validation, profiling, and transformation of telecom datasets.
Ensure data models support efficient querying, reporting, and analytics use cases.
Apply strong SQL and analytical skills to support solution design and data-driven decision-making.
Solution Architecture (GCP, SQL & Telecom)
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.
Required Skills
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
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.
Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.
Salary : $40 - $62