IT Architect (Data & Snowflake)

We're hiring a IT Architect (Data & Snowflake) to join our team in Richmond, VA. This role offers a hybrid schedule, with one week onsite/one week remote.

Skills & Qualifications:

• W-2 only
• 7+ years of total experience in data architecture, data engineering, or enterprise data platform roles
• 5+ years of experience as a data architect
• Strong hands-on experience with Snowflake, Oracle Exadata, including performance tuning, RBAC, resource management, and advanced Snowflake features (streams, tasks, data sharing)
• Expertise designing analytical data models (Star/Snowflake schemas, data vault, semantic layers)
• Proficiency with SQL, ELT/ETL frameworks, and cloud data services (Azure/AWS)
• Experience building scalable data pipelines using tools like dbt, Airflow, ADF, Databricks, Informatica, Talend, or similar
• Experience with Dataiku for analytics and ML pipeline enablement
• 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
• 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
• Establish standards for:
  • Data transformation logic
  • Schema evolution
  • Error handling and reprocessing
  • Performance tuning
• Define best practices for:
  • Metadata management
  • Parameterization and reusability
  • 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 (e.g., naming conventions, ELT frameworks, versioning)
• 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
• Collaborate with BI and analytics teams to design scalable, governed data models supporting dashboards, KPIs, and advanced analytics
• Architect data solutions that support predictive analytics, forecasting, segmentation, and personalization use cases
• Guide development of data products, ensuring they follow enterprise standards and meet business requirements

• Minimum of a high school diploma or equivalency

The hourly rate for this position is $85.19.

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