Job Details

This ad is expired.

Data Warehouse Developer (COF)
Go to our website »

Position Number: 1277304
Location: Bakersfield, CA
Position Type: Computer and Information Technology

Data Warehouse Developer (COF)

Kern Community College District

Position Number: 02479

Posting Date: 08/15/2018

Initial Screening Date: 08/29/2018

Open Until Filled: Yes

Position Type: Classified

Rate:

Work Week: 40 hours per week, 12 month position

Minimum Salary: $6,051.84 per month

Maximum Salary: $8,551.10 per month (starting salary will be commensurate w/experience )

Benefits:
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, 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.

Education and Experience:
Any combination equivalent to: Bachelors degree in Information Systems, Computer Science or related field and some experience working with or supporting information technology systems.

OR

An Associates 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:
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 Ellucians Operational Data Store (ODS), Cognos, 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.

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-users 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 August 29, 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.

Recruitment Status (tentative):
Application Screening: TBD
Interviews: TBD

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

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