Data Architect - Snowflake

Solutions Architect – Data & Snowflake
Hybrid: Richmond, VA  23219

$80.00 /hr W2

Required Skills

• Strong hands?on experience with Snowflake and Oracle Exadata, including performance tuning, RBAC, resource management, and advanced Snowflake features (streams, tasks, data sharing).
• Expertise in analytical data modeling (star/snowflake schemas, data vault, semantic layers).
• Proficiency in SQL, ELT/ETL frameworks, and cloud data services (Azure/AWS).
• Experience building scalable pipelines using dbt, Airflow, ADF, Databricks, Informatica, Talend, or similar tools.
• Experience with Dataiku for analytics and ML pipeline enablement.

• Act as the technical authority for data engineering and ETL architecture.
• Review pipeline designs, enforce coding standards, and guide performance optimization.
• Mentor data engineers and translate business requirements into scalable solutions.

• Design end?to?end batch and incremental data processing architectures.
• Define ingestion patterns from Oracle Exadata and other sources into cloud platforms.
• Establish standards for transformation logic, schema evolution, error handling, and performance tuning.

• Architect batch, streaming, and real?time data pipelines for analytics and data products.
• Define Snowflake standards including warehouse sizing, RBAC, multi?cluster strategies, and optimization.
• Build semantic layers, curated datasets, and reusable enterprise data assets.
• Develop patterns for AI/ML feature pipelines and model scoring.

• Establish enterprise standards for modeling, ELT frameworks, versioning, and metadata management.
• Implement DevOps/DataOps practices including CI/CD, automated testing, and data quality checks.
• Oversee Snowflake security, access controls, auditing, and cost management.

• Partner with BI and analytics teams to design governed, scalable analytical models.
• Support predictive analytics, forecasting, segmentation, and personalization use cases.
• Ensure data products align with enterprise standards and business needs.

• Work closely with engineering, analytics, cloud, cybersecurity, and business SMEs.
• Participate in architecture reviews and enterprise data strategy planning.

• Define monitoring, alerting, SLA/SLO management, and resiliency standards.
• Lead root?cause analysis and drive remediation of platform issues.
• Ensure reliability, performance, scalability, and disaster recovery across data pipelines.

• Cloud or platform certifications (Snowflake, Databricks, Azure, Informatica).

• 7+ years in data architecture, data engineering, or enterprise data platform roles.
• High school diploma or equivalent required.

#ZR
#INDGEN