"Reporting and Integration Analyst"

General Description

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.

Essential Functions

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.

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