We are looking for Data Modeler with 10+ years of experience.
Key Responsibilities:
- Develop and maintain conceptual, logical, and physical data models leveraging GCP services such as BigQuery, Cloud SQL etc.
- Work on end-to-end data initiatives, from gathering requirements to cutover.
- Translate business requirements from stakeholders into effective data model designs.
- Play a key role in migrating data from legacy on-premises systems to cloud-native GCP solutions.
- Optimize data models for performance-oriented OLAP (Online Analytical Processing) and OLTP (Online Transactional Processing) systems.
- Ensure data consistency, quality, and reliability by defining constraints, validation rules, and data governance policies within data models.
- Collaborate with data engineers, data scientists, and business teams to understand data needs and deliver structured data for analytics and machine learning.
- Create and maintain comprehensive data model documentation, including entity-relationship diagrams, data dictionaries, and metadata definitions.
- Leverage understanding of telecom-specific data, such as subscriber data, billing information, network performance metrics, and customer insights.
- Proficiency in data modeling techniques (dimensional, relational) and tools such as Erwin, PowerDesigner, or open-source alternatives.
- Expert-level SQL skills for querying and analyzing large datasets in BigQuery.
- Strong hands-on experience with core GCP services
- Understanding of telecom data sources and industry-specific metrics.
Skills Required
- 10+ years of data modeling experience
- Expert-level SQL skills for querying and analyzing large datasets (BigQuery)
- Strong hands-on experience with core GCP services (e.g., BigQuery, Cloud SQL)
- Experience developing conceptual, logical, and physical data models
- Proficiency with data modeling tools such as Erwin or PowerDesigner (or open-source alternatives)
- Knowledge of dimensional and relational data modeling techniques
- Experience migrating data from on-premises systems to GCP
- Experience optimizing data models for OLAP and OLTP systems
- Understanding of telecom data sources and industry-specific metrics (subscriber, billing, network performance)
What We Do
Two95 International Inc., is a global technology firm specializing in enterprise solutions that evolves over BPM, Mobility, Cloud, Analytics, E-commerce & Social Business. Our client base includes several Fortune 500 and mid-market companies across industries and varying geographies. With vast knowledge and knowhow of 20 years in the IT field, we have been chosen as INC500 fastest growing company in North America in 2013. With the accolade of being ranked 11th in Human Resources by INC500, we have also been nominated as the 3rd fastest growing company in South Jersey by SJBM. We are ranked among the Top 20 IT Companies in New Jersey based on the year-on-year growth for the last 3 years. With a seasoned team of highly qualified personnel, our offices are located in New Jersey, Canada and India.
