Reporting and Integration Analyst

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:

Job Details and Requirement:

Department:  Data, Systems, and Integrations

Supervisor: Integration Specialist

The Reporting and Integration analyst will assist in developing cross-platform data integration solutions, supporting ERP systems, integrating web and portal applications from third parties, and creating documentation for integration processes. They support DSI by troubleshooting system errors and exception handling for integrations, as well as workflow components. The Reporting and Integration Analyst will support the Data Management and Integrity (DMI) committee 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.                      

Integrations:

• Support the development of cross-platform data integration solutions using tools like Prism to import data from third-party applications into various systems (e.g., Student Information System, Powerfaids, Raiser’s Edge).
• Participate in developing and conducting training sessions and help create documentation as needed for integration processes.
• Provide support for various window applications and ensure appropriate integration of technologies such as SQL Server, including troubleshooting production issues and recommending solutions.

Reporting Administrator: 

• Lead the Pitzer Reporting group for Power BI.
• Assist functional users in developing, writing, modifying, scheduling, and publishing reports following industry best practices as well as guidelines from the DMI Committee.
• Responsible for the maintenance of the Data Dictionary in partnership with the Data Management and Integrity work.
• Help support the DMI website and community training for adhering to best practices in data standards.

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.

Preferred Qualifications: Microsoft Data Analyst & Microsoft App Maker certification preferred. Preference will be given to individuals with higher education experience and previous Power BI experience.

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 $78,000- $83,000 per year The salary for the finalist(s) selected for this role will be set based on a variety of factors, including but not limited to internal equity, experience, education, specialty, and training.

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.