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.
Skills & Qualifications:
- 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
Key Responsibilities:
- 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
Education/Certifications:
- High School Diploma or Equivalency
The hourly rate for this position is $79.28.
TM Floyd & Company is an equal opportunity employer and values diversity. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability.
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!
TM Floyd & Company participates in E-VERIFY.
AAP, EEO