Position Classification Title: Enterprise Data Architect,Assc
Position Classification Code: M1061
Job Family: Information Technology
Pay Level: 08
Exempt Status: Exempt
This description is intended to describe the general nature of the work being performed. It is not intended to be a complete list of specific duties of any particular position. Duties, responsibilities and bargaining unit eligibility may vary based on the specific tasks assigned to the position.
Purpose of Classification:
Under immediate supervision, in support of a university enterprise system, assists in the design and construction of relational databases for data warehousing. Develops data modeling. 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. Assists in continuous improvement efforts to increase functionality and performance.
Standard Duties:
Creates 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. Participates and provides input into key aspects of the business case and work effort for a specific project. Participates and provides input into functional & non-functional requirements. Participates in 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.Performs miscellaneous job-related duties as assigned.
Knowledge, Skills and Abilities:
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.
Minimum Qualifications:
   Education- Bachelor's degree in a related field.
   Experience- No previous work experience required.
   Equivalency- None
   Departmental Requirements-
   Special Requirements-