Applied Information Technology Specialist - Academic Foundations and Connections
Clackamas Community College
August 1, 2018
Oregon City, Oregon
Full Time - Experienced
Technical (Programmer, Developer, Analyst)
4 Year Degree
Applied Information Technology Specialist - Academic Foundations and Connections Clackamas Community College
Works as a team member in the Division of Academic Foundations and Connections. Serves as an institution-wide technical expert and works closely with IT in the design, programming, implementation, deployment, and ongoing support of complex databases, computer systems and applications. Generates applied information and analytics to assist division departments ranging from Enrollment and Student Services to Math and English, and reporting for data integrity, student, and college effectiveness at the institutional, division/department, and program/service levels. Supports the dean, associate deans, service directors and department chairs. Provides strategic planning, department planning, program/service review processes, and systems application support..
ESSENTIAL JOB FUNCTIONS: Review, analyze, and make recommendations to the Academic Foundations and Connections division, the College, and reporting leadership regarding efficient and effective use of current database and collection systems, software applications, and training practices.
Act as a liaison between division department users and ITS technical staff to communicate the status of projects, problem resolution, or to investigate functionality improvements to better support applied information in support of the Academic Foundation and Connections division.
Manage large and small group applied information projects that involve both business process and technical changes.
Respond to user questions regarding existing applied information systems.
Design, develop, and deploy institutional, departmental, functional, and ad hoc reports as needed in support of state and federal accountabilities, accreditation, planning, department/program review, and instructional assessment.
Collaborate with ITS division in the design, development, implementation, testing, and usability/integrity maintenance of institutional data warehousing and reporting systems so that these systems afford data analysis at the institutional, division/department, and program/service level.
Assist in the development of the technical architecture and design of data warehouse(s) as driven by the applied information needs for student and college success.
Assist in developing complex data sets for routine and ad hoc reporting.
Analyze processes, procedures, and set-up of extracts and querying procedures to support improved process flow and regulatory compliance associated with federal, state, and institutional requirements.
Assist with identifying and implementing information and training solutions.
Assess solution needs and design solutions to improve information processes.
Explore methods for improving access to, and disseminating information from, applied information systems to decision-making.
Advise management and staff across institution related to their impact on data and data needs by reviewing and analyzing existing college business policies, practices, and procedures.
Collaborate with division leadership to develop and implement the institutional data integrity training plan, including development of training materials and conducting training sessions.
Assist with data quality initiatives.
Oversee the development and management of documentation for institutional data standards, content of data tables and fields, data mapping (table/field linking standards), and data extract parameter guidelines.
Identify and implement methods for improving reliability and consistency of reporting and form, improving integrity of student data.
Work with the division leadership team to establish and maintain best practices and operational standards related to applied information systems, including data audit processes.
Manage the implementation of new software applications.
Maintain confidentiality and security measures to ensure safeguarding of confidential and/or sensitive data, files, and documents.
Participate on committees as necessary, including the CCC Colleague User Group, and the CCC Data Integrity Group.
Complete other related work as assigned.
Participate in departmental and college wide meetings as necessary.
Develop and maintain cooperative working relationship with colleagues, College staff, supervisors, other organizations, and the public.
Follow all safety rules and procedures for work areas.
AUXILIARY JOB FUNCTIONS: May provide assistance to other department personnel as workload and staffing levels dictate. Maintain proficiency by attending training and meetings, reading materials, and meeting with others in areas of responsibility. Maintain work areas in a clean and orderly manner.
Qualifications The education and/or work experience sections of your online application form must demonstrate that you meet all of the following Minimum Qualifications. The information on the cover letter/resume will not substitute for the completed application. MINIMUM/MANDATORY EDUCATION AND EXPERIENCE REQUIREMENTS: Any equivalent combination of education and experience which provides the applicant with the knowledge, skills, and abilities required to perform the duties as described. A typical way to obtain the knowledge, skills and abilities would be: Bachelor's Degree in Computer Science, Business Administration, or related field AND five years' experience in developing and managing databases and systems, troubleshooting applied information software applications, information needs assessment, and/or developing and delivering documentation and training.
KNOWLEDGE: Advanced knowledge of relational databases. Knowledge of complex data systems, SQL reporting, and Business Intelligence systems. Knowledge of data mining and management for small to large data sets, integrated database systems, networks, and microcomputer systems and software. Knowledge of general office practices and procedures, grammar/spelling, and positive customer service. Knowledge of state and federal accountability and assessment policies. Knowledge of practices and guidelines pertaining to community colleges, general business operations, processes, and procedures. Knowledge of a higher education information system, preferably Ellucian Colleague, is preferred. Knowledge of college business processes and procedures as aligned with course, student, and enrollment data is preferred.
SKILL: Skill in using standard software to manipulate large datasets for querying, analysis and visualization. SQL programming language. Excellent analytical skills, including knowledge of descriptive statistics and strong technical writing skills to document project management and data procedures as well as communicate findings to range of audiences. Strong interpersonal communication, planning, and organizational skills. Project management and facilitation skills for large and small groups and cross-functional teams. Skill in the use of personal computers; office software programs including MS applications such as Word, Access, PowerPoint, and Excel as well as Microsoft SQL Reporting Services (SSRS), SQL Analysis Services, Report Builder, Integration Services (SSIS), Excel and/or SAP Business Objects; phone system; and standard use of office equipment.
ABILITIES: Ability to establish and maintain an effective working relationship with students, staff, other agencies, and the general public; manage time effectively; work independently and as part of a team; work with integrity and ethics; focus on attention to detail; read and interpret policies, regulations and laws as they relate to this job; communicate effectively, both orally and in writing, including the ability to provide customer service and support to individuals and groups with varying degrees of experience; maintain a high degree of discretion when dealing with sensitive/confidential information. Physical ability to perform the essential job functions.
SPECIAL REQUIREMENTS/LICENSES: Valid Driver's License accepted in the state of Oregon.
DESIRABLE REQUIREMENTS: Graduate work in related field such as information sciences (data systems design and management, information design and communications) or research is preferred.
Other Job Elements The physical demands listed below represent those that must be met by an incumbent to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with qualified disabilities to perform the essential functions. PHYSICAL DEMANDS OF POSITION: While performing the duties of this position, the employee is frequently required to sit, stand, bend, kneel, stoop, communicate, reach and manipulate objects. The position requires mobility. Duties involve moving materials weighing up to 5 pounds on a regular basis such as files, books, office equipment, etc., and may infrequently require moving materials weighing up to 15 pounds. Manual dexterity and coordination are required over 50% of the work period while operating equipment such as computer keyboard, calculator, and standard office equipment.
The work environment characteristics described below are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. WORKING CONDITIONS: Usual office working conditions. The noise level in the work area is typical of most office environments with telephones, personal interruptions, and background noises.
SUPERVISORY RESPONSIBILITIES: Supervision of others is not a typical function assigned to this position. May provide training and orientation to newly assigned personnel, and may assign work to student workers.
SUPERVISION RECEIVED: Works under the general direction of the Dean of Academic Foundations and Connections.
Additional Information Clackamas Community College is a diverse community that provides equal opportunity in employment, activities, and its programs.It is the policy of the Clackamas Community College and its Board that there will be no discrimination or harassment in any educations programs, activities or employment on the grounds of race, color, religion, ethnicity, use of native language, national origin, sex, sexual orientation, marital status, disability, veteran status, age, genetic information or any other status protected under applicable federal, state or local laws.
The College also prohibits retaliation against an individual for engaging in activity protected under this policy, and interfering with rights or privileges granted under anti-discrimination laws.
Persons having questions about equal opportunity and nondiscrimination should contact the dean of Human Resources for Clackamas Community College in Barlow Hall at the Oregon City campus, 503-594-3300. Please note the following areas of responsibility, should you need relevant resources or information: Section 504 Coordinator, Disability Coordinator, Oregon City campus, 503-594-3181; Title II Coordinator, Associate Dean, Oregon City campus, 503-594-3392; Title IX Coordinator, Dean, Human Resources, Oregon City campus, 503-594-3300.
----------------------------------------------------------------------------------------------------------------------------------ADDITIONAL POSTING INSTRUCTIONS: To apply for this position, you must submit:
Completed online application
Cover Letter explaining your interest in the position and describing how you meet the minimum and special qualifications and requirements of the position
Two (2) Letters of Recommendation
Completed responses to the Supplemental Questions
Upon hire, candidate will be required to provide official transcripts for degrees earned, if applicable.
----------------------------------------------------------------------------------------------------------------------------------SUPPLEMENTAL INFORMATION: CCC only accepts applications through this online application system. We want you to be successful in applying with us. We highly encourage you to complete and submit your application in advance of the deadline.
For assistance with this, please email firstname.lastname@example.org. For technical assistance with your application, please call (855) 524-5627.
Please note: This is initially a self-screening system. We recognize that our application process can be lengthy, so before you begin, please read all of the stated requirements to determine if you meet them. Applicants must meet all of the stated minimum/special qualifications and additional requirements to be considered for this position. Based on your responses to the qualifying questions, the system may automatically screen you out from further consideration.
Required documents must be provided at the time of application. Please remove any personal information such as photographs, date of birth, gender, social security number, and other protected information from your documents. Documents containing protected information will be considered incomplete. Incomplete applications will not be considered.
Positions are subject to budget consideration and approval. For the candidate who is hired into this position, salary placement will be based on guidelines in the handbook or association agreement (as applicable) to assess education and experience. For this reason, please be sure to include everything in your application that you want the college to consider towards placement.
Clackamas Community College participates in E-Verify and will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS) with information from each new employee's Form I-9 to confirm work authorization. This information is kept completely confidential, is obtained only after a candidate is hired, and will not be used to pre-screen any job applicant.
The college does not sponsor employees in the visa application process if they intend to use this as their means to work in the United States. This means that all required work visas must be in place and supported by appropriate evidence to be employed by Clackamas.
----------------------------------------------------------------------------------------------------------------------------------REASONABLE ACCOMMODATION STATEMENT: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job.
This job description is a general description of essential job functions. It is not intended as an employment contract nor is it intended to describe all responsibilities, skills, effort, or work conditions associated with the job someone in this position would perform. All employees of Clackamas Community College are expected to perform tasks as assigned by Clackamas Community College supervisory/management personnel regardless of job title or routine job duties.
VETERAN'S PREFERENCE STATEMENT: Applicants are eligible to use Veteran's Preference when applying with Clackamas Community College in accordance with ORS 408.225, 408.230 and 408.235; and OAR 105-040-0010 and 105-040-0015. Preference will only be given if the applicant meets the minimum qualifications and any special qualifications for the position and electronically attach the required documentation at the time of application.
MEMBER COPY 4 of the Certificate of Release or Discharge from Active Duty (DD Form 214 or 215) – OR – Letter from the US Dept. of Veterans Affairs indicating a non-service connected pension.
Disabled Veterans must also submit a copy of their Veterans disability preference letter from the Department of Veterans Affairs.