Data Architect I (Data Architect) Austin, Texas

General Description

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. May supervise the work of others. Works under limited supervision, with moderate latitude for the use of initiative and independent judgment.

Essential Job Functions

% of Time

ESSENTIAL JOB FUNCTIONS (EJFs)

45%

Requirements

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.
  
  

25%

Support 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.
• Maintaining documentation of data governance policies, processes, standards, and data definitions.
• Assisting in the implementation and adoption of data governance tools and platforms.
• Supporting 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.
  
  

10%

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

10%

Assists 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.
  
  

10%

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

MQs, KSA, License/Certifications

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.
  
  

Registration, Certification Or Licensure

• Possess a valid Texas driver’s license, if applicable
• Additional certifications may be required to be registered, certified, or licensed in a specialty area.
  
  

Physical Requirements/Supplemental Information

PHYSICAL REQUIREMENTS AND/OR WORKING CONDITIONS:

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.

Military Occupational Specialist (mos) Code

Veterans, Reservists or Guardsmen with an MOS or additional duties pertaining to the minimum experience requirements may meet the minimum qualifications for this position and are highly encouraged to apply:

For more information see the Texas State Auditor’s Military Crosswalk at

https://hr.sao.texas.gov/CompensationSystem/JobDescriptions

Supplemental Information

• The Texas Alcoholic Beverage Commission reserves the right to adjust compensation based upon legislative mandates in regard to TABC's and/or an employee's contribution to the?Employees Retirement System. In compliance with Senate Bill 321, agencies that hire a person who has retired from the Employees Retirement System (ERS) or the Law Enforcement and Custodial Officers Supplemental Fund (LECOS) on or after September 1, 2009, are required to remit a surcharge each month the return-to-work retiree is employed. Candidates meeting these requirements will be offered a lower base salary to cover the surcharge.
• The Commission will conduct a criminal history and driver record check with the Texas Department of Public Safety in accordance with applicable standards on all finalists for this position.
• More than one position may be filled from this posting.
• Applicants should clearly describe on their applications how they meet the minimum qualifications for the position. Qualifications may be verified through testing. Resumes will not be accepted in lieu of the completed application. Incomplete applications may not be considered.
• The Immigration Reform and Control Act of 1986requiresall new employees to present proof of eligibility to work in the United States within three (3) days of being hired. The Texas Alcoholic Beverage Commissionparticipatesin E-Verify and will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee's Form I-9 to confirm work authorization; For more information, see: https://www.e-verify.gov/about-e-verify/what-is-e-verify
• Males between the ages of 18 and 25 years, inclusive, may be required to furnish proof of either selective service registration or exemption there from as a condition of state employment. The Texas Alcoholic Beverage Commission adheres to the Veteran's Preference granted in Chapter 657 of the Texas Government Code and the Former Foster Children Preference granted in Chapter 672 of Section 1, Subtitle B, and Title 6 of the Texas Government Code.