Data Warehouse Developer

4 weeks ago


Bakersfield, United States Kern Community College District Full time

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 monthly Maximum Entry Level Salary:   $7,273.94 monthly
 SPECIAL INSTRUCTIONS First 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. 
 
 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.


 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.


Kern Community College District provides a rich health and welfare benefits package to our full-time permanent 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.

Limited benefits and Affordable Care Act (ACA) benefits are offered to less than full-time and temporary employees.

For a detailed list of benefit eligibility please visit our
 



  • Bakersfield, United States Kern Community College District Full time

    **Salary** - $6,923.44 - $9,782.64 Monthly**Location** - Bakersfield, CA**Job Type** - Classified**Job Number** - FY23-2400825**College** - District Office**Opening Date** - 05/23/2024**Closing Date** - Continuous**Basic Function**: - Under the direction of an assigned supervisor, perform design, development, implementation, maintenance and enhancement...


  • Bakersfield, California, United States Kern Community College District Full time

    Data Warehouse Developer Kern Community College DistrictSalary: $6, $9,782.64 Monthly Job Type: Full Time Job Number: FY 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,...


  • Bakersfield, California, United States Kern Community College Full time

    Data Warehouse DeveloperKern Community College DistrictSalary: $6, $9,782.64 MonthlyJob Type: Full TimeJob Number: FY Location: Bakersfield, CADepartment: Basic Function Under the direction of an assigned supervisor, perform design, development, implementation, maintenance and enhancement related activities necessary to support data warehousing, business...


  • Bakersfield, California, United States Kern Community College District Full time

    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...

  • Warehouse Associate

    1 month ago


    Bakersfield, United States Channel Partners Group Full time

    We are looking for a capable Warehouse Associate to support our company’s warehouse operations. You will receive, input, sort, load and unload products and you will perform various warehouse activities. **Responsibilities**: - Process, package and ship orders accurately - Organize stocks and maintain inventory - Inspect products for defects and damages -...

  • Warehouse Manager

    1 week ago


    Bakersfield, United States A1 Oxygen Full time

    Warehouse Manager Job Description For A1 Oxygen We are looking for a reliable Warehouse Manager who is concerned with customer satisfaction and ensuring orders are fulfilled in a safe, timely manner. Warehouse manager is responsible for planning, organizing, and controlling warehouse fulfillment operations, including maintaining inventory and completing...


  • Bakersfield, United States Dignity Health Management Services Full time

    **Overview** **This position is remote.** The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and...


  • Bakersfield, United States Dignity Health Management Services Full time

    **Overview** **This position is remote.** The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and...


  • Bakersfield, United States KHS Full time

    We appreciate your interest in our organization and assure you that we are sincerely interested in your qualifications. A clear understanding of your background and work history will help us potentially place you in a position that meets your objectives and those of the organization. Qualified applicants are considered for positions without regard to race,...


  • Bakersfield, United States Unavailable Full time

    Overview ***This position is remote. The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and...


  • Bakersfield, United States CommonSpirit Health Full time

    Overview: ***This position is remote. The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and...


  • Bakersfield, United States Dignity Health Full time

    Overview ***This position is remote. The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and geographies...


  • Bakersfield, United States Dignity Health Full time

    Overview ***This position is remote. The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and geographies...

  • Warehouse Specialist

    1 month ago


    Bakersfield, United States Panama-Buena Vista Union School District Full time

    Position Type: Classified Substitute Date Posted: 6/1/2023 Location: Various School Sites Closing Date: Open Until Filled Summary: Receives, storing of supplies, materials, and equipment. Receives and processes purchased goods, supplies, and equipment. Participates in the organization and maintenance of warehouse supplies, materials and equipment. ...


  • Bakersfield, United States Kern Health Systems Full time

    KHS reasonably expects to pay starting compensation for the position of Business Intelligence Data Analyst I in the range of $30.20-40.05 hourly. Our Mission.. Kern Health Systems is dedicated to improving the health status of our members through an integrated managed health care delivery system. **General Purpose**: This position is responsible for...

  • Warehouse Supervisor

    1 month ago


    Bakersfield, United States Bolthouse Fresh Foods Full time

    Job DescriptionJob DescriptionTHE ROLE: This position will report to the: Shift Manager - Warehouse ShippingTravel Requirement: NoneFLSA Status: Non-ExemptShift: Weekend PM ShiftEmployment Category: Full-Time HourlySTRONG HISTORY. EXCITING FUTURE. Established in 2023, New Carrot Company, operating under the name Bolthouse Fresh Foods, is headquartered in the...

  • Parts Warehouse

    3 weeks ago


    Bakersfield, United States Coastline Equipment Full time

    John Deere Construction Equipment Dealership with multiple locations serving Southern California, Nevada and Idaho is looking for a **Parts Warehouse** for our **Bakersfield, CA location**. **Responsibilities**: - Quickly establish rapport and relationship with customers. - Provides quality customer experience through knowledge, use of systems, and process...


  • Bakersfield, United States EMCOR Services Mesa Energy Full time

    Mesa Energy Systems is a wholly owned subsidiary of EMCOR Group, Inc. EMCOR is the world’s leading provider of mechanical and electrical construction and facilities services, including planning, consulting, and operations and maintenance. Mesa Energy Systems is a HVAC mechanical services company that provides fully integrated solutions for preventative...

  • Warehouse/reciever

    3 weeks ago


    Bakersfield, United States Good Samaritan Hospital CA LTD PTP Full time

    Description: I. ***: Under the supervision of the Materials Manager, the Warehouse Receiver performs the purchasing function within Hospital guidelines. Leads inventory process and conducts full inventories as required, receives all incoming supplies, delivers supplies to appropriate departments and conducts par levels for various...


  • Bakersfield, United States Califia Farms, LLC Full time

    Overview: **WHO WE ARE: CALIFIA FARMS** Rooted in California, Califia Farms is on a mission to create a future where plants replace dairy, without compromise. The company creates a variety of great-tasting plant-based beverages that make the transition to eating plant-based dairy easy and delicious. Califia Farms is one of the fastest-growing, independently...