Under the direction of the Director of Institutional Effectiveness, provide System Query Language programming analysis of technical specifications and coding to maintain, modify, expand or create and respond to user needs; ensure operation of programs within District’s administrative applications/systems; perform a variety of technical duties in the development, maintenance and analysis of assigned computer database systems; organize the activities and operations of the MIS data validation processes; develop, test, implement, maintain and document programming code for existing and new administrative software application; provide for system enhancements; facilitate the computerized collection, management, manipulation and distribution of data used for analysis and reporting.
Utilize and support integrated management information systems and related interfaces to perform complex technical duties including the System Query Language, analysis, development, operation, and programming for reporting, data submission and extraction and custom workflows; assist with customized report development.
Create and develop custom System Query Language queries; design, develop and write System Query Language subroutines, computed columns, and scripts to meet District reporting needs and user specifications; assist with the collection and distribution of data used for research, analysis, and reporting; analyze data; ensure accuracy of data output; prepare and submit reports.
Participate in testing of updates, processes, integrations and applications to ensure accuracy, effectiveness, and usability; research, evaluate and recommend solutions and enhancements to promote system performance, reliability, and operational productivity; develop and manage a calendar of required reports while maintaining established security protocols and confidentiality of restricted data.
Maintain awareness of technological developments in support of enterprise applications; make recommendations; interact with resources such as user groups and technology organizations
Utilize existing processes and assist with the development of new processes to move data between systems including providing data migration support for integration projects; map data elements; translate data between disparate systems; guide end users in the appropriate maintenance of data to ensure data integrity.
Create and submit required documentation for MIS, National Student Clearinghouse, and Gainful Employment reporting, 1098-t tax documents; and assist with creation and maintenance of database generated reports for District use.
Perform system troubleshooting; assist with problem-solving efforts including interacting with external vendors, consultants, and support personnel.
Education and Experience:
Any combination equivalent to: Associate’s degree or equivalent in information systems, computer science, or related field and two years of programming experience including familiarity with enterprise applications, student information systems, learning management systems, and data warehouses.
- Practices, procedures and methods involved in the maintenance and analysis of assigned computer database systems.
- Programming languages.
- System Query Language.
- Integrated data collection, management, validation and distribution requirements for analysis and reporting functions.
- Management Information Systems reporting requirements and data elements.
- Database structures, on-line applications and system capabilities of the District’s computer systems.
- Principles, practices and techniques of data base structures and system enhancements.
- Principles, methods and procedures of operating computers and peripheral equipment.
- Principles and practices of data processing as applied to automation of office procedures.
- Record retrieval and storage systems.
- Oral and written communication skills.
- Interpersonal skills using tact, patience and courtesy.
- Technical aspects of field of specialty.
- Test and debug programs and products.
- Analyze and maintain integrated enterprise systems.
- Modify processes and procedures to solve complex problems.
- Demonstrate proficiency in designated computer programming languages.
- Perform a variety of technical duties in the maintenance and analysis of assigned computer database systems to meet District needs and provide for system enhancements.
- Modify existing programs to improve reporting and record maintenance.
- Implement necessary alterations to enhance and ensure proper functioning of assigned reports and processes.
- Modify database operations to enhance system performance and presentation of data.
- Review and evaluate existing database designs to determine effectiveness and operational efficiency.
- Communicate effectively both orally and in writing.
- Establish and maintain cooperative and effective working relationships with others.
- Work independently with little direction.
- Plan and organize work.
- Meet schedules and time lines.
- Maintain records related to work performed.
Additional Requirement (Licensure/Certification):
- Applicable Industry certifications.
At 6,229 feet above sea level, Lake Tahoe Community College, set in the heart of South Lake Tahoe, is located at the highest elevation of any college in Northern California.
Opened in 1975, approximately 3,000 students come through the doors each quarter. Beyond the classrooms and labs, the 164-acre wooded campus also features a 192-seat black box theater, a world-class soccer field, extensive art lab, a Child Development Center, and much more. A 26,000-square-foot gymnasium with a dance studio and fitness education center, plus a Student Center, which includes a café and commercial-grade kitchen for the culinary arts program were opened in 2002. In 2006, the college opened a new 27,000-square-foot library and adjoining art gallery.
The University of California, the California State Universities, and other accredited colleges and universities give full credit for equivalent and transferable courses satisfactorily completed at Lake Tahoe Community College. The college is also approved for veteran's benefits.
The college calendar is based on the quarter system, with each quarter 12 weeks long. Following the three quarters there is a six-week summer session. For dates and deadlines, check out the Academic Calendar.
With 31 associate degree options plus 28 career and technical certificates to choose from, students can pursue a wide variety of interests such as our Lake Tahoe Basin Fire Academy program and offerings in allied health, business administration, commercial music, criminal justice, digital media, and wilderness education. Transfer degrees prepare students for admission to California State University campuses.
Outdoor recreation can be found all year in South Lake Tahoe, a town of about 21,000 residents. Students are within minutes of three ski resorts. There are a total of 14 resorts located around Lake Tahoe. Summer brings water sports, fishing, hiking, camping, and an extensive network of mountain biking trails. The sun shines an average 75 percent or 274 days each year, giving students plenty of opportunities to get out and explore the Sierra Nevada mountains.