> Markdown version of [/jobs/ext/1452373-optimum-data-modeler-bss-transformation](https://www.wearedevelopers.com/jobs/ext/1452373-optimum-data-modeler-bss-transformation). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Optimum Data Modeler - BSS Transformation - **Company:** Capgemini - **Location:** New York, NY, United States - **Salary:** $81,744.0 - $127,712.0 - **Contract:** Temporary contract - **Skills:** Adobe InDesign, Artificial Intelligence, Data Analysis, BigQuery, Cloud Storage, Data Architecture, Data Dictionary, Data Integrity, Extract Transform Load (ETL), Data Warehousing, Database Design, Software Design Patterns, Dimensional Modeling, Data Flow Control, Standard Sql, SQL Databases, Freeform SQL, Google Cloud, Cloud Platform System, Apache Kafka, Physical Data Models, Cloud Migration, Stream Processing, Data Pipelines, Legacy Systems - **Published:** July 26, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=5993c3ad81ad4c85 ## About the Role * 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. ## Description 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. * strong SQL and analytical skills to support solution design and data-driven decision-making. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [The Cloud is Calling: Answer with In-Demand Skills](https://www.wearedevelopers.com/videos/945-the-cloud-is-calling-answer-with-in-demand-skills) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [How to Benchmark Your Apache Kafka](https://www.wearedevelopers.com/videos/76-how-to-benchmark-your-apache-kafka) - [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) ## Related Articles - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Got AI ideas but no money? Here are 10 free ways to level up your AI skills with Google Cloud](https://www.wearedevelopers.com/magazine/600-got-ai-ideas-but-no-money-here-are-10-free-ways-to-level-up-your-ai-skills-with-google-cloud) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)