CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.
we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.
We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.
If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.
Deliverable 1: Design, Develop, and Maintain Relational, Cloud-Based, Power BI, and AI/ Machine Learning-Specific Data Models.
The consultant will design, develop, and maintain data models tailored to meet the organization's needs. This includes creating relational data models to support traditional reporting and analytics, as well as cloud-based data models leveraging modern architectures to enable scalability, performance, and efficient data processing. The consultant will also optimize Power BI data models to ensure fast, reliable, and user-friendly reporting and visualization. Additionally, the consultant will develop AI/Machine Learning-specific data models to support advanced analytics workflows, including feature engineering, data preparation, and integration with AI/ML tools. These models will be designed to align with the organization's business objectives, ensuring data accuracy, consistency, and usability across all platforms.
The consultant will also be responsible for publishing data models to the appropriate platforms, ensuring they are accessible, secure, and optimized for use by stakeholders. This includes publishing models to cloud environments, Power BI, and other relevant systems as required. Comprehensive documentation will accompany all data models, detailing their structure, purpose, and usage. The documentation will include data dictionaries, entity- relationship diagrams, and step-by-step instructions for maintaining and updating the models. This ensures that the models are transparent, easy to understand, and can be effectively utilized by both technical and non-technical users.
The consultant will provide support for the date modeling product upgrade as required and work on updating the date modeling documentation to keep the procedures current.
Deliverable 2: Knowledge Transfer
The consultant will conduct regular training sessions tailored to the skill levels of our team members. These sessions will focus on:
Key concepts and tools related to cloud-based data modeling, Power BI, and AI/ML.
Q&A sessions to address specific challenges or questions from the team.
Training will be designed to build confidence and competence, enabling team members to take ownership of the systems and processes.
The consultant will also work closely with our existing team members throughout the engagement, fostering a collaborative environment where knowledge sharing is a core focus. This hands-on approach ensures that team members are actively involved in the design, development, and maintenance of the data models, rather than being passive observers. By embedding team members in the process, they will gain practical, real-world experience under the guidance of the consultant.
Roles/Responsibilities:
- Data Modeling and Design Develop and maintain traditional data models for relational databases; Design application-supporting data models using advanced methodologies such as relational modeling, medallion architecture, and data modeling for cloud environments; Create data models tailored for artificial intelligence machine learning use cases specific to CalPERS' needs.
- Tool Proficiency Utilize Erwin Data Modeler software to design and maintain data models; Utilize Power BI to model data for visualization and analytics.
- Publishing and Documentation Support publishing and maintenance of data models on the CalPERS intranet for organizational access; Create, document, and maintain analytical models to ensure data literacy and usability by business users.
- Knowledge Transfer Provide data modeling knowledge transfer sessions to ITSB team members and key business stakeholders, ensuring they understand and can apply relevant concepts and practices, and take ownership of all models created by the contractor. Advise the development and maintenance of data models by state staff.
Never miss an opportunity! Create an alert based on the job you applied for.
