Database Architect

Innovetive Petcare•Austin, TX

6h•Remote

About The Position

Innovetive Petcare is seeking a highly technical, hands-on Database Architect to design, build, and scale our modern enterprise data platform from the ground up. This is not a pure strategy or oversight role. We are looking for a builder — someone who enjoys writing production-grade code, architecting scalable systems, and solving complex data problems across clinical, operational, and financial domains. As a rapidly growing veterinary services organization, data is central to how we improve patient outcomes, optimize hospital operations, support clinicians, and drive smarter business decisions across our national network of veterinary practices. You will own the architecture and evolution of our end-to-end data ecosystem while partnering directly with leadership and business stakeholders across the organization. This is a remote-first opportunity with a clear growth path into technical leadership as the data organization expands.

Requirements

10+ years of hands-on experience in: Data Engineering, Analytics Engineering, Data Architecture
Proven experience building and operating production-grade data platforms
Experience working with complex, multi-source enterprise datasets
Background supporting operational, financial, healthcare, or clinical data environments preferred
Advanced expertise with: Snowflake, dbt, Tableau, SQL, Python
Experience with: Snowpipe, Streams & Tasks, Incremental modeling strategies, Data warehouse optimization, Semantic layer design
Familiarity with orchestration tools such as: Airflow, Prefect, Dagster
Strong understanding of: Cloud infrastructure (AWS, Azure, or GCP), Git workflows, CI/CD pipelines, Data governance and security best practices

Nice To Haves

Residing in Austin, Texas with easy access to our home office location
Experience in veterinary healthcare, healthcare technology, or other regulated industries
Exposure to healthcare-adjacent compliance and governance environments
Experience building enterprise analytics ecosystems from early-stage or greenfield environments

Responsibilities

Design, build, and maintain a scalable enterprise data platform using Snowflake
Architect ingestion pipelines across clinical, financial, operational, scheduling, and inventory systems
Implement scalable ELT/ETL workflows and data transformation pipelines
Define platform standards for: Data governance, Naming conventions, CI/CD workflows, Environment management (dev/staging/prod), Testing and deployment strategies
Manage Snowflake architecture, RBAC, security, cost optimization, and performance tuning
Own the dbt ecosystem end-to-end
Build scalable dimensional and canonical data models
Develop reliable marts and semantic layers for analytics consumption
Implement robust testing, lineage, and documentation standards
Create reusable transformation logic and framework standards
Partner with finance, operations, and clinical leaders to deliver trusted Tableau dashboards and reporting layers
Build governed, self-service analytics capabilities
Optimize Tableau performance, row-level security, and published data sources
Translate ambiguous business questions into scalable technical solutions
Implement observability and monitoring solutions for: Data freshness, Schema drift, Pipeline failures, Anomaly detection
Establish governance standards for sensitive and healthcare-adjacent data
Improve trust and reliability across enterprise reporting
Serve as a technical standard-bearer for architecture and engineering best practices
Help shape the future structure of the data organization
Mentor future team members as the function grows