Position Type: Computer and Information Technology
Data Warehouse Developer
Kern Community College District
Salary: $6,923.44 - $9,782.64 Monthly
Job Type:
Job Number: FY23-2400825
Location: Bakersfield, CA
Department:
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.
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. 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.
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 RANGE$6,923.44 - $9,782.64 monthlyMaximum Entry Level Salary: $7,273.94 monthly SPECIAL INSTRUCTIONSFirst Review of Applications: Complete application packets will be accepted until the position is filled; but those received by June 6, 2024, 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
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.
