Data Analyst

Job description

Equal Opportunity and Nondiscrimination Statement                                    

In addition to its commitment to a harassment-free educational and working environment, the College is an equal employment opportunity employer. The College is committed to a policy of equal employment opportunities for all applicants and employees and complies with all applicable state and federal laws on the matter. The College does not unlawfully discriminate on the basis of race, color, religion, sex (including gender, pregnancy, childbirth, or related medical conditions), gender identity, gender expression, national origin, ancestry, age, physical disability, mental disability, medical condition or medical leave, marital status, sexual orientation, or any other category protected by law. The College also prohibits the harassment of any employee on any of these bases.



Claremont, CA


Job Posting Title:

Data Analyst


Job Details and Requirement:

Basic Function/Summary of Position:

The Data Analyst is charged with data analysis and reporting for Institutional Research and the Soll Center for Student Opportunity. Core elements of the role include collecting and validating data from multiple databases and sources, interpreting data and analyzing results using statistical techniques, authoring reports and developing data visualizations and dashboards, and writing procedures that will allow for easier access and ongoing analysis of data within multiple systems. 

The Registrar and Institutional Research offices are in a combined office at CMC.  The IR office mission is to conduct research to support the continuing academic advancement of CMC, institutional decision-making, and strategic planning. The Soll Center for Student Opportunity is home to career services, the scholar communities, and sponsored internships and experiences and assists students in exploring, cultivating, and translating their skills, interests, and talents into real-world opportunities.  This position will support the institutional research needs of both offices.   


Essential Functions:

1. Collect and analyze data from multiple databases, including CX (student data), Handshake (career development), Raiser’s Edge (alumni/development), Slate (admissions), and Workday, along with relevant reporting tools (Cognos, etc.)

2. Prepare reports, data visualizations, and dashboards using tools, such as Tableau, infographics and macro-enabled workbooks.

3. Scrape, collect, filter, and validate data from non-CMC databases and data sources, such as LinkedIn, the National Student Clearinghouse StudentTracker, and other aggregated sources of graduate outcome metrics.

4. Conduct statistical analysis using Excel, SPSS, or R.

5. Identify, analyze, and interpret trends or patterns in complex data sets, such as sponsored internship and experience data and graduate outcome data.

6. Work with management to help prioritize business and information needs.

7. Locate and define new process improvement opportunities.  Draft policies and procedures to execute improvements.

8. Respond to internal and external inquiries regarding data pertaining to student outcomes.

9. Other duties as assigned.

Required Knowledge, Skills, and Abilities: 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 accommodations, using some other combination of skills and abilities. The position requires:

  • Proven work experience as a research, data, or business data analyst.
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information and reports with attention to detail and accuracy.
  • Skilled at attention to details, problem-solving, and solutions focused
  • Experience with databases, reporting tools, and data visualization tools within a networked systems environment.
  • Knowledge of statistics and experience using statistical software for analyzing datasets (Excel, SPSS, R, SAS, etc.).
  • Experience using Handshake analytics and reporting tools is preferred.
  • Experience working with financial data, preferably in financial aid.
  • Excellent oral and written skills are a must. 
  • Experience in meeting the needs of a diverse and highly motivated population. 
  • Experience in using statistics to effectively inform business decisions.
  • Excellent interpersonal skills, including demonstrated ability to simultaneously work with multiple constituencies including students, alumni, faculty, administrators, parents, and employers while maintaining the highest levels of confidentiality.


Qualification Standards:

EDUCATION:  A bachelor’s degree, preferably in the social or natural sciences with advanced preparation in statistics or other quantitative field, is required. 

EXPERIENCE:  2 years of proven work experience or a combination of work experience and an advanced degree with increasing responsibility in data analytics is required.

LICENSES:  A valid driver’s license or equivalent means of reliable transportation to off-site meetings and events is required.



The Colleges regular office hours for are 8:00 am-5:00 pm Monday through Friday. Holiday, weekend and evening work hours may be required. The hours for this position, however, may vary due to needs of the College. Some domestic travel is required.



This is a full-time, 12-month exempt level, benefits-eligible position.



This position reports to the Director of Institutional Research with a dotted line to the Director of Student Opportunities.



Light (up to 20 lbs.)


The Claremont Colleges seek to maintain a neat and professional image at all times.  A uniform is required for certain events and will be provided.


The successful candidate will be required to undergo a full consumer background check.  Certain positions will require the successful completion of a post-offer physical agility test.  Employment is contingent on the satisfactory results of the aforementioned, in addition to compliance with requirements cited in this job description.

ADA/OSHA:  This job description defines the essential or fundamental job duties of this position.   It is assumed that employees hired for this position can perform the essential functions of this job without imposing risk of substantial harm to the health or safety of themselves or others.  It may also include marginal functions, generally defined within Title 1 of the Americans with Disabilities Act (ADA) and the Occupational Safety and Health Administration (OSHA).

DISCLAIMER: This job description has been designed to indicate the general nature and level of work performed by employees within this classification.  It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this position.  When duties and responsibilities change and develop, the College will review this job description and make changes of business necessity.


Employment with the College is “at-will” meaning that the terms of employment may be changed with or without notice, with or without cause, including, but not limited to termination, demotion, promotion, transfer, compensation, benefits, duties, and location of work.  There is no agreement express or implied between the College and you for continuing or long-term employment. While the College has every hope that employment relationships will be mutually beneficial and rewarding, employees and the College retain the right to terminate the employment relationship at will, at any time, with or without cause.  The President is the only person who can modify or alter the at-will employment relationship.

Claremont McKenna College hires and promotes individuals on the basis of their qualifications, consistent with applicable state and federal laws, without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, pregnancy, breastfeeding or related medical condition, national origin, ancestry, citizenship, age, marital status, physical disability, mental disability, medical condition, genetic characteristic or information, military and veteran status, or any other characteristic protected by state or federal law.  Inquiries may be directed to the Director for Human Resources, 528 N. Mills Avenue, Claremont, California 91711-4015, (909) 621-8490.  All applicants must complete and submit an online application to be considered for an open position.

Employment is contingent upon new employee providing documents verifying U.S. citizenship or, for aliens, documents verifying legal permission to work in the United States, applicant's acceptability for positions requiring use of a college vehicle is contingent upon a driving record acceptable to the College's automobile liability insurance. Promotion from within is encouraged whenever qualified employees of Claremont McKenna College are available. Interested employees of the College are urged to contact the Office of Human Resources if qualified for any open position. Please do not contact departments directly.

Disability Accommodations                                                                                    

In compliance with applicable laws ensuring equal opportunities to qualified individuals with a disability, CMC will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual (applicant or employee) with a disability if the disability affects the performance of essential job functions, unless the accommodation results in an undue hardship for the College. Employment decisions are based on the merit and not an individual’s disability.               

An applicant or employee who requires an accommodation should contact the immediate supervisor and the Human Resources Office. If multiple accommodations are identified that do not pose an undue hardship for the College, the selection of an accommodation will be at CMC’s discretion. To request disability accommodation for any part of the application or hiring process, please contact Human Resources at (909) 621-8490 or [email protected] for assistance.




Diversity Profile: University



View more

Learn more on Inside Higher Ed's College Page for University

Arrow pointing right
Job No: REQ-1832
Posted: 7/15/2019
Application Due: 9/13/2019
Work Type: