What are the responsibilities and job description for the Optimum Data Modeler - BSS Transformation position at capgemini?
Experienced Data Modeler and analyst with a strong background in the telecom domain and deep expertise in Google Cloud Platform (GCP). This role is responsible for leading end-to-end solution design, building scalable data models, and making architectural decisions to support complex telecom data ecosystems.
Data Modeling & Database Design:
Develop robust conceptual, logical, and physical data models for telecom datasets, including CDRs, network performance metrics, service assurance, customer 360, billing, and 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, lineage, and metadata.
Ensure data integrity, consistency, and performance across all pipelines and systems.
Data Analysis & SQL:
Perform detailed data analysis to understand source systems and business requirements.
Write complex SQL queries for validation, profiling, and transformation of telecom datasets.
Ensure models support efficient querying, reporting, and analytics use cases.
Collaboration & Implementation:
Collaborate with data engineers and ETL/ELT teams to implement scalable data pipelines.
Work with business stakeholders and analysts to translate requirements into data models.
Participate in design reviews and ensure alignment with enterprise data architecture.
Stakeholder Collaboration:
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 & facilitate technical workshops, architecture discussions, and data model review sessions.
Solution Architecture (GCP, SQL, Telecom):
Design and help deliver end-to-end data models and solutions on GCP aligned with telecom business needs and technical requirements.
Establish design standards, frameworks, best practices, and reusable design patterns for telecom workloads.
Help in design and architecture reviews, ensure compliance with enterprise standards, and drive modernization initiatives from legacy systems to cloud-based platforms.
Apply strong SQL and analytical skills to support solution design and data-driven decision-making.
Required Skills:
Strong experience in data modeling (conceptual, logical, physical).
Proficiency in SQL and data analysis.
Hands-on experience with GCP tools such as BigQuery, Cloud Storage, and Dataflow.
Knowledge of telecom data domains (CDR, network, billing, customer).
Familiarity with data warehousing concepts and dimensional modeling (star/snowflake schemas).
Preferred Skills:
Experience with real-time data processing (Kafka, Pub/Sub).
Understanding of TM Forum standards (SID, eTOM).
Experience in cloud migration projects (on-prem to GCP).
Exposure to AI/ML use cases in telecom analytics.
The pay range that the employer in good faith reasonably expects to pay for this position is $39.30/hour - $61.40/hour. Our 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 : $39 - $61