Staff VirtualData

Database Architect

RemotePosted today

A mission-driven organization providing safety, compliance, and risk management solutions for the agricultural industry, seeking a Database Architect to design, manage, and optimize data architecture and warehousing.

Location: Remote

Responsibilities

Design and maintain database schemas aligned to business workflows and product requirements
Define standards for data modeling, naming conventions, and structure across systems
Ensure consistency between transactional systems and analytics platforms
Review and approve schema changes to maintain integrity and scalability
Design and manage data models within Snowflake or similar platforms
Define data pipelines and structures to support reporting and analytics
Ensure data is structured for efficient querying and business intelligence use
Partner with stakeholders to support reporting, dashboards, and data access needs
Monitor and optimize performance across application databases and data warehouse environments
Improve query performance, indexing strategies, and data access patterns
Identify and resolve bottlenecks across transactional and analytical workloads
Ensure systems operate efficiently under expected load and growth
Ensure accuracy, consistency, and reliability of data across systems
Define rules for data validation, relationships, and constraints
Implement governance practices for data quality, lineage, and usage
Establish standards for managing schema changes and data access
Design systems to support growth in data volume and system usage
Define strategies for partitioning, replication, and scaling
Ensure high availability and disaster recovery planning
Support backup, restore, and failover processes
Partner with Engineering to align database design with application architecture
Work with Product and Business Analysts to translate workflows into data models
Support analytics and reporting teams with well-structured data models
Provide guidance on data-related decisions across teams
Define and enforce database and data platform standards across the organization
Guide teams on proper data access, modeling, and performance practices
Review implementations to ensure alignment with architecture standards
Continuously improve how data is structured and used across systems
Maintain clear documentation of schemas, data models, and data flows
Ensure data structures are understandable and accessible across teams
Track changes to database and warehouse structures over time
Provide visibility into data health, performance, and risks

Requirements

5–10 years of experience in database architecture, data engineering, or related roles
Strong experience with relational databases (SQL Server, PostgreSQL, or similar)
Experience designing and working with Snowflake or similar data warehouse platforms
Deep understanding of data modeling for both transactional and analytical systems
Experience optimizing database and warehouse performance
Strong problem-solving skills and attention to detail