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.
Roles/Responsibilities:
Deliverable 1: Design and development, including programming, testing, enhancements, and maintenance, of specialized software for Business Intelligence (BI) data integration solution for an advanced analysis of CalPERS business transactions.
Design, develop, and maintain specialized software for a Business Intelligence (BI) solution to analyze CalPERS business transactions. BI provides historical, current, and predictive insights into business operations by translating business data requirements into technical specifications and developing enterprise data warehouse star schemes. Each data warehouse deliverable focuses on a specific business subject area (star schema) and includes Technical specifications, dimensional data models, and Extract, Transform, and Load (ETL) programs. Validation and testing to ensure data aligns with the subject area and integrates seamlessly into the enterprise data platform, which includes a data warehouse and scheduled ETL jobs. Design multidimensional data models (star schemas) to represent business transactions, supporting data analysis and analytic dashboards. Integrate data models and ETL jobs into the enterprise data warehouse following established standards. Validate data records to ensure they meet business requirements. Provide backup support for maintaining and operating the data platform, which includes over 3,000 ETL jobs, an operational data store (raw, unprocessed data from multiple applications), and a data warehouse (star schemas and data marts). Address and troubleshoot issues related to deliverables during the assignment.
Deliverable 2: Modernization of BI data platform. Architecting frameworks that increase automation capabilities.
Modernize the BI data platform and integrate DevOps practices into the data and analytics software project lifecycle. Architect frameworks to enhance automation capabilities, ensuring scalability and efficiency. Implement Java programming for developing add-on modules and cloud data source connectors that integrate seamlessly with the existing data platform. Utilize Groovy programming to automate tasks and create repeatable frameworks that streamline development and operational processes. Develop a proof of concept (PoC) for CalPERS' data integration process using a modern data integration tool, demonstrating improved performance, flexibility, and scalability. This includes evaluating and implementing advanced data integration technologies to optimize data flow, reduce latency, and enhance data quality. The modernization effort focuses on aligning the BI platform with current industry standards, leveraging cloud-based solutions, and ensuring the platform is future-ready. Additionally, Establish automated testing, deployment pipelines, and monitoring frameworks to ensure faster delivery, higher quality, and reduced operational risks. Architect solutions that support hybrid data environments, enabling seamless integration of on-premises and cloud data sources.
Deliverable 3: Knowledge Transfer
On an ongoing basis, through the end of the contract, all work products and deliverables (project status reports, business process, triage incident reports with resolution, meeting minutes, test cases, test outcomes) details have to be discussed with the contract manager to ensure that all of the information is documented and placed in a file share. The contract manager will schedule knowledge transfer sessions at regular intervals to ensure that all of the work production details have been documented and the knowledge has been transferred to state personnel. Knowledge transfer to State staff is part of each project when the projects are completed and released into maintenance mode. On an ongoing basis through the end of the contract all work products and deliverables (project status reports, business process, triage incident reports with resolution, meeting minutes, test cases, test outcomes) details have to be discussed with the contract manager to ensure that all of the information is documented and placed in a file share. The contract manager will schedule knowledge transfer sessions at regular intervals to ensure that all of the work production details have been documented and the knowledge has been transferred to the state personnel.
Mandatory Skills:
- Strong proficiency in Data Integration Development and Oracle Data Integrator (ODI) for ETL job development.
- Expertise in designing and developing dimensional models / star schemas for data warehouses.
- Advanced SQL programming and data transformation skills.
Desirable Skills: N/A
Never miss an opportunity! Create an alert based on the job you applied for.
