CEPI - Database Administrator 3

Overview

On Site
Full Time

Skills

UI
Information Technology
Network
Microsoft
Tier 1
Cloud Computing
Recruiting
Training
Partnership
Quality Assurance
Microsoft SSRS
Servers
Management
Microsoft SQL Server
SAP BASIS
Data Management
SAS/SQL
Communication
Collaboration
Dashboard
Performance Tuning
Reporting
FOCUS
Clarity
Visualization
Problem Solving
Conflict Resolution
Debugging
Attention To Detail
Microsoft Power BI
DAX
Database
Extract
Transform
Load
SAS
SQL
Data Modeling
Oracle Linux

Job Details

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.

This position supports the Center for Educational Performance and Information (CEPI) database environment.

The database environment includes:

  • Multiple SQL Server instances
  • Multiple Collection Environments (Development, Quality Assurance/Testing, Pre-Release, and Production)
  • Numerous SQL Reporting Services Servers
  • 35+ collection databases
  • 100+ analysis databases

This position is the Subject Matter Expert (SME) for the modernization to Power BI reporting and requires considerable independent judgment directing and coordinating the appropriate data administration and management methods, practices, procedures and tools, to complete the required assignments. Expertise is required in Microsoft SQL Server database support, and professional knowledge in the PowerBI platform as well as SAS will be required.

We are seeking a technically skilled and detail-oriented data professional to join our team on a temporary basis. This role is responsible for working directly with business users to understand how Power BI is currently utilized, including identifying the data sources, databases, and tables supporting existing dashboards and reports. A key focus of this position is to analyze and convert complex SAS programs into optimized SQL code that integrates seamlessly with Power BI, while ensuring accuracy, performance, and adherence to best practices in data management.

The ideal candidate will possess strong experience with SAS, SQL, and Power BI tools, including Power Query and DAX. They will be adept at documenting current-state processes, identifying opportunities for automation or efficiency, and developing sustainable data pipelines and models. Clear communication skills and the ability to collaborate with both technical and non-technical stakeholders are essential, along with a proactive, customer-focused approach. This is an excellent opportunity for someone who enjoys problem solving, translating legacy code, and contributing to high-impact data reporting solutions.

Roles/Responsibilities:

  • Collaborate with customers to understand current use of Power BI, including identifying key dashboards, reports, and underlying data sources and tables.
  • Review and analyze existing SAS programs to convert them to optimized SQL code suitable for Power BI reporting.
  • Apply advanced SAS and SQL knowledge to ensure logic accuracy, performance optimization, and consistency across data platforms.
  • Assess and document current data processes, recommending improvements and automation opportunities that align with best practices.
  • Work with stakeholders to identify data sources, ETL processes, and transformation logic critical for reporting needs.
  • Build and maintain robust, sustainable data pipelines with a focus on clarity, performance, and long-term maintainability.
  • Leverage Power BI Desktop, Power Query, DAX, and PowerBook tools to support data modeling, development, and visualization.
  • Apply strong problem-solving skills to debug, validate, and optimize ETL and data transformation processes.
  • Communicate effectively with technical and non-technical audiences, documenting processes and collaborating across teams.
  • Work independently in a contract/temporary role while delivering high-quality work with accuracy, attention to detail, and a customer-focused mindset.

Mandatory Skills:

  1. 8+ years of experience in the field is required
  2. Power BI Desktop, Power Query, DAX, and PowerBook tools experience
  3. SQL Database ETL experience
  4. SAS and SQL Data Modeling
  5. Bachelor's Degree Required
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About CCS Global Tech