Institutional Research & Data Systems Analyst

Posted on10/25/2017
Job typeFull-time
Reports toUnspecified
Reports in officeUnspecified
Application due date12/18/2017
Job start date10/19/2017
InstitutionCollege of Marin
Institution descriptionInstitutional Research & Data Systems Analyst

Salary: See Position Description

Job Type: Full-time

Location: Kentfield Campus, Kentfield, California


Priority Screening Date: November 9, 2017
All application materials must be received by the Priority Screening Date in order to be considered during the initial screening. Applications received after this date may be considered thereafter at the discretion of the college until the position is filled.
Under general supervision of the assigned supervisor, perform a variety of specialized technical activities involved in data collection, storage, documentation, extraction, reporting, research and analysis related to institutional planning, effectiveness, accreditation, student success, enrollment, placement tests, grants and other areas required by external entities and used internally by staff, faculty and administrators for projects and decision-making; utilize programming, scripting and analysis to develop, test, maintain, update and enhance a relational database, automate data-related tasks, and ensure accuracy and integrity of institutional data used for research, analysis and reporting.

College of Marin strives to embrace diversity in all forms: it strives to be an inclusive community that fosters an open, enlightened and productive environment and demonstrates sensitivity to and respect for a diverse population

To Apply:
Job dutiesEssential Functions:

Perform a variety of specialized activities involved in data collection, storage, documentation, extraction, testing, research, analysis and reporting of data related to institutional planning, effectiveness, accreditation, student success, enrollment, placement tests, grants and other areas required by external entities and used by staff, faculty and administrators for projects and decision-making; verify and ensure integrity of database, data and reports. Support accreditation, student success initiatives, strategic plan research, and a variety of data needs.

Input, process, test and update a variety of data and information in data systems; create queries and scripting to test, extract and manipulate data, and create and automate reports for use in projects, studies and analysis.

Create, design, produce, document and maintain a variety of specialized reports to provide data-driven evidence for institutional effectiveness and performance improvement projects, analyses and activities; develop and generate tables and graphs to enhance data presentation and reporting; prepare, develop, modify and automate a variety of special forms and templates.

Compile, assemble, evaluate and prepare a variety of educational data for use in reports and institutional planning activities according to project, survey and study specifications, needs, requests and requirements; analyze and compare a variety of data from different sources to determine appropriate use in reports; review a variety of data and reports to ensure accuracy and completeness; automate data tables and report production and uploading to department webpages.

Coordinate and prepare specialized reports required by the Chancellor's Office as assigned; input and verify uploaded data concerning institutional characteristics, degrees and certificates awarded, placement tests, student success indicators, and Human Resources and Finance data; collaborate with the Information Technology department on data required by the Chancellor's Office.

Participate in institutional data governance committee, work groups and processes that improve and ensure the quality, precision, integrity & standardization of the institution's data. Collaborate with Information Technology, Office of Instructional Management, Enrollment Services, Human Resources, Fiscal, Career-Technical Education, Community Education and other departments as needed.

Receive and evaluate requests for resolving data governance issues, data tables, tracking and analysis; process requests; arrange and maintain project schedules and time lines; develop and implement strategies to complete assignments within deadline.

Compare data and identify errors and discrepancies; make corrections, additions and modifications as needed based on standard definitions and protocols.

Operate a variety of office equipment including a copier, fax machine, scanner, computer and a variety of specialized software.

Communicate with personnel and various outside agencies to exchange information and resolve issues or concerns as needed.

Prepare, distribute and respond to a variety of correspondence related to assigned projects, studies and activities.

Perform related duties as assigned.
QualificationsRequirements & Desirables:

• Any combination equivalent to: a Bachelor's degree in Mathematics, Computer Science, Business Administration or a related field and two years' professional experience developing and maintaining relational databases, working knowledge of programming languages and reporting tools, and hands-on data analysis and reporting; and
• Demonstrated sensitivity to and an understanding of the diverse academic, socioeconomic, cultural and ethnic backgrounds, abilities and learning styles of community college students and staff

• Working knowledge of SQL, Access, Visual Basic, Tableau, Ellucian Banner, XML

KNOWLEDGE, SKILLS & ABILITIES (Desirable Attributes & Skills):

• Principles, practices, procedures and techniques involved in the collection, storage, testing, analysis and reporting of statistical data.
• Programming, database and reporting languages and scripting for developing and testing databases and data and automating reports
• Record retrieval and storage systems, especially relational databases.
• Data extraction methods through programming and queries used in producing automated and ad-hoc reports.
• Data collection information systems and statistical and reporting software.
• Data control procedures and data entry operations.
• Report writing and technical documentation.
• Data verification and clean-up procedures
• Correct English usage, grammar, spelling, punctuation and vocabulary.
• Interpersonal skills using tact, patience and courtesy.
• Oral and written communication skills.
• Statistical and mathematical computations.
• Policies and objectives of assigned programs and activities.


• Perform a variety of specialized technical activities involved in data collection, storage, documentation, extraction, reporting, research and analysis related to institutional planning, effectiveness, accreditation, student success, enrollment, placement tests, grants and other areas required by external entities and used internally by staff, faculty and administrators for projects and decision-making.
• Develop, maintain and utilize relational databases and data storage systems to ensure data quality and integrity and produce a variety of ad-hoc and standardized reports.
• Use programming language, scripting and query writing to develop data systems, test data, automate reports and produce a variety of ad-hoc reports requested by staff, faculty and administrators.
• Participate in a variety of surveys and related research and data analysis activities.
• Develop and generate tables and graphs to enhance data presentation and reporting.
• Review, track and verify input and output data from entry through retrieval points in the system to ensure data quality, integrity, and accuracy for data governance purposes.
• Verify and ensure integrity and accuracy of data and reports.
• Analyze data, draw conclusions and provide related recommendations.
• Develop and maintain technical documentation.
• Establish and maintain cooperative and effective working relationships with others.
• Work independently with little direction.
• Communicate effectively both orally and in writing.
• Meet schedules and time lines.
• Plan and organize work.
• Perform accurate mathematical and statistical calculations.
Salary range$80,000 - $100,000
Prior to employment, the selected candidate will be required to complete the following:
• In accordance with Federal Law all employees must provide proof of eligibility to work in the United States.
• Criminal Justice/Fingerprint Clearance.
• California Education Code, Section 87408.6 requires persons employed by a community college in an academic or classified position to submit to a TB risk assessment developed by CDPH and CTCA and, if risk factors are present, an examination to determine that he or she is free of infectious TB; initially upon hire and every four years thereafter.
• DISASTER SERVICE WORKERS: All Marin Community College District (MCCD) employees are designated Disaster Service Workers through state and local law ( Employment with the MCCD requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency. For more information, please see the
• Candidates applying for positions with the Marin Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
The following documents must be attached to your application in order to render it complete. Use the Attachment Type indicated in parentheses when making your attachments.
• Cover Letter (cover letter)
• Resume (resume)
• Transcript conferring Bachelor's degree or showing whatever coursework you have completed and are using as the basis for your application as described in Requirement #1, above. (transcript)NOTE: If you hold additional degrees beyond the Bachelor's level, please attach a copy of your transcript conferring these degrees as well. Unofficial transcripts are acceptable for application purposes, as long as they confer the degree and show the coursework taken and grades achieved.

Supplemental & Salary Information:


• Dexterity of hands and fingers to operate a computer keyboard
• Hearing and speaking to exchange information in person and on the telephone
• Sitting and/or standing for extended periods of time
• Seeing to read a variety of materials
• Bending at the waist, kneeling or crouching to file materials
• Reaching overhead, above the shoulders and horizontally
• Generally the job requires 70% sitting, 15% walking and 15% standing
• Office environment
• Constant interruptions

Employees in classifications represented by the California School Employees' Association (CSEA) Chapter 196 and are required to comply fully with the CSEA/Marin Community College District (MCCD) Collective Bargaining Agreement, including payment of union dues or charitable contributions. General information regarding rights and responsibilities under the Agreement can be found in the Collective Bargaining Agreements section of our Human Resources site. CSEA employees are also members of the California Public Employees Retirement System (CalPERS), to which the member contributes 6% of his/her reportable compensation on a monthly basis.

Campus: Kentfield Campus
Full-time Equivalent: 1.0 – Full-time
Months per Year: 12
Work Days/Hours:
Monday - Friday
8:00am to 4:30pm (one-hour lunch) ** specific work hours are flexible and can be worked out with manager upon hire**
7.5 Hours per Day
37.5 Hours per Week

NOTE: The College is closed on Fridays during the summer period, when the work schedule may change to Monday through Thursday according to departmental needs

FLSA Status: Non-exempt
Salary Range: CSEA 135
Starting Salary Range: $6,667.38 - $7,349.88 per month (Step 1 to 3). Normal entering step is Step 1.

Please refer to our Human Resources web site for salary schedules.
Application procedureTo learn more and to apply please visit our website.

Applications must include the documents listed in the Required Documents section to be rendered complete; incomplete applications will not be accepted. Screening will begin after the priority screening date. Applicants selected to interview will be contacted to schedule an interview appointment with the screening committee; however, applicants will be notified of their status, either way, following the screening. Candidates forwarded by the committee following the first interview may be invited for a second interview. Regrettably, College of Marin is not able to offer reimbursement for travel to interviews at this time.