IT Architect (Data & Snowflake) (Hybrid)

We’re hiring an IT Architect (Data & Snowflake) to join our team in Richmond, VA. This role offers a hybrid schedule, with onsite work required 1 week in the office and 1 week out., * Serve as the technical authority for ETL and data engineering architecture

• Review pipeline designs, code standards, and performance benchmarks
• Mentor and guide data engineers on best practices and modern data engineering patterns
• Partner with stakeholders to translate business data requirements into scalable technical solutions
• Lead complex data engineering initiatives in enterprise environments
• Design and own end-to-end ETL/ELT architectures for batch and incremental data processing
• Define patterns for data ingestion from Oracle Exadata and other source systems into cloud platforms
• Architect high-volume, high-throughput pipelines supporting structured and semi-structured data
• Continuously evaluate and improve data infrastructure and workflows
• Establish standards for data transformation logic, schema evolution, error handling and reprocessing, and performance tuning
• Define best practices for metadata management, parameterization and reusability, and pipeline deployment and versioning
• Architect end-to-end data pipelines (batch, streaming, real time) to support enterprise analytics, BI, and data products
• Define architectural standards, including database design, warehouse sizing, multi-cluster strategies, RBAC, and performance optimization
• Create and maintain enterprise semantic models, curated datasets, and reusable data assets to enable self-service analytics
• Develop architecture patterns for AI/ML feature pipelines, analytical sandboxes, and model scoring in Snowflake
• Establish data engineering, modeling, and transformation standards across the analytics ecosystem
• Implement DevOps/DataOps practices-CI/CD pipelines, automated testing, data quality checks, and observability across data pipelines
• Partner with Data Governance to define standards for data quality, lineage, metadata management, and cataloging
• Implement Snowflake security, access controls, auditing, and cost management practices

• 7 years in data architecture, data engineering, or enterprise data platform roles
• MUST have hands-on advanced experience with Snowflake, Oracle Exadata, including performance tuning, RBAC, resource management, and advanced Snowflake features (streams, tasks, data sharing)
• MUST have strong proficiency with SQL, ELT/ETL frameworks, and cloud data services (Azure/AWS)
• Must have expertise designing analytical data models (star/snowflake schemas, data vault, semantic layers)
• Experience building scalable data pipelines using tools like dbt, Airflow, ADF, Databricks, Informatica, Talend or similar
• Strong expertise in:
• Batch and incremental data processing
• ELT patterns and push down processing
• Performance tuning of large ETL workloads
• Proven experience with data quality, data observability, and pipeline monitoring, * High School Diploma or Equivalency

We offer a generous array of benefits, depending on the length of assignment. We also offer a referral bonus of up to $1,000. Ask us for more details!