1000’s of jobs for bilingual/Asian-speaking professionals  


Email address



Forgot Password
Register Free

Job Category:

Advanced Job Search

   Get Started

Job details
Company: Kern Community College district
Job Title: Data Warehouse Administrator
Job Category: Info Technology
Job description:  
Data Warehouse Administrator

Kern Community College District

Position Number: 02284

Posting Date: 01/11/2018

Initial Screening Date: 01/25/2018

Open Until Filled: Yes

Position Type: Classified


Work Week: 40 hours per week, 12 month position

Minimum Salary: $6,517.18 per month

Maximum Salary: $9,208.60 per month


Our competitive benefits package includes medical, dental, and vision insurance; life insurance coverage; long-term disability insurance, and an employee assistance program (EAP ).

In addition, employees have the option to purchase:

• Flex 125
• AFLAC Policy
• Supplemental voluntary life insurance
• 403b Tax Shelter Annuity

All coverages begin on the first day of the month following the hire date. Employees are covered under the California Public Employees Retirement System (CalPERS) and are vested 100% after five years of full time service.

College/Site: District Office

Location: DO-KCCD Bakersfield Downtown

Basic Function:

Under the direction of an assigned supervisor, responsible for the design,
development, implementation, maintenance, enhancement, and support of data warehousing, business intelligence and reporting systems.


The Data Warehouse Administrator is the senior level position supporting core data warehouse and reporting systems infrastructure and provides leadership for the Data Warehouse and Reporting team. Following operating policies and procedures, the Data Warehouse Administrator receives minimal assistance and exercises discretion and independent judgment as new or unusual situations arise. The Data Warehouse Administrator is accountable for the Data Warehouse and Reporting team following established processes, standards and best practices.


Serve as the senior level data warehouse and reporting systems professional supporting core data warehouse and reporting systems infrastructure.

Lead the design of and responsible for the development, documentation and prioritization of strategies and architecture for supporting KCCD's data warehouse and reporting systems infrastructure

Coordinate with database and systems administrators regarding data warehouse development, migration of data through manual or ETL processes, revision and update of data marts and cubes, procedure development, troubleshooting, system configuration, security administration, and account setup.

Automate, innovate and standardize hardware, software and support practices to continually improve the effectiveness of KCCD's data warehouse and reporting systems infrastructure.

Analyze complex business processes and analytics requirements in higher education and develop cost effective solutions using Ellucian's Operational Data Store (ODS ), Cognos and other reporting tools, and other appropriate software

Install, deploy and upgrade data warehouse systems applications; maintains documentation, and perform routine systems administration maintenance activities

Create, and maintain relational and dimensional data structures within the data warehouse and operational data store to meet functional requirements and optimize performance.

Develop and maintain data marts, data cubes, queries, and reports.

Develop and maintain data models and data maps for data warehouse system
and operational data store.

Initiate processes and documentation of data warehousing and reporting systems.

Develop procedures to ensure security and integrity of data.

Coordinate, schedule, and test upgrades to the data warehouse and reporting systems.

Research and evaluate software, system upgrades and enhancements and provide technical recommendations.

Provide assistance to end users and programmers regarding data warehouse/reporting related problems and issues.

Manage end-user accounts and accessibility; provide technical expertise to end-users who create complex queries and reports.

Work closely with key internal customers to identify opportunities to further and better support KCCD operations in terms of reporting and information access

Keep current with the latest technology; regularly attend technical training in order to maintain technical expertise.

Participate in the assessment, evaluation and selection of vendor products

Perform related duties as assigned.

Education and Experience:

Any combination equivalent to:

Bachelor’s degree in Information Systems, Computer Science or related field and 3 years of increasingly responsible data warehouse & reporting, programming or systems analysis and design experience.
An Associate’s degree in Computer Science and 5 years of increasingly responsible data warehouse & reporting, programming or systems analysis and design experience.
High school diploma, GED or equivalent certificate of competency and 7 years of increasingly responsible data warehouse & reporting, programming or systems analysis and design experience.

Note: Degrees and credits must be from accredited institutions (Title V Section 53406). Any degree from a country other than the United States, including Canada and Great Britain, must be evaluated by an evaluation service.

Note: The screening of candidates will be conducted by a screening committee. The screening committee reserves the right to limit the number of interviews granted. Meeting the minimum qualifications for a position does not assure the applicant of an interview.

Knowledge and Abilities:


• Expert knowledge of Data Warehouse and Data Mart concepts, structures and systems
• Extract, Transform and Load processes
• Reporting design and delivering reporting solutions
• Expert knowledge of relational database concepts; Relational database management systems experience required
• PL/SQL coding
• End-user reporting tools
• Windows and Unix operating systems
• Basic statistical methods


• Develop in-depth knowledge and understanding of systems capabilities, end-user’s information needs and underlying business practices
• Analyze, design, configure, install and maintain complex reporting solutions
• Analyze data and develop logical solutions for information access problems
• Develop complex SQL statements, procedures and functions
• Debug and solve complex problems
• Prepare work plans and time lines for projects and proposed systems
• Manage multiple priorities, follow project plans and meet project deliverables
• Complete assignments on time
• Learn new skills and adapt to changes in technology
• Continuously update personal knowledge of industry-leading technology
• Communicate effectively both orally and in writing
• Establish and maintain cooperative and effective working relationships with others

Salary Grade: 53.0

Special Instructions to Applicants:

First Review of Applications:
Complete application packets will be accepted until the position is filled; but those received by 5:00 p.m. (Pacific Standard Time) on January 25, 2018 are assured consideration. The College reserves the right to extend time limits or reinitiate the recruitment/selection process at any point.

Completed application packet must include:
•Completed Online Application for Employment form
•Current resume
•Letter of interest (Cover Letter)
•Copy of legible transcripts, if applicable
•List of six (6) professional references – Listed on application form

Applicants who require reasonable accommodation to participate in the selection process should contact Human Resources to make the necessary arrangements.

The District does not provide sponsorship for authorization to work in the United States. Work authorization should be established at the time of application submission.

All applicants must apply online at http://apptrkr.com/1150458. Emails will not be accepted.

As an Equal Employment Opportunity Employer, the Kern Community College District encourages candidates with diverse backgrounds to apply.

Copyright ©2017 Jobelephant.com Inc. All rights reserved.

Employment type:
  • Full Time
Salary Range: Unspecified
Other Information
Degree: Unspecified
Experience (year): 0
Job Location: Bakersfield - California - USA
Zipcode: 93305
Post Date: 01/15/2018
Contact Information
Company: Kern Community College district
Contact Name: Kern Community College district
Apply Online
Apply Now

More jobs from the web:

Kern Health Systems
Bakersfield - CA - US
McCormick Biological, Inc.
Bakersfield - CA - US
Ross Stores
Shafter - CA - US
jobs by Indeed job search


Email address



Forgot Password
Register Free

Job Category:

Advanced Resume Search

Login/Update Jobs
Get Started

Bilingual job opportunities for English-Asian-speaking professionals ranging from entry level to executive level - Nationwide!
Employers can recruit bilingual job seekers at an affordable rate of $150.00 for 1 job posting!


Copyrights © 2004 - 2011 - Asian-Jobs.com/Hispanic-Jobs.com/Diversity-Jobs.com /Education-Jobs.com - All Rights Reserved.