Data Analyst

Job TitlePerforms highly skilled professional functions in the design and reporting of research projects.ResponsibilitiesPrepares and submits complex compliance reports, including but not limited to: IPEDS, ASSIST, WUE, Annual Report to the Governor, ETPL, Perkins, and the AZ 2040 High School Performance Report. Reviews report requirements annually and updates report queries to match requirements.Coordinates all activities associated with administering surveys, including designing, formatting, scanning, describing, analyzing, summarizing, and presenting results; monitors and collects research data to assess accuracy, validity, and reliability; writes reports highlighting key findings and conclusions; and makes presentations of results as needed.Conducts basic statistical analyses of data; interprets results; reviews and verifies factors affecting data reliability, procedural integrity, coding accuracy, data security, and related issues; enters data and creates spreadsheets; and files for special project sources.Uses various tools such as: SQL Server Management Studio (SSMS); SQL Server Database; MS Forms; Power Automate; Power BI; SQL; and MS Office tools like Excel or Word.Creates and maintains datasets for research queries from a wide variety of internal and external sources; responds to requests for data from internal and external sources including College management.Responds to ad hoc requests for data including: providing customized reports, highlighting main findings and key points, effectively communicating the results to the user (orally and in writing), and making recommendations based upon findings.Ensures information on CAC's public website (the Institutional Effectiveness page) remains current. Also ensures that reports published under the Student Right to Know webpage are updated annually as appropriate.Performs other duties commensurate with functions and level of position or as assigned.QualificationsEDUCATION: Bachelor's degree.EXPERIENCE: Three (3) years of applicable experience.SPECIAL POSITION CONDITIONS: None.Background Verification: As a condition of employment, all candidates accepting an offer of employment for a full-time, part-time, temporary, student worker, or volunteer position, will be required to undergo a Background Verification. Employment with Central Arizona College is contingent upon the successful completion of the background verification. The level the background verification for this position is: Standard level.All applicants must be at least 18 years of age or older to be considered for this position.Knowledge, Skills, & AbilitiesKnowledge of the various departments, functions, and processes associated with an institution of higher education.Basic knowledge of Structured Query Language (SQL) preferredKnowledge of organizational processes in a research office.Knowledge of software including: SSMS, Power Bi, MS Office tools (Excel, Word, etc.), Microsoft forms, and Power Automate.Skill in analyzing data.Skill in data validation.Skill in working with relational databases.Skill in using Microsoft Office Suite.Skill in communicating, both verbally and in writing.Ability to learn new software tools to support data analysisAbility to read, interpret and follow compliance requirements.PHYSICAL REQUIREMENTS:The work is sedentary work. The employee is occasionally required to exert up to 10 pounds of force to move objects. Additionally, the following physical abilities are required: hearing, mental acuity, speaking, standing, talking, visual acuity in data, and walking. Duties performed may cause light fatigue of eyes, fingers, or other faculties due to long periods of standing and/or sitting.INTERPERSONAL SKILLS:Important Level - Position engages in or requires some or all of the following: uses alternative or combined human relations skills in understanding other people and influencing their behavior in order to achieve job objectives; applies skills of persuasiveness or assertiveness, as well as sensitivity to other person's point of view in order to influence their behavior, change an opinion, or turn a situation around; provides direction, consultation, and/or training; deals with confidential information; and/or has moderate level of contact with students, program participants, and/or the public.WORKING CONDITIONS:Work is performed in a safe and secure work environment that may periodically have unpredicted requirements or demands. Job is performed in general office or comparable working area with occasional distractions such as noise and interruptions or in congested work areas with exposure to some disagreeable elements.CAC is an equal opportunity employer and complies with all applicable federal, state, and local laws regarding equal employment opportunity and anti-discrimination. CAC strictly prohibits and does not tolerate discrimination on the basis of the following protected classes and/or characteristics, in all of its operations, programs and activities, including but not limited to employment, promotion, admissions and access to all career and technical programs: race, color, religion, creed, national origin or ancestry, ethnicity, sex, age, physical or mental disability, citizenship, past, current, or prospective service in the uniformed services, genetic information, or any other characteristic protected under applicable federal, state, or local law. For more information contact: Laura Shepherd, Title IX Coordinator at View phone number on click.appcast.io or View email address on click.appcast.io; Section 504/ADA Coordinator at View email address on click.appcast.io or Human Resources at View email address on click.appcast.io Notice: As a condition of employment, all full time Central Arizona College employee's automatically become members of the Arizona State Retirement System (ASRS). This is a pension system that requires mandatory contributions from the employee with a matching contribution from the employer. The 26-27 fiscal year contribution rate is 11.98%. Please note this rate is subject to change on a fiscal year basis. Membership to ASRS is a condition of employment and is not optional unless you are at least 65 years of age and meet the opt out eligibility requirements, or are a retiree from ASRS . Please consider this when applying for this position.We acknowledge that our institution, Central Arizona College, occupies ancestral lands of the Huhugam (HU-hu-gum), who lived and farmed along the Gila River Basin centuries ago. We thank the Native communities and descendants of these Indigenous people whose stewardship of the land and waterways allows us to be here now: the San Carlos Apache Tribe, Tohono O'odham (THO'-oh-no OH'-oh-thum) Nation, Ak-Chin (AK-Chin) Indian Community,? and the Gila River Indian Community, which is comprised of the Akimel O'odham (A-kee-med/r OH-oh-thum) (Pima) and the PEE-Posh (Maricopa) tribes. Indigenous people from other Native nations also reside in Pinal County. Arizona is home to 22 federally recognized Tribes. All have made innumerable contributions to our region.BenefitsCentral Arizona College offers full-time employees and their dependents an excellent benefit package that includes low cost medical, dental, and vision insurance. Part-time positions are not eligible for health benefits. Central Arizona College