New Mexico State University invites you to apply to be a part of a diverse, dynamic and welcoming learning and working environment in Las Cruces, NM. NMSU seeks employees who are creative and flexible in developing and evaluating new ideas and ways to evolve NMSU into the future. Located in the borderlands and adjacent to the mighty Rio Grande, NMSU is a proud Hispanic-serving institution in the minority-majority state of New Mexico. Southern New Mexico features an average of 294 days of sunshine annually, making NMSU ideal for job-seekers who enjoy hiking, mountain biking, canoeing and bird-watching. NMSU is committed to sustainability through improving and maintaining the quality of human life while preserving the integrity, stability, and beauty of ecological systems for the future. We are looking for student-centered employees with a passion for success. NMSU invites you to take the first step to your successful and rewarding career by applying today.

NMSU is New Mexico’s land-grant and space-grant institution, a comprehensive research institution dedicated to teaching, research, public service and outreach. In addition, the NMSU system includes a satellite learning center in Albuquerque, Cooperative Extension Service offices located in each of New Mexico’s 33 counties, and 12 agriculture research and science centers. New Mexico State University is the institution of choice for more than 15,000 students from 49 states and 89 foreign countries.

The City of Las Cruces is the second largest city in New Mexico and is located in Doña Ana County, approximately 45 miles north of El Paso, Texas, and 225 miles south of Albuquerque. Las Cruces is the economic and geographic center of the Mesilla Valley, the agricultural region on the floodplain of the Rio Grande which extends from Hatch to the west side of El Paso, Texas. The Organ Mountains, 10 miles to the east, are dominant in the city’s landscape, along with the Doña Ana Mountains, Robledo Mountains, and Picacho Peak. Las Cruces lies within a short driving distance of the Mexican border at Santa Teresa, as well as many other locations in the broader borderland region.

Geography, climate, demographics, and ambiance of Las Cruces and NMSU combine to offer a truly excellent place to thrive. Family members will discover a warm, open community that offers an attractive array of activities and outdoor recreation, amenities, services and opportunities, whether they are looking for top-notch education, meaningful employment, or simply a safe and comfortable place to live.

Is responsible for the support of a university enterprise system. Develops data modeling and is responsible for data acquisition and access analysis and design; and archive, recovery, and load strategy design and implementation. Coordinates new data development ensuring consistency and integration with existing warehouse structure.

Under general supervision is responsible for the support of a university enterprise system. Oversees personnel in the design and construction of relational databases for data warehousing. Develops data modeling and is responsible for data acquisition and access analysis and design; and archive, recovery, and load strategy design and implementation. Coordinates new data development ensuring consistency and integration with existing warehouse structure. Reviews business requests for data and data usage.

Provides team leadership in the creation of high-level comprehensive data designs that address the needs of key stakeholders from the business, solution delivery and operations areas. Works with peers to conduct Data Architecture Reviews for a broad set of projects. Reviews and provides input into key aspects of the business case and work effort for a specific project. Reviews and provide input into functional & non-functional requirements. Provides consulting and conduct reviews through the development lifecycle. The Data Architect also performs gap analysis between planned data architecture functions and already established data architecture functions, particularly as previously handled by Application Structure and Integration Services.Researches data sources for new and better data feeds. Assists in continuous improvement efforts in enhancing performance and providing increased functionality.Oversees the supervision of personnel, which may include:work allocation, training, promotion and enforcement of internal procedures and controls and problem resolution; evaluates performance and makes recommendations for personnel actions; motivates employees to achieve peak productivity and performance. Performs miscellaneous job-related duties as assigned.

Strong knowledge of database design principals. Knowledge of data architecture concepts such as OLTP and OLAP systems, operational data stores, data warehouses, data marts, staging databases and data servicing layers; experience in designing these data architectures. Understanding of data modeling concepts such as use of conceptual, logical and physical data models. Demonstrated experience in relational database query tuning and indexing strategies. Experience with report development tools, Microsoft Business Intelligence Studio, Microsoft Reporting Services is desired. Knowledge of data integration strategies and technologies, such as hub and spoke messaging architectures. Familiarity with SQL Server replication and distributed database architecture. Systems analysis experience and capabilities.

Short- and long-term planning; problem analysis and resolution; report preparation and presentation; interpersonal and organizational communication, both oral and written.

Develop and maintain effective working relationships; maintain accurate and orderly records; use independent judgment and initiative; organize and direct activities.

Bachelor’s degree in a related field.

Five (5) years of experience directly related to the standard duties as outlined.

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.