Data Warehouse Developer
- Kern Community College District
- California, United States
- Salary Not specified
- Posted Date
- Dec 28, 2022
- Position Type
- Administrative, Business & Administrative Affairs, Computer Services & Information Technology
- Employment Level
- Employment Type
- Full Time
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
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.
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.
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
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 https://www.schooljobs.com/careers/kccd/jobs/3840276/data-warehouse-developer. Emails will not be accepted.
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.Create alert