This job has expired

Data Warehouse Developer

Kern Community College District
California, United States
Salary Not specified
Posted Date
Dec 28, 2022

Data Warehouse Developer

Kern Community College District

Salary: $6,593.75 - $9,316.80 Monthly

Job Type: Full Time

Job Number: FY22-2300258

Location: Bakersfield, CA

Department: Information Technology Services

Basic Function
Under the direction of an assigned supervisor, perform design, development, implementation, maintenance and enhancement related activities necessary to support data warehousing, business intelligence and reporting systems.


The Data Warehouse Developer is a key member of the Data Warehouse and Reporting team that is responsible for implementing and delivering business intelligence and reporting solutions. The Data Warehouse Developer is distinguished from the Data Warehouse Administrator in that the former receives instruction and assistance from the Data Warehouse Administrator.

Representative Duties
Develop an in-depth understanding of data maintained in various transactional systems and how data from these systems are best organized and integrated to support transactional, reporting, and analytic needs.

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

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.

Develop processes and applications for migration/transformation of data from College-wide systems to the data warehouse system and operational data store

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

Perform related duties as assigned.

Minimum Qualifications
Any combination equivalent to:

Bachelor's degree in Information Systems, Computer Science or related field and some experience working with or supporting information technology systems.


An Associate's degree and 2 years of work experience such as described in the representative duties section of the specification and working with and supporting data warehousing, business intelligence and reporting systems.


High school diploma, GED or equivalent certificate of competency and 4 years of work experience such as described in the representative duties section of the specification and working with and supporting data warehousing, business intelligence and reporting systems.


One year of data warehouse and reporting experience.

Knowledge and Abilities
Data Warehouse and Data Mart concepts, structures and systems
Extract, Transform and Load processes
Reporting design and delivering reporting solutions
Relational database concepts
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 data and develop logical solutions for information access problems
Develop SQL statements, procedures and functions
Debug and solve 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 RANGE $6,593.75 - $9,316.80 monthlyMaximum Entry Level Salary: $6,927.56 monthly
SPECIAL INSTRUCTIONSFirst Review of Applications: Complete application packets will be accepted until the position is filled; but those received by January 10, 2023 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 five (5) professional references - Listed on application form

It is the applicant's responsibility to redact (or remove) any personal information from all documents prior to uploading. This includes Social Security Numbers, Date of Birth, and any photos of the applicant.

Foreign Degree: Applicants with foreign degrees from colleges or universities outside of the United States must have their coursework evaluated by a professional association that is a member of the National Association of Credential Evaluation Services (NACES) or Academic Credentials Evaluation Institute, INC. (ACEI). A copy of the evaluation must be submitted with your on-line application.

Applicants who require reasonable accommodation to participate in the selection process should contact Human Resources to make the necessary arrangements. EEO Plan 2021-2024

Note: The District is strongly committed to achieving staff diversity and the principles of equal employment opportunity. The District encourages a diverse pool of applicants and does not discriminate on the basis of national origin, religion, age, gender, gender identity, gender expression, race or ethnicity, color, medical condition, genetic information, ancestry, sexual orientation, marital status, physical or mental disability, pregnancy, or because he/she is perceived to have one or more of the foregoing characteristics, or based on association with a person or group with one or more of these actual or perceived characteristics or any other characteristic protected by federal, state or local law, in any of its policies, procedures or practices. Discrimination Free Work Environment

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 Emails will not be accepted.


Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert