Senior Snowflake Cloud Data Architect — Platform Lead

Levi, Ray & Shoup, Inc.; Washington (District of Columbia); Hybrid; USD 175,000 - 225,000; Full time

Job summary

LRS Consulting Services seeks a Cloud Data Architect (Snowflake) SME in Washington, DC. This hybrid, direct-hire role leads enterprise Snowflake initiatives, shaping analytics platforms and governance across critical data environments.

Responsibilities include designing Snowflake architectures, modeling data and warehouses, ensuring security, cost controls, and interoperability with data catalog, BI, and workflow tools.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field, or equivalent professional experience.
• 8+ years of experience in data architecture, cloud data engineering, analytics, or data platform implementation.
• 4+ years of hands-on experience designing, implementing, and supporting Snowflake or comparable cloud data platforms.
• Expert knowledge of Snowflake architecture, warehouse design, data modeling, security controls, performance optimization, and cost management.
• Strong understanding of ELT/ETL architectures, data pipelines, APIs, structured and semi-structured data, and data quality management.
• Experience supporting enterprise data integration, governance, analytics, and reporting environments within complex organizations.
• Experience designing scalable cloud-based data architectures that align with operational, governance, and business requirements.
• Strong understanding of role-based access controls, identity integration, logging, monitoring, auditing, and secure data sharing practices.
• Experience developing architecture standards, implementation patterns, and governance frameworks that support long-term platform adoption and sustainability.
• Ability to communicate technical concepts and architecture decisions effectively to both technical and non-technical stakeholders.
• Strong documentation skills, including architecture diagrams, design decisions, interface specifications, and operational procedures.
• Ability to obtain a Public Trust Clearance.
• Ability to communicate effectively in English, both written and verbal.

Responsibilities

• Design and implement Snowflake architecture patterns that support analytics, reporting, governance, security, performance, and operational sustainability.
• Develop target-state data architectures, enterprise data models, schemas, warehouse structures, integration patterns, and data flows.
• Serve as the technical authority for Snowflake-based data architecture across the organization.
• Define and implement standards for data ingestion, transformation, storage, metadata management, lifecycle management, data sharing, and access controls.
• Support enterprise data integration initiatives and promote scalable and governed data access across business and mission systems.
• Guide the integration of Snowflake with data catalog, visualization, workflow, identity management, and enterprise platform ecosystems.
• Optimize platform performance through workload isolation, warehouse sizing, query tuning, monitoring, and cost management strategies.
• Collaborate with governance, cybersecurity, infrastructure, application, and analytics teams to ensure solutions align with security and compliance requirements.
• Establish architecture standards, implementation guidance, and operational procedures that can be effectively adopted by engineering and support teams.
• Create and maintain architecture diagrams, interface specifications, design documentation, operational runbooks, and technical standards.
• Provide technical mentorship and architectural leadership across data platform initiatives.

Skills

Snowflake architecture

Data modeling

Security controls

ELT/ETL

Data pipelines

Cloud data platforms

Cost management

RBAC

Data governance

Communication

Education

Bachelor's degree or equivalent

Tools

dbt

Fivetran

Matillion

Informatica

Airflow

Azure

AWS

GCP

Job description

LRS Consulting Services seeks a Cloud Data Architect (Snowflake) SME in Washington, DC. This hybrid, direct-hire role leads enterprise Snowflake initiatives, shaping analytics platforms and governance across critical data environments.

Responsibilities include designing Snowflake architectures, modeling data and warehouses, ensuring security, cost controls, and interoperability with data catalog, BI, and workflow tools.