Position Classification Title: Enterpr Data Architect,Inter
Position Classification Code: M1058
Job Family: Information Technology
Pay Level: 09
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 supervision supporting a university enterprise system, designs and constructs 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; researches data sources for new and better data feeds.
Standard Duties:
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 provides input into key aspects of the business case and work effort for a specific project. Reviews 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. Assists in continuous improvement efforts in enhancing performance and providing increased functionality.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- Three (3) years of experience directly related to the standard duties as outlined.
   Equivalency- None
   Departmental Requirements-
   Special Requirements-