Skip to main content

This job has expired

Data Warehouse Developer

Employer
Kern Community College District
Location
Bakersfield

View more

Employment Type
Full Time
Institution Type
Community College

Job Details



Data Warehouse Developer

Kern Community College District


Position Number: 03146

Posting Date: 10/16/2020

Position Closing Date:

Initial Screening Date: 10/30/2020

Open Until Filled: No

Position Type: Classified

Rate:

Work Week: 40 hours per week, 12 month position

Minimum Salary: $6,215.24 per month

Maximum Salary: $8,781.98 per month

Benefits:
Kern Community College District provides a rich health and welfare benefits offering to our employees, including Health, Dental, Vision, Life Insurance, and Long-term Disability.
In addition to the above benefits, the District also offers a robust voluntary benefits selection:
  • Flex 125
  • Additional products and services through American Fidelity
  • Supplemental voluntary life insurance
  • Tax Shelter Annuities

The District participates in CalPERS retirement system and Social Security benefits for Classified and Management employees. Employees covered under the California Public Employees Retirement System (CalPERS), are vested 100% after five years of full time service credit. All coverages begin on the first day of the month following the hire date.


College/Site: District Office

Location: DO-KCCD Bakersfield Downtown

Basic Function:
This position is available for remote work, applicants must reside in the state of California.

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.

DISTINGUISHING CHARACTERISTICS:

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.


Education and Experience:
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.

OR

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.

OR

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.

Preferred: One year of data warehouse and reporting 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:
KNOWLEDGE OF:
  • 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

ABILITY TO:
  • 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 Grade: 51.5

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 October 30, 2020 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 or high school diploma
  • 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.

Additional openings that become available prior to the end of the hiring process may also be filled from the qualified applicants.

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 https://careers.kccd.edu/postings/14051. 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.

Posted by the FREE value-added recruitment advertising agency

jeid-e9d016841650c3428eb0eede1863b617

Organization

Kern Community College District (KCCD) serves communities over 24,800 square miles in parts of Kern, Tulare, Inyo, Mono, and San Bernardino counties through the programs of Bakersfield CollegeCerro Coso College and Porterville College. Governed by a locally elected Board of Trustees, the district’s colleges offer programs and services that develop student potential and create opportunities for our citizens.

KCCD is geographically one of the largest community college districts in the United States, serving 26,000 students. Our students represent a diversity of religions, economic backgrounds, sexual orientations, abilities, and ethnicities.

While the Kern Community College District was established as a separate entity in 1968 to respond to the changing needs of our communities, educational services have been provided to residents for many years: at Bakersfield College since 1913; at Porterville College since 1927; and in the Ridgecrest area since 1951 by what is now Cerro Coso College. All three colleges are proud members of the California Community College System and are accredited by the Western Association of Schools and Colleges.

Today, education centers and sites in Delano, downtown Bakersfield, the Mammoth/ Bishop area, Edwards Air Force, and the Kern River Valley offer additional convenient, localized instruction for thousands of residents. KCCD’s commitment to distance learning and other technological advances is creating increasing opportunities for education through the internet, satellite, and cable television to individuals across our broad service area and beyond.

Mission Statement

The mission of the Kern Community College District is to provide outstanding educational programs and services that are responsive to our diverse students and communities.
 
 

 

 

Get job alerts

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

Create alert