Data Architect I (Data Architect) Austin, Texas

General Description

Performs highly complex (senior level) data architecture work and data analysis. Work involves data modeling; implementing and managing database systems, data warehouses, and data analytics; and designing strategies and setting standards for operations, programming, and security.

Essential Job Functions

• Determines and maintains the agency’s overall medallion infrastructure, modular infrastructure and overall data architecture and specific data model requirements for all future solutions including: the development and implementation of data models for new projects, data structures for data warehouses and data mart projects, the use of and changes to technical and business metadata and their impact to the agency’s business and enterprise applications, data analytics and business intelligence systems, security or protection against unauthorized access or modification.

• Supports the Agency’s Data Governance Efforts Through Driving data governance initiatives, including policy development, data stewardship, and end-user training programs on data governance policies and tools. Maintains documentation of data governance policies, processes, standards, and data definitions. Assists in the implementation and adoption of data governance tools and platforms. Supports audits and regulatory reporting by ensuring proper data documentation and controls are in place. Monitoring data maturity progress and support continuous improvement of governance practices.

• Establishes measures to chart progress related to the accuracy of data quality (including metadata) for enterprise information; to support reduction of data redundancy, fragmentation, the elimination of unnecessary movement of data, and to improve the overall agency data quality.

• Affords assistance or provides direction to team members associated with identification of appropriate data sources (including the systems of record) for extraction processes and data use in the agency’s business applications, identification of root causes related to non-conformance of data to published data standards using available tools and analyses, including metadata or other data quality related information, selection and usage of data management tools to support the development of data standards, data usage guidelines and procedures, the creation of data models and required data standards for ensuring data quality, data security and data applicability to the agency’s business requirements.

• Performs related work as assigned and may supervise the work of others.

Minimum Qualifications

• Education: Graduation from an accredited four-year college or university with major coursework in computer science, information technology, computer information systems, data management systems, data security or a related data management discipline. AND Experience: Two (2) years full-time work experience in information technology security, computer information systems, management information systems, or a related data management field.

• Applicable Substitutions: Experience and education may be substituted for one another.

• OR Graduation from a standard senior high school or equivalent; and Six years full-time work experience in information technology security, computer information systems, management information systems, or a related data management field.

Knowledge, Skills, And Abilities

• Knowledge: Knowledge of master data, metadata, reference data, data warehousing, and business intelligence principles and processes, including technical architecture; of enterprise information management processes and methodologies, relational database management systems, metadata management, and business intelligence and business analytics tools; of local, state, and federal laws and regulations relevant to data management and data governance, such as the Open & Closed Data Portal; knowledge of the limitations and capabilities of computer systems; of technology across all network layers and computer platforms; and of operational support of networks, operating systems, Internet technologies, databases, and security applications.

• Skills: Skill in the use of applicable software, and in project management and system development life-cycle concepts. Skill in Google Cloud Platform (GCP) and Tableau Software.

• Abilities: Ability to communicate effectively, and to supervise the work of others. Ability to work with overlapping deadlines and priorities.

Physical Requirements/Supplemental Information

• This position functions in a standard office environment. Must be able to move around the office to access filing cabinets, office equipment and move up to 20 pounds. Must be able to communicate and exchange information via phone, computer, in person and via electronic media. Must be able to perform repetitive use of a keyboard at a workstation. Must be able to work with overlapping deadlines.

• This position is expected to work in the office but may be eligible for situational or hybrid telework schedule upon completion of an initial probationary period. For teleworking, must have a secure, dedicated workspace with internet service, ability to maintain a reliable consistent work schedule and be available for meetings and group collaboration via Microsoft Teams or other platforms/applications during regular business hours.