Data Warehouse Developer

1 week ago

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


Data Warehouse Developer
Kern Community College District

Salary: $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, 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, $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

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

jeid-14e8fda5f1f0574f8669d1ce6058b0c6

  • Data Warehouse Developer

    4 weeks ago

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

  • Data Warehouse Developer

    1 week ago

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

  • Data Governance Analyst III

    1 week ago

    Bakersfield, California, 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,...

  • Data Analyst

    1 week ago

    Bakersfield, California, United States Creative Financial Staffing Full time

    Data Analyst About the Company and Opportunity: Company is dedicated to quality, safety, honesty, and providing excellent customer service They offer continuous education for their employees and provide extensive opportunities for growth Leadership is dedicated to employee's success Family-oriented, casual, and relaxed environment Our client offers...

  • Internship – Data Scientist, Marketing Communications

    3 months ago

    Bakersfield, California, United States Twilio Full time

    Job Description:Twilio is looking for a Data Science professional who wants to build hypotheses and design experiments in the domain of marketing and advertising. You are eager to learn and inspire, and you like to think at scale and work with real-world problems, distilling takeaways for less-technical audiences.[ads1]Job Responsibilities:As a Data...

  • Internship – Data Scientist, Marketing Communications

    4 weeks ago

    Bakersfield, California, United States Twilio Full time

    Job Description:Twilio is looking for a Data Science professional who wants to build hypotheses and design experiments in the domain of marketing and advertising. You are eager to learn and inspire, and you like to think at scale and work with real-world problems, distilling takeaways for less-technical audiences.[ads1]Job Responsibilities:As a Data...

  • Job Development Specialist

    1 month ago

    Bakersfield, California, United States Kern Community College Full time

    Job Development Specialist , CTE (BC)Kern Community College DistrictSalary: $4, $6,589.84 MonthlyJob Type: Full TimeJob Number: FY Location: Bakersfield, CADepartment: Career Technical EducationBasic Function Under the direction of an assigned supervisor, provide specialized assistance and service within the job development and job placement program; solicit...

  • Job Development Specialist

    3 weeks ago

    Bakersfield, California, United States Kern Community College Full time

    Job Development Specialist , CTE (BC)Kern Community College DistrictSalary: $4, $6,589.84 MonthlyJob Type: Full TimeJob Number: FY Location: Bakersfield, CADepartment: Career Technical EducationBasic Function Under the direction of an assigned supervisor, provide specialized assistance and service within the job development and job placement program; solicit...

  • Receiving Clerk

    1 week ago

    Bakersfield, California, United States Wally's Distribution Full time

    Job Title: Receiving ClerkLocation: Bakersfield, CACompany: Wally's DistributionSchedule:Mon-Fri 7AM - 3:30PMPay Rate:$17 - $19 per hour along with health benefits, paid time off (PTO), and a 401(k) plan.*Benefits become available after the 90-day probationary period.Reports To:Office ManagerA receiving clerk is the key point of contact for our customers to...

  • Business Developer SLED

    4 weeks ago

    Bakersfield, California, United States Staples, Inc. Full time

    Staples is business to business. You're what binds us together.Prospects within defined territory to pursue two main responsibilities: penetration of existing accounts by winning net new sites. Responsible for ramping and onboarding accounts to further expand our customer base. It is a high velocity sales position that leverages a prioritized action list to...

  • Business Developer SLED

    1 month ago

    Bakersfield, California, United States Staples, Inc. Full time

    Staples is business to business. You're what binds us together.Prospects within defined territory to pursue two main responsibilities: penetration of existing accounts by winning net new sites. Responsible for ramping and onboarding accounts to further expand our customer base. It is a high velocity sales position that leverages a prioritized action list to...

  • Enterprise Resource Planning Analyst I

    1 week ago

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

    Salary- $6, $9,782.64 MonthlyLocation Bakersfield, CAJob Type ClassifiedRemote Employment Remote OptionalJob Number FY College District OfficeDepartment/Division Information Technology ServicesOpening Date 05/28/2024Closing Date ContinuousBasic Function:DISTINGUISHING CHARACTERISTICS:The Enterprise Resource Planning (ERP) Analyst I perform duties related to...

  • Job No. 534761 Research Analyst

    1 week ago

    Bakersfield, California, United States tapwage Full time

    CANDIDATES ELIGIBLE TO APPLY:Open to all qualified applicants.SPECIAL INSTRUCTIONS TO APPLICANT: FOR PRIORITY CONSIDERATION, applications must be received by January 11, 2024; however, the position will remain open until filled.WORKPLACE TYPE:Telecommute eligible (work onsite as scheduled and/or as requested and telecommute as scheduled)CLASSIFICATION...

  • Job No. 534761 Research Analyst

    3 weeks ago

    Bakersfield, California, United States tapwage Full time

    CANDIDATES ELIGIBLE TO APPLY:Open to all qualified applicants.SPECIAL INSTRUCTIONS TO APPLICANT: FOR PRIORITY CONSIDERATION, applications must be received by January 11, 2024; however, the position will remain open until filled.WORKPLACE TYPE:Telecommute eligible (work onsite as scheduled and/or as requested and telecommute as scheduled)CLASSIFICATION...

  • Configuration Analyst – 100% Remote

    4 weeks ago

    Bakersfield, California, United States Surf Search Full time

    General Purpose:The Enterprise Configuration Analyst III will be responsible for the design, configuration, testing, and maintenance of the Jiva Care Management System, our client's chosen platform for healthcare management and workflow automation. The successful candidate will work closely with various stakeholders to understand business requirements and...

  • Configuration Analyst – 100% Remote

    4 weeks ago

    Bakersfield, California, United States Surf Search Full time

    General Purpose:The Enterprise Configuration Analyst III will be responsible for the design, configuration, testing, and maintenance of the Jiva Care Management System, our client's chosen platform for healthcare management and workflow automation. The successful candidate will work closely with various stakeholders to understand business requirements and...

  • Sales Specialist

    1 week ago

    Bakersfield, California, United States Core-Mark Full time

    Company DescriptionCore-Mark continues to grow as the industry leader in fresh and broadline solutions for the convenience retail industry. With a reputation for empowering customers, employees, and communities, Core-Mark has become the largest, most comprehensive marketer of consumer goods in North America - offering a full range of products, programs, and...

  • Driver - CDL

    1 week ago

    Bakersfield, California, United States White Cap Full time

    A position at White Cap isn't your ordinary job. You'll work in an exciting and diverse environment, meet interesting people, and have a variety of career opportunities.The White Cap family is committed to Building Trust on Every Job. We do this by being deeply knowledgeable, fully capable, and always dependable, and our associates are the driving force...

  • Administrative Coordinator II

    4 weeks ago

    Bakersfield, California, United States Kaiser Permanente Full time

    Job Summary:Helps facilitate information maintenance and distribution by learning and drafting routine and standard presentations, correspondence, and reports. Organizes workflow by following detailed instructions in the identification and assistance of the resolution of routine requests from front-line teams and department managers on an ad-hoc basis....

  • Administrative Coordinator II

    1 month ago

    Bakersfield, California, United States Kaiser Permanente Full time

    Job Summary:Helps facilitate information maintenance and distribution by learning and drafting routine and standard presentations, correspondence, and reports. Organizes workflow by following detailed instructions in the identification and assistance of the resolution of routine requests from front-line teams and department managers on an ad-hoc basis....