Back

data engineer Claremont, CA

Pitzer College

Full Time Claremont, CA 80000 - 12.04 USD ANNUAL Today

Job description

Below you will find the details for the position including any supplementary documentation and questions you should review before applying for the opening.

Inquiries Regarding Application Status
Due to the high volume of applications we receive, we cannot respond to inquiries regarding the status of submitted applications. Applicants selected for interviews will be contacted using the email and/or phone information provided in the online application. For information regarding our general staff recruitment process, please click

here

to visit our FAQs web page to see answers for frequently asked questions, including what to expect, timelines, requests for special accommodation, and interviews.

Location:

Claremont, CA

Job Posting Title:

Data Warehouse & Reporting Administrator

Job Details and Requirement:

Position Title: Data Warehouse & Reporting Administrator

Department: Data, Systems, and Integrations

Supervisor: AVP College Systems & Data Management

GENERAL DESCRIPTION

The Data Warehouse & Reporting Administrator is primarily responsible for designing and managing the data warehouse, data packages, reporting tools, enterprise content management, and troubleshooting issues as they arise. The Data Warehouse & Reporting Administrator will research and evaluate data to ensure integrity and make recommendations about ways to improve data storage. They will support the data management team with maintaining the data dictionary and data standards. Responsible for maintaining reporting systems such as Power BI, Cognos, and Tableau, as well as any other reporting tools and support user training. Responsible for the integrity of data extraction and ensuring company information is secure.

ESSENTIAL FUNCTIONS

Data Warehouse:

Primarily responsible for the build and design of the data warehouse with extraction support from the team.
Responsible for the maintenance of the Data Dictionary in partnership with the Data Management and Integrity work.
Help support the website and community training for adhering to best practices in data standards.

Reporting Administrator:

Assist functional users in developing, writing, modifying, scheduling and publishing reports following industry best practices as well as guidelines from Data Management and Integrity Group.
Maintains licensing, users, roles, and data packages and security determined by the institution.
Uptake and train on new functionality as they become available.

Enterprise Content Management:

Responsible for the maintenance of the Pitzer OnBase instance in coloration with The Claremont College Services.
Responsible for custom queries to retrieve documents as appropriate and requested by Data Stewards.
Ensures the compliance of storage documents in alignment with any federal, state, or local organizational guidelines.

Team Planning:

Participate in sprint planning and sprint review sessions
Collaboratively manage source control with the team including branching and merging procedures
Participate punctually, effectively and professionally in meetings.
Collaborate with other teams to solve cross-functional challenges.
Provide training, testing, debugging, and documentation as required in partnership with team to uptake new functionality.
Learn new systems and adapt to changing technologies.

Perform other related duties as assigned.

Basic Qualification: Bachelor’s degree in data science or a related field and a minimum of two years of relevant experience. Microsoft Data Analyst & Microsoft App Maker certification required withing the first 9 months of employment. Preference will be given to individuals with higher education experience and previous IBM Cognos and Power BI experience.

REQUIRED KNOWLEDGE, SKILLS AND ABILITIES

The individual must possess knowledge, skills and ability to be able to successfully perform the essential functions of the position or be able to explain or demonstrate how the essential functions will be performed, with or without reasonable accommodation, using some other combination of skills and abilities.

Ability to coordinate and prioritize multiple concurrent projects, bring them to completion by the established deadlines, meeting expectations, and accommodate frequent interruptions.
Strong attention to detail and adherence to accuracy.
Punctuality and dependability are critical requirements for this position.
Ability to be proactive and work independently, and collaboratively as part of a team and with diverse populations.
Must have access to reliable and secure computer and internet connection. Must maintain password protection for work files and records and ensure that no one else has access to password and login credentials at remote work site.
Must have access to a dedicated and suitable workstation at remote location, including desk or table and supporting, upright chair. Must ensure workstation is safe and free from hazards.

Licenses/Certifications: Must have valid driver’s license and a driving record insurable under the College’s General Liability policy. Must be able to drive self to/from nearby off campus locations.

Supervisory Responsibility: None.

Time Type: Full-time 40 hours per week

Annual Pay Schedule: 12

Work Schedule: The regular hours for this position will be scheduled between 8:00 am to 5:00 pm, Monday through Friday. These hours may vary due to needs of the College or department.

Work Model: Hybrid

Compensation: Budgeted Salary $80,000 per year

Pitzer College is committed to providing comprehensive benefits to eligible employees and their eligible dependents. Our benefits package includes competitive compensation, health, dental, and vision insurance, retirement savings plans, generous paid time off (vacation, holidays, sick time, parental leave, bereavement, etc.), tuition reimbursement, tuition exchange program participation and more.

Physical Requirements: This is generally a sedentary position. Must be able to:

Sit for prolonged periods of time;
Operate a computer for prolonged periods of time;
Communicate with others by email, in person and over the telephone;
Read printed materials and a computer screen;
Have the mobility to work in a standard office setting and use standard office equipment;
Assist with the set-up and teardown of event tables, signage and other materials.
- Requires reaching overhead, grasping, pulling, pushing, stooping, bending, and twisting;
- Lift 15 pounds from the ground to waist level unassisted; and
Have the stamina to manage a high-volume workload in a fast-paced work environment.

Instructions: Only qualified applicants please.

Application Materials: Upload the following materials to complete your application:

Cover Letter: Indicate your reason for interest in this position, describe how your qualifications make you an ideal candidate, and explain which of Pitzer’s core values best relates to your own.
Resume: List relevant qualifications and dates of experience.
Professional References: References will be contacted for select applicants and advance notice will be provided. Provide the names of at least three (3) individuals who can speak to your professional qualifications. Include their business titles, contact information and an indication of how you are acquainted with them (e.g., former supervisor, coworker, etc.).

Employment Requirements
Employment is contingent upon a candidate possessing the knowledge, skills and abilities to be able to successfully perform the essential duties of the position, or be able to explain or demonstrate how the essential functions will be performed, with or without reasonable accommodation, using some other combination of skills and abilities. Employment is also contingent upon new employees providing documents verifying U.S. citizenship or, for aliens, documents verifying legal permission to work in the United States. For positions requiring the use of a college-owned vehicle, employment is contingent upon a driving record acceptable to the colleges’ automobile liability insurance. Final candidates in all staff positions will be required to undergo a background investigation; in addition some positions may require a physical lift test and pulmonary function test.

Covid-19 Vaccination

Pitzer College has mandated the COVID-19 vaccination for all employees. New employees are required to show proof of full vaccination, including booster, against COVID-19 or request a Pitzer College approved medical or religious exemption on or before their first day of employment.

Equal Employment Opportunity and Non-Discrimination

Pitzer College adheres to both the letter and the spirit of Equal Employment opportunity and Affirmative Action. It does not discriminate on the basis of race, color, creed, religion, national or ethnic origin, sex, gender, age, sexual orientation, marital status, pregnancy, disability, medical condition, or veteran status, in the administration of its admission policies, educational policies, scholarship and loan programs, athletic and other College-administered programs, and employment policies. Pitzer strongly encourages candidates from underrepresented groups to apply.

Safety Report

In compliance with applicable law, Pitzer College publishes an annual report containing statistical information concerning the occurrence of crime on campus and adjacent thereto, as well as policies and practices concerning security. A copy of this report is online at http://www.cuc.claremont.edu/cs/index.asp or by contacting The Claremont Colleges Department of Campus Safety: 251 E. Eleventh Street, Claremont, CA 91711-3947; (909) 621-8170.

Post Jobs Online Apply Job