Position Title: Enterprise Data Architect,Ld

Employee Classification: Enterprise Data Architect,Ld

College/Division: Information Technology

Department: 450474-IT ANALYTICS AND DECISION SUPPORT

Internal or External Search: External - Open to all applicants

Location: Las Cruces

Offsite Location (if applicable):

Target Hourly/Salary Rate:  $67,161.67 - $87,310.17

Appointment Full-time Equivalency:  1.0

Exempt or Non-Exempt:  Exempt

Summary:  NMSU is seeking a skilled Business Intelligence Developer to drive data-driven decision-making through advanced analytics and strategic data solutions. This role partners with university leadership and technical teams to design and implement robust data architecture, ETL processes, and self-service analytics models. The ideal candidate will leverage industry best practices to enhance data collection, develop enterprise-wide datasets, and ensure seamless integration within NMSU’s data warehouse. Strong collaboration, technical expertise, and leadership skills are essential to manage junior staff and deliver high-impact data projects. If you’re ready to shape the future of analytics at NMSU, apply today!

Classification Summary:
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.

Classification Standard Duties:
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.

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: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.; SKILLS:Short- and long-term planning; problem analysis and resolution; report preparation and presentation; interpersonal and organizational communication, both oral and written.; ABILITIES:Develop and maintain effective working relationships; maintain accurate and orderly records; use independent judgment and initiative; organize and direct activities.

Job Duties and Responsibilities
In partnership with functional stakeholders, develop business intelligence solutions sourced from institutional and external data to meet the needs of university leadership and stakeholders. Collaborate with decision makers and other technical teams to implement data architecture and models to advance analytics at NMSU. Collect business requirements from subject matter experts and research sources of data to identify limitations and/or make recommendations to enhance data collection for purpose of enhanced analytics and decision making opportunities. Adhering to data management, data standards and industry-accepted architecture principles and best practices, develop extract, transform and load (ETL) processes to create datamarts from ancillary systems and external sources. Ensure adherence to industry-accepted architecture principles. Design datasets and data models for the enterprise across all business functions of the university for use in self-service analytics. Coordinates new data development with key stakeholders ensuring consistency and integration with existing warehouse structure. Supervise junior technical staff. Lead and execute data projects delivering on time and as expected.

Preferred Qualifications

ITIL is preferred
On-site position.

Special Requirements of the Position

Department Contact:  Jasmine Gomez, 575-646-3685, jgomez12@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.