Database Architect

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 modeling for both 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 is helpful but not required

What Success Looks Like in This Role

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

Schedule: Night Shift

Setup: Remote

Why Join STAFFVIRTUAL?

• Competitive compensation and benefits package

  • HMO Day 1 + FREE dependent coverage

  • Allowances

  • Attendance bonus

  • Paid time offs

• Company-provided work setup (laptop, monitor, accessories)

• Training, career growth, and global exposure

• A collaborative and supportive team culture

If you're a motivated, client-focused professional who's ready to grow with a company that values people and performance, we’d love to hear from you. Apply now and join our dynamic team at STAFFVIRTUAL!