TAHC - Data Analyst V, Branding

Your Skills. Our Mission. Stronger Together at TAHC!

Start your career at the Texas Animal Health Commission as we work together to protect the livestock industry. Whether you’re looking to begin your career, apply your current skills and experience, or explore opportunities to innovate, we encourage you to apply! At TAHC, we promote a culture of teamwork, open communication, transparency, and a commitment to educating the public while safeguarding Texas livestock. Join us and make a difference—because protecting Texas agriculture starts with you!

General Description:  

Performs highly complex (senior-level) data analysis and data research work reporting to the Director of IT/Chief Data Officer. Work involves transforming complex business processes and activities into technical data and information architecture models, diagrams, and documents used in support of information delivery for governed data (i.e. statewide electronic livestock brand registration system).  Performs data analysis and data architecture work involving data modeling; implementing and managing database systems, data warehouses, and data analytics; and designing strategies and setting standards for operations, programming, and security. Works under limited supervision, with moderate latitude for the use of initiative and independent judgment.

Essential Duties:  

• Provides guidelines to create a sustainable information architecture model for TAHC for governed data across multiple departments.
• Provides guidelines to create various standards as they relate to governed data (which includes metadata, master data, reference data, etc.)
• Works with TAHC Project Manager on development, implementation, and maintenance of a new statewide electronic livestock brand registration system housed at TAHC and other projects as needed.
• Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems.
• Obtains data model requirements, develops, and implements data models for new projects, and maintains existing data models and data architectures.
• Develops data structures for data warehouses and data mart projects and initiatives; and supports data analytics and business intelligence systems.
• Implements corresponding database changes to support new and modified applications and ensures that new designs conform to data standards and guidelines; are consistent, normalized, and perform as required; and are secure from unauthorized access or update.
• Reviews changes to technical and business metadata, realizing their impacts on enterprise applications, and ensures that the impacts are communicated to appropriate parties.
• Establishes measures to chart progress related to the completeness and quality of metadata for enterprise information; to support reduction of data redundancy and fragmentation and elimination of unnecessary movement of data; and to improve data quality. 
• Assists with identifying appropriate data sourcing and extraction processes, identify, and nominate sources as systems of record for data usage in various applications across all departments.
• Assists with performing root cause analyses related to information issues and non-conformance to published data standards based on review of technical metadata of various source systems.
• Drives selection of data management tools, and the development of standards, usage guidelines and procedures for those tools.  
• Performs other duties as assigned.

Minimum Qualifications: 

• Bachelor's degree from an accredited college or university in the following field (or closely related) data science, business analytics, computer science, computer information or management information systems, accounting, finance, mathematics, statistics, economics.
• 5 years of full-time experience working in the following fields: data science, business analytics, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, compilation, and/or reporting work.
• 4+ years of experience either with Enterprise Data Architecture or Information Architecture.

Experience may substitute for education on a year per year basis.  

Preferred Qualifications:

• Experience dealing with animal health regulatory processes; for example: permitting, inspection, and/or disease tracing.
• Experience with test planning and implementation strategies, particularly user acceptance testing.
• Proven ability to lead change and design more efficient processes.
• Advanced SQL proficiency (SQL Server and/or Oracle) for profiling, validation, and reconciliation; fluency with ERD/relational modeling, normalization, keys, and indexing.
• Experience Document Management System (e.g., SharePoint/Confluence/Azure DevOps).
• Experience in Power BI/SSRS (semantic modeling concepts, DAX basics, report validation) and Snowflake or Azure analytics services.
• Experience with process improvement methods and change management for data-centric projects.
• Scripting for analysis/automation (e.g., Python or PowerShell) and experience with data catalog/lineage tools.

Knowledge, Skills and Abilities:  Knowledge of statistics and analyzing data sets; running queries, report writing, and presenting findings; and record keeping, including security procedures for handling, protecting, and distributing confidential data; understanding of animal healthcare business processes; understanding of Master Data, Metadata, Reference Data, Data Warehousing and BI principles and processes, including technical architectures for the same; enterprise “information” tools like Informatica, Oracle, Tableau, MicroStrategy, BusinessObjects, SAP, etc.; CRM third party software systems. Skill in the use of a computer and applicable software, in conducting data searches, in evaluating and translating large amounts of data; handling multiple tasks, prioritizing, and meeting deadlines; effective oral and written communication; exercising sound judgment and effective decision making; use of a computer and applicable software, in conducting data searches, in evaluating and translating large amounts of data; defining, developing, and implementing data and reporting standards. Ability to compile, review, and analyze data; to prepare reports; to maintain accuracy and attention to detail; and to communicate effectively; select data management tools and develop standards, usage guidelines, and procedures for those tools; identify and interpret data patterns and trends and assess data quality; communicate well with various levels of each business group.  

IMPORTANT: The TAHC is an emergency response agency. This position plays a key role in the agency’s emergency management activities.  As a first responder, this position is subject to participate in rotating temporary duty assignments away from the regular designated headquarters for up to two weeks at a time.  This duty may involve working in adverse conditions; may require irregular working hours and overtime; and may include duties other than those specified in the standard position description.

Other Requirements: Ability to work more than 40 hours as needed and in compliance with the FLSA. Ability to lift and relocate 30 lbs. Ability to travel (including overnight travel) up to 5%.

Must have a valid Texas driver’s license and safe driving record. Employment of selected candidate is contingent upon the receipt of an acceptable criminal background check and an acceptable moving violation record from the Texas Department of Public Safety. Must have reliable transportation.  Mileage reimbursed at current allowance rate.  

At time of hire, selected applicants must show proof of eligibility to work in the U.S. in compliance with the Immigration Reform and Control Act. Proof of eligibility to work in the U.S. will be confirmed using E-Verify. All males who are age 18 through 25 and required to register with the Selective Service must present proof of registration or exemption from registration upon hire.

How to Apply: To submit your application for employment, select Apply Online. Create and/or Login to your on- line applicant profile and electronically submit your State of Texas Application for Employment.  All applications must contain complete job history (job title, dates of employment, name of employer, supervisor's name and phone number and a description of duties performed). If this information is not submitted, your application may be rejected because it is incomplete. Resumes do not take the place of this required information.  

Veterans, Reservist or Guardsmen with an MOS or additional duties that fall in the fields related to the minimum requirements may meet the minimum qualifications for this position and are highly encouraged to apply. Additional Military Crosswalk information can be accessed at: Texas State Auditor's Office - Job Descriptions  

An Equal Opportunity Employer

The Texas Animal Health Commission is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, national origin, age, sexual orientation or disability in employment or in the provision of services.  In compliance with the Americans with Disabilities Act, any requests for reasonable accommodation needed during the application process should be communicated by the applicant to our Human Resources Department (512) 719-0700. For a telecommunications relay service for the hearing impaired, please dial 711.