Job Description
Database Architect
Department: Operations
Employment Type: Full Time
Location: Austin, Texas
Reporting To: Mark Ziller
Compensation: $130,000 - $150,000 / year
Description
Remote -residing in Austin, TX preferred, but not required.
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.
- Build a modern, cloud-native data platform from the ground up
- Influence enterprise-wide architecture decisions
- Work on meaningful healthcare-adjacent data challenges
- Drive analytics that directly impact patient care and operational excellence
- Join a high-growth organization with strong executive visibility
- Remote-first culture with flexibility and autonomy
- Opportunity to grow into a Data Engineering or Data Platform leadership role
What You'll Do
- 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
Required Qualifications
- 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
- You are deeply technical and enjoy building systems yourself
- You think architecturally and understand downstream data impacts
- You thrive in high-autonomy, remote-first environments
- You communicate effectively with both technical and non-technical stakeholders
- You balance speed, scalability, reliability, and maintainability
- 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
Benefits
- Competitive base salary
- Comprehensive health benefits
- Paid time off
- Remote work flexibility
- Career growth opportunities
- Collaborative and mission-driven culture
