Database Warehouse Analyst jobs in Carson City, NV

Database Analyst

Institutional Effectiveness

$64,785 to $71,505 annually, dependent on education and experience

02/20/2024

04/01/2024

Definition:
Under the direction of the Director of Institutional Effectiveness, provide System Query Language (SQL) 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 analysis, development, operation, and programming for reporting, data submission and extraction and custom workflows; assist with customized report development.

Create and develop custom SQL queries; design, develop and write 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 Management Information Systems (MIS), National Student Clearinghouse, Integrated Postsecondary Education Data System (IPEDS), and Gainful Employment reporting, 1098-t tax documents; and assist with creation and maintenance of database generated reports (Business Objects) and dashboards (Tableau) for District use.

Perform system troubleshooting; assist with problem-solving efforts including interacting with external vendors, consultants, and college personnel.

Other Duties:
Perform related duties as assigned.

3