Job Seekers
Post Resume
Find Jobs
Get jobs by email
Post Jobs
Find Resumes
Get resumes by email
Database Analyst
Lake Tahoe Community College in South Lake Tahoe, California
Date Posted 05/14/2021
Salary 56,980 - 62,891  USD Per Year
Employment Type Fulltime
Application Deadline Open until filled

Lake Tahoe Community College District announces an opportunity to work in the Department of Institutional Effectiveness. This is a full-time (12 month); classified position that reports to the director of Institutional Effectiveness. The Database Analyst coordinates, validates, and submits data to external entities; with opportunities for institutional research. Well-suited candidates for this position will be proficient in Microsoft SQL programming, SAP Business Objects and Tableau with experience in Colleague ERP by Ellucian, state MIS reporting, IPEDS, and National Student Clearinghouse submissions. Additionally, being skilled in R and/or Python programming is beneficial.

The Office of Institutional Effectiveness (IE) at Lake Tahoe Community College aims to continuously build and support a culture of inquiry and evidence-based decision making. The department supports student success and pursues institutional excellence by providing support and leadership in the areas of accreditation, planning, research, assessment, and evaluation. This is accomplished through objective coordination, collection, organization, compilation, and dissemination of information concerning the characteristics and performance of the College.

Hours are expected to be Monday-Friday, generally within the hours of 8 am to 5 pm; however, hours may vary according to the needs of the program.


After review, suitable applicants will be invited to participate in a skills assessment stage of the screening process. These applicants will be notified by phone or email on or about Tuesday, June 8, 2021. Successful candidates will then be interviewed by a committee of 3 or 4 individuals; these interviews are tentatively scheduled for June 24, 2021. Finalists will then be selected and invited to a secondary process. Meeting the minimum requirements does not guarantee an interview.

LTCC reserves the right to return to the applicant pool at any point during the recruitment process.


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.

Representative Duties:

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.

Other Duties:

Perform related duties as assigned.

Employment Standards:

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.

Knowledge of:

  • 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.

Ability to:

  • 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.

Working Environment:

  • Indoor/Office environment.
*Please mention academicjobs.net to employers when applying for this job*
Academic Jobs
Academic Advertising
260 Peachtree Street, N.W.
Suite 2200
Atlanta, GA 30303
Google Plus
About Academic Jobs
Advertise Jobs
Contact Us
Site Map
Privacy Policy
Terms of Use
Resources / Links
Copyright © 2010 Academic Jobs - All Rights Reserved.