Solutions Architect

Dominion Energy • Richmond, VA

1d • $116,300 - $165,000 • Hybrid

About The Position

The IT Architect – Data & Snowflake is a strategic technical leader within the Enterprise Data & Analytics team, responsible for defining the architecture, standards, best practices, and future direction of the organization's data platform. This role provides architectural leadership for enterprise data solutions, ensuring scalable, secure, and high-performing data ecosystems that support analytics, business intelligence, AI/ML initiatives, and data-driven decision-making. The architect is responsible for governing Snowflake usage across the enterprise, designing robust data models, and establishing frameworks that promote data quality, security, scalability, and cost optimization. This role plays a critical part in enabling self-service analytics, operational reporting, and advanced analytical capabilities across the organization. We are seeking a hands-on Data Architect with deep expertise in Data Engineering, ETL/ELT processes, and modern cloud data platforms. The ideal candidate will design, build, and optimize large-scale data ingestion, transformation, and delivery solutions that support enterprise reporting, analytics, and AI/ML use cases. This individual will lead the architecture and implementation of end-to-end data engineering solutions across both on-premises and cloud environments. They will drive data integration strategy, establish best practices for data quality and governance, and ensure operational excellence through monitoring, observability, and performance optimization. The successful candidate will combine strategic architectural vision with strong technical execution to deliver reliable, scalable, and future-ready data solutions.

Requirements

• Minimum 7+ years of experience in Data Architecture, Data Engineering, or Enterprise Data Platform roles.
• Advanced hands-on experience with Snowflake and Oracle Exadata, including: Performance tuning, Role-Based Access Control (RBAC), Resource management, Advanced Snowflake features (Streams, Tasks, Data Sharing)
• Strong proficiency in SQL, ELT/ETL frameworks, and cloud data services (Azure and/or AWS).
• Proven expertise in designing analytical data models, including: Star Schemas, Snowflake Schemas, Data Vault, Semantic Layers
• Experience building scalable data pipelines using tools such as: dbt, Apache Airflow, Azure Data Factory (ADF), Databricks, Informatica, Talend or similar technologies
• Experience using Dataiku for analytics and machine learning pipeline enablement.
• 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.
• Strong communication skills both verbal and written.
• Ability to lead, collaborate, or work effectively in a variety of teams, including multi-disciplinary teams.

Nice To Haves

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

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.
• Ability to 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.

Benefits

• health, dental, and vision benefits with coverage for families and domestic partners
• vacation
• retirement plans including 401k contributions and matches
• paid holidays
• tuition reimbursement
• bonus eligibility
• sick leave
• disability insurance

What This Job Offers

• Job Type: Full-time
• Career Level: Senior