Database Architect (Remote)

**Job Title: Database Architect** **About the Client:** A mission-driven organization providing safety, compliance, and risk management solutions for the agricultural industry. They support businesses through training, technology, and consulting services that help ensure regulatory compliance, improve workplace safety, and enhance operational efficiency. **Overview:** We are seeking a Database Architect to design, manage, and optimize both our application data architecture and data warehousing environment. This role will define database schemas, ensure data consistency, and maintain performance across transactional and analytical systems. In our organization, this role plays a key part in ensuring our data layer supports scalable application development and reliable reporting. The Database Architect works closely with Engineering, Product, and leadership to align data design with business workflows, analytics, and system performance. This role requires strong technical expertise across relational databases and modern data platforms such as Snowflake. **Responsibilities**: Data Architecture & Schema Design - 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 Data Warehousing & Analytics Architecture - 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 Database Performance & Optimization - Monitor and optimize performance across both 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 Data Integrity & Governance - 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 Scalability & Reliability - 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 Cross-Functional Collaboration - 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 Standards & Best Practices - 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 Documentation & Visibility - 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 **Qualifications:** Required - 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 m…