Database Architect

Overview

We are seeking a Database Architect to design, manage, and optimize both our application data architecture and data warehousing environment. This role is responsible for defining database schemas, ensuring data consistency, and maintaining performance across transactional and analytical systems.

Within our organization, this position plays a key role in ensuring the 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 overall system performance.

This role requires strong technical expertise in relational databases and modern data platforms such as Snowflake.

Key Responsibilities

Data Architecture & Schema Design

• Design and maintain database schemas aligned with 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 optimized 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 application databases and data warehouse environments
• Improve query performance, indexing strategies, and data access patterns
• Identify and resolve bottlenecks in 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 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
• 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 best practices for data access, modeling, and performance
• Review implementations to ensure alignment with architectural 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 modeling for transactional and analytical systems
• Experience optimizing database and warehouse performance
• Strong problem-solving skills and attention to detail

Preferred

• Experience with data pipelines and ETL/ELT processes
• Experience with cloud platforms such as AWS
• Familiarity with data governance, lineage, and auditing practices
• Experience in compliance-driven or regulated environments

Tools & Platforms (Preferred Experience)

• SQL Server, PostgreSQL, or similar relational databases
• Snowflake or similar data warehouse platforms (Redshift, BigQuery)
• AWS RDS, Aurora, or equivalent cloud database services
• Data pipeline or orchestration tools
• Database monitoring and performance tools
• Jira
• Confluence
• Power BI or other BI/reporting platforms
• Collaboration tools such as Zoom and chat platforms
• Familiarity with EOS / Ninety or similar operating frameworks (nice to have)



What Success Looks Like in This Role

• Data architecture effectively supports both application performance and analytics needs
• Snowflake (or equivalent platform) is structured for scalability and efficient reporting
• Data remains consistent and reliable across transactional and reporting systems
• Engineering and analytics teams follow clear and consistent data standards
• Performance issues are proactively identified and resolved
• The data layer scales efficiently without frequent redesign