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.
DESCRIPTION OF DUTIES AND RESPONSIBILITIES:
Collect and analyze data from multiple databases, including CX (student data), Handshake (career development), PowerFAIDS (financial aid), Raiser’s Edge (alumni/development), Slate (admissions), and Workday, along with relevant reporting tools (Cognos, etc.).
Prepare reports, data visualizations, and dashboards using tools, such as Tableau, infographics and macro-enabled workbooks.
Gather, 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.
Conduct statistical analysis using Excel, SPSS, or R.
Identify, analyze, and interpret trends or patterns in complex data sets, such as sponsored internship and experience data and graduate outcome data.
Work with management to help prioritize business and information needs.
Locate and define new process improvement opportunities. Draft policies and procedures to execute improvements.
Respond to internal and external inquiries regarding data pertaining to student outcomes.
Other duties as assigned.
OTHER ESSENTIAL FUNCTIONS: Performs other essential duties and tasks specific to the position and as many be assigned from time to time. Additionally, other essential functions include:
Ability to take and follow directions.
Ability to work cooperatively with others.
Ability to receive and respond appropriately to constructive criticism.
Ability to display a positive attitude.
Ability to multitask.
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.
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 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.
EDUCATION: A bachelor’s degree, preferably in the social or natural sciences with advanced preparation in statistics or other quantitative field, is required.
EXPERIENCE: Two 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.
HOURS: 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 12 month position.
CLASSIFICATION AND STATUS: This is a regular, full-time, exempt position. This is a benefits-eligible position.
REPORTS TO: This position reports to the Director of Institutional Research with a dotted line to the Director of Student Opportunities.
IPEDS Category Job Code: 15-0000 Computer and Mathematical Occupations
Physical Requirements: Light (up to 20 lbs.)
GROOMING AND APPEARANCE: 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.
BACKGROUND CHECK: 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.
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.
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@example.com for assistance.
The Claremont Colleges, a consortium of five undergraduate liberal arts colleges, two graduate institutions, and Claremont University Consortium, which provides shared institutional support services, is reminiscent of the Oxford-Cambridge model. The undergraduate colleges include Pomona College, Scripps College, Claremont McKenna College, Harvey Mudd College, and Pitzer College. The two graduate institutions include Claremont Graduate University and Keck Graduate Institute.