NMSU is an equal opportunity and affirmative action employer.
Creates 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 provide input into key aspects of the business case and work effort for a specific project. Reviews and provide input into functional & non-functional requirements. May provide 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. May supervise personnel which includes: 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.
This position may be under-filled as an Enterprise Data Architect, Intermediate Level 09 on a career development plan if unable to fill at the Enterprise Data Architect, Sr Level 10. Minimum requirements for the Enterpr Data Architect,Inter (lower) level: Bachelor’s degree in a related field. Three (3) years of experience directly related to the standard duties as outlined.
Under minimal supervision, 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.
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.