Senior Snowflake Cloud Architect — Data Modeling

Koniag Services, Inc.; Washington, Northern (District of Columbia, KY); Hybrid; USD 140,000 - 180,000; Full time

Benefits offered by this job

Health, dental, vision insurance

401K with company matching

Flexible spending accounts

Paid holidays

Three weeks paid time off

Job summary

Koniag Advisory and Business Solutions, LLC, a Koniag Government Services company, is seeking a Cloud Data Architect (Snowflake), SME to support the Digital Workplace by designing, integrating, and optimizing enterprise cloud data capabilities.

The successful candidate will provide senior leadership for Snowflake architecture, data modeling, data pipeline integration, performance optimization, and secure data sharing across mission and business systems.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Data Analytics, or equivalent.
• 8+ years of experience in data architecture, cloud data engineering, analytics, or data platform implementations.
• 4+ years designing or implementing Snowflake or comparable cloud data solutions.
• Experience supporting enterprise data integration, governance, and analytics in complex stakeholder settings.
• SnowPro Advanced Architect, SnowPro Core, or comparable cloud data certification.
• Experience with federal government data environments including security and compliance controls.
• Experience integrating Snowflake with data catalog, BI, workflow, and identity platforms.

Responsibilities

• Design and implement Snowflake architecture patterns for data integration, analytics, governance, performance, security, and operational sustainment.
• Develop target-state data models, data flows, schemas, warehouse structures, and integration patterns.
• Guide Snowflake integration with data catalog, visualization, identity, security, and workflow platforms.
• Establish standards for ingestion, transformation, storage, access control, data sharing, metadata capture, and lifecycle management.
• Support performance tuning, cost optimization, workload isolation, warehouse sizing, query optimization, and monitoring.
• Collaborate with governance, cybersecurity, infrastructure, and applications teams to meet federal security/compliance expectations.
• Produce architecture diagrams, implementation guidance, data interface specifications, design decisions, and runbooks.

Skills

Snowflake architecture

Data modeling

Security controls

ETL/ELT patterns

Data pipelines

Data governance

Communication

Public Trust eligibility

Education

SnowPro Advanced Architect / Core certification

Bachelor's degree in Computer Science or related field

Experience with federal government data environments

Tools

dbt

Fivetran

Matillion

Informatica

Airflow

Snowflake

Job description

Koniag Advisory and Business Solutions, LLC, a Koniag Government Services company, is seeking a Cloud Data Architect (Snowflake), SME to support the Digital Workplace by designing, integrating, and optimizing enterprise cloud data capabilities.

The successful candidate will provide senior leadership for Snowflake architecture, data modeling, data pipeline integration, performance optimization, and secure data sharing across mission and business systems.