Cloud Data Architect; Snowflake) SME

Added Sep 22, 2026 Cloud Data Architect (Snowflake) SME (46422) Washington, DC | Permanent Apply

For additional information on how we handle your data, see

If you receive a suspicious offer or communication claiming to be from us, do not share any personal or financial information. You can notify us using our contact page at Contact Levi, Ray & Shoup, Inc .

• All legitimate correspondence from our recruiting team will only come from an email address ending in  We do not use generic domains like , , or
• We never conduct interviews solely via text-based chat on Microsoft Teams, Telegram, or Whats App. All virtual interviews involve a scheduled video or phone call with a member of our team.
• LRS will never ask a candidate for payment, fees, or to purchase equipment (e.g., laptops, software) as a condition of employment.
• All genuine job opportunities are listed directly on our official careers portal at Careers .

LRS Consulting Services is seeking a Cloud Data Architect (Snowflake) SME who is passionate about designing modern cloud data platforms, enabling enterprise analytics, and transforming complex data ecosystems into scalable, governed, and actionable data solutions. This hybrid direct-hire opportunity offers the chance to serve as a technical leader for enterprise Snowflake architecture initiatives supporting critical business and mission-driven data environments.

Location:

Washington, DC (Hybrid - 1 day per week onsite)

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

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Data Analytics, or a related field, or equivalent professional experience.
• 8+ years of experience in data architecture, cloud data engineering, enterprise 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…