Database Analyst,Sr

Position Title: Database Analyst,Sr

Employee Classification: Database Analyst,Sr

College/Division: Engineering College

Department: 360001-ENGINEERING COLLEGE

Internal or External Search: External - Open to all applicants

Location: Las Cruces

Offsite Location (if applicable):

Target Hourly/Salary Rate: $89,224.00

Appointment Full-time Equivalency: 1.0

Exempt or Non-Exempt: Exempt

Summary: Database Analyst, Senior needed at New Mexico State University, Las Cruces, NM

Classification Summary:

Under minimal supervision, evaluates and designs existing or proposed systems to structure and access databases. Analyzes database requirements of the user department, applications programming and operations.

Submits recommendations for solutions that require definition of the physical structure and functional capabilities of databases and require data security and data backup/recovery specifications. Proposes detailed specifications and flowcharts and coordinates installation of revised or new systems.

Classification Standard Duties:

Usually works with minimal supervision, conferring with superior on unusual matters. May be assisted by Associate/Intermediate level personnel.

Assignments are broad in nature, usually requiring originality and ingenuity. Has appreciable latitude for unrelieved action or decision. Works with IT team to configure hardware or software to perform installations, upgrades, testing, working at optimization of capacity planning, data storage, efficiencies, and database growth.

Writes and understands Microsoft SQL. Writes SQL statements, stored procedures and views using industry best practices for security and efficiency. Works on database and code management, review and documentation.

Works with application developers to know how applications work and tests results. Creates, develops and manages internal procedures for various job functions within the ERP system. Manages relationship between ERP vendors and carousel.

Supports ERP software, database structure and data. Works with implementation team to build, customize and roll new ERP solution to organization and with consultants to design and build database structure specific to carousel's needs.May train Associate or Intermediate level personnel in technical complexities of assigned work.Performs miscellaneous job-related duties as assigned.

Required Education, Experience, Certification/License, Equivalency

Required Education:Bachelor's degree in a related field.; Required Experience:Five (5) years of experience directly related to the standard duties as outlined.; Equivalency:None; Required Certification/License:

Knowledge, Skills and Abilities

KNOWLEDGE:Knowledge and understanding of principles, procedures, regulations, and standards applicable to the job. Understanding of the University's mission, vision and goals.; SKILLS:short- and long-term planning; problem analysis and resolution; report preparation and presentation; interpersonal and organizational communication, both oral and written.; ABILITIES:Ability to gather and interpret relevant data and information.

Ability to use inductive reasoning. Ability to determine the interrelationships between solutions and requirements. Should be able to communicate and market data administration concepts to management, staffs and clients.

Ability to think analytically and should be a problem solver. Ability to make effective decisions under pressure.

Job Duties and Responsibilities

Responsible for collecting data efficiently and managing systems accurately for outcome reporting and programmatic improvement of the College of Engineering and the College of Agriculture, Consumer, and Environmental Sciences (ACES). The position is vital in the ability to help achieve the goals of the NMSU's Strategic Plan, LEADS 2025. The position will be responsible for the design, creation, and effective management of databases which will manage the data and run operations of the desired data by the requested users, such as the Deans, Associate Deans, and administrative personnel in both Colleges (Engineering and ACES). This position is crucial in assisting the Deans and Associate Deans in providing the most accurate and current data required for reporting to key constituents such as NMSU's administration, the State of New Mexico, the College's Advisory Boards, college faculty and staff, etc.

A successful data analyst should have a combination of technical and leadership skills and a strong background in mathematics. This position reports-to Engineering; however, it is partly funded by the College of ACES for duties and responsibilities that are common to both colleges. College of Engineering: 1.

Analyze data from such advanced information systems as Gray's data, academic and curricular analytics, Delaware Data System, and ASEE data in the context of Leads 2025 goals. 2. Use visual and statistical software to prepare presentations and reports summarizing the trends for use in decision making. 3. Train department heads, associate/assistant deans, and other staff in the interpretation of data summaries.

College of ACES: 1. Develop, extract, analyze data, and create visuals that are easy to interpret for the college of ACES, for example courses cost instruction, student enrollment trends, research expenditures, etc. 2. Designs and maintains the data for the College of ACES utilizing all NMSU reporting systems using statistical software such as Tableau. 3. Interprets and presents data to ACES Dean's Chief of Staff and Leadership team and makes necessary recommendations based on data analytics.

Preferred Qualifications

Special Requirements of the Position

Department Contact: Gcisnero@nmsu.edu

Contingent Upon Funding: Not Applicable

Bargaining Unit Eligibility: This is NOT a bargaining unit position with American Federation of State, County & Municipal Employees (AFSCME).

Standard Work Schedule: Standard (M-F, 8-5)

If Not a Standard Work Schedule:

Working Conditions and Physical Effort

Environment: Work is normally performed in a typical interior/office work environment.

Physical Effort: No or very limited physical effort required.

Lifting Requirements: Requires handling of average-weight objects up to 10 pounds or some standing or walking.

Risk: No or very limited exposure to physical risk.

Recruitment Summary

We are New Mexico's land-grant institution and a comprehensive research university dedicated to teaching, research public service and outreach at all levels. NMSU is a welcoming community of talented faculty, staff and students who are working together to make a difference.

We are a NASA Space Grant College, a Hispanic-serving institution (HSI), a minority-serving institution (MSI) and home to the first Honors College in New Mexico. We offer an accessible education that shapes bright futures.

NMSU provides learning opportunities to a diverse population of students and community members at four campuses, Cooperative Extension offices located in each of New Mexico's 33 counties, 12 research and science centers, and through distance education.

NMSU Main Campus

Located in Las Cruces, NM, New Mexico State University's 900-acre main campus is located at the crossroads of I-10 and I-25 in the Southwestern United States. As a thriving center of higher education, deeply rooted in the regional tradition, its role as a comprehensive university is recognized throughout the state.

Doña Ana Community College

Founded in 1973 in collaboration with local school districts to support occupational education, DACC is now a leading community college that provides transformative educational opportunities that meet the workforce needs of Doña Ana County. With a focus on access, innovation and excellence, DACC offers over ninety degrees and certificates, adult education, specialized workforce training, and small business assistance.

Alamogordo Campus

Established in 1958 to serve the needs of the airmen and families stationed at Holloman Air Force Base located only 10 miles west of Alamogordo, NMSUA is a community college with a long history of excellence that is supported by a caring community of hard-working students and dedicated faculty and staff. The campus is situated "on the hill" above Alamogordo and provides inspiring views of the city and the Tularosa Basin, offering the perfect venue for creative and motivated learning.

Grants Campus

NMSU Grants was established as a branch of New Mexico State University in 1968 through the cooperative efforts of New Mexico State University and Grants Municipal Schools. As a two-year branch community college, NMSU Grants serves the local communities in Cibola and McKinley counties, including the Pueblos of Acoma, Laguna, and Zuni, as well as Tohajiilee, San Mateo, San Rafael, Cubero, the City of Grants, and the Village of Milan.

Special Instructions to Applicants

The electronic application is the official document that will be used to qualify applicants. Paper/email documents will not be accepted. Required documents must be attached to this application.

EEO Statement

NMSU is an equal opportunity and affirmative action employer committed to assembling a diverse, broadly trained faculty and staff. Women, minorities, people with disabilities, and veterans are strongly encouraged to apply. NMSU is an equal opportunity and affirmative action employer.