Capps Plumbing and Sewer, Inc. · 20 hours ago
TAHC - Data Analyst V, Branding
Texas-AustinWork Locations
Full-time
Onsite
Senior Level
5+ years expCapps Plumbing and Sewer, Inc. is part of the Texas Animal Health Commission, dedicated to protecting the livestock industry. They are seeking a Senior Data Analyst who will perform complex data analysis and architecture work to support information delivery for governed data, including the statewide electronic livestock brand registration system.
CommercialCustomer ServiceProperty ManagementResidential
No H1B
Responsibilities
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
Qualification
Required
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
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
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
Preferred
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
Benefits
Mileage reimbursed at current allowance rate.
Company
Capps Plumbing and Sewer, Inc.
Capps Plumbing and Sewer is a family-owned and operated plumbing business serving Chicago's north and northwest suburbs for 30 years.
11-50 employees
Funding
Current Stage
Early StageLeadership Team
Joe Capps
Owner and Co-Founder
Recent News
Company data provided by crunchbase