Institutional Research & Data Systems Analyst

[Back to all jobs]
Posted on	4/26/2018
Job type	Full-time
Reports to	College of Marin
Reports in office	College of Marin
Application due date	Open until filled
Job start date	See Description
City	Kentfield
State/Province	California
Institution	College of Marin
Institution description	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 Established in 1926, College of Marin (COM) is one of 114 public community colleges in California accredited by the Western Association of Schools and Colleges. COM has two campuses in beautiful Marin County. The Kentfield Campus is located just north of the Golden Gate Bridge in Kentfield and the Indian Valley Campus is located minutes away on a spectacular 333 acre site in Novato. College of Marin's commitment to educational excellence is rooted in providing equitable opportunities and fostering success for all members of our diverse community by offering: • preparation for transfer to four-year colleges and universities • associate degrees and certificates • career technical education • basic skills improvement • English as a second language • lifelong learning • community and cultural enrichment College of Marin responds to community needs by offering student-centered programs and services in a supportive, innovative learning environment that promotes social and environmental responsibility. COM serves a county population of approximately 250,000 residents. Based on fall 2017 credit enrollment data, the diversity of students at the college includes greater representation than the county with regards to enrollment by Hispanic/Latino (28% of enrollment), Asian (8%), Black/African American (4%), and Multi-racial (6%) students.
Job duties	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. OTHER FUNCTIONS: Perform related duties as assigned.
Qualifications	REQUIREMENTS • 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. DESIRABLE QUALIFICATIONS • Working knowledge of SQL, Access, Visual Basic, Tableau, Ellucian Banner, XML KNOWLEDGE, SKILLS & ABILITIES (Desirable Attributes & Skills): KNOWLEDGE OF: • 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. ABILITY TO: • 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. CONDITIONS OF EMPLOYMENT 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 (http://www.leginfo.ca.gov/cgi-bin/displaycode?section=gov&group=03001-04000&file=3100-3109). 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 http://www.marin.edu/police/EOP.html. • 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.
Salary range	$80,000 - $100,000
Salary benefits	SALARY INFORMATION FLSA Status: Non-exempt Salary Range: CSEA 135 Starting Salary Range: $7,000.50 - $7,717.13 per month (Step 1 to 3). Normal entering step is Step 1.
Application procedure	REQUIRED APPLICATION DOCUMENTS 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.