Cloud Data Architect (Snowflake), SME

Koniag Government Services; Washington (District of Columbia); Hybrid; USD 130,000 - 180,000; Full time

Job summary

Koniag Government Services is seeking a Cloud Data Architect (Snowflake), SME to lead Snowflake architecture and data integration for federal customers in the Washington, DC area. The role requires translating complex data requirements into scalable, governed cloud data solutions and providing senior technical leadership.

The candidate will design, optimize, and secure data pipelines, collaborate with governance and cybersecurity teams, and produce operational runbooks and design decisions for

Qualifications

• 8+ years of experience in data architecture, cloud data engineering, analytics, or data platform implementations.
• 4+ years of hands-on Snowflake or comparable cloud data platform design/implementation.
• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Data Analytics, or related field, or equivalent work experience.

Responsibilities

• Design and implement Snowflake architecture patterns for data integration, analytics, governance, performance, security, and operational sustainment.
• Develop target-state data models, schemas, warehouse structures, and integration patterns for enterprise data sources.
• Guide Snowflake integration with data catalog, BI, identity, security, and workflow platforms across the Digital Workplace.
• Establish technical standards for ingestion, transformation, storage, access control, data sharing, and metadata capture.
• Support performance tuning, cost optimization, workload isolation, warehouse sizing, and platform monitoring.
• Collaborate with governance, cybersecurity, infrastructure, and application teams to meet federal security and compliance expectations.
• Produce architecture diagrams, implementation guidance, data interface specs, design decisions, and runbooks.

Skills

Snowflake architecture

Data modeling

ETL/ELT patterns

Security controls

Data governance

Cloud services

Communication

Education

Bachelor's degree

Tools

dbt

Fivetran

Matillion

Informatica

Airflow

Job description

Koniag Advisory and Business Solutions, LLC a Koniag Government Services company, is seeking a Cloud Data Architect (Snowflake), SME to support KABS and our government customer in Washington, DC. The position is hybrid, requires 1 day onsite. This position requires the candidate to be able to obtain a Public Trust.

Benefits include medical, dental, and vision insurance, 401(k) retirement plan, paid time off, paid parental leave, life and disability insurance, flexible spending accounts, commuter benefits and tuition reimbursement.

Koniag Advisory and Business Solutions, LLC, a Koniag Government Services company, is seeking a Cloud Data Architect (Snowflake), SME to support the Digital Workplace workforce by designing, integrating, and optimizing enterprise cloud data capabilities. The successful candidate will provide senior technical leadership for Snowflake architecture, data modeling, data pipeline integration, performance optimization, and secure data sharing across mission and business systems. This role requires the ability to translate operational data needs into scalable, governed, and supportable cloud data solutions that improve analytics, reporting, and decision support. Work will be performed at the client's facility or customer approved remote locations during Eastern Time core business hours.

The Cloud Data Architect (Snowflake), SME will serve as the senior technical authority for Snowflake-based data architecture and integration within the Digital Workplace environment.

Principal Responsibilities Will Include But Are Not Limited To

• Design and implement Snowflake architecture patterns that support data integration, analytics, governance, performance, security, and operational sustainment.
• Develop target-state data models, data flows, schemas, warehouse structures, and integration patterns for enterprise and program data sources.
• Guide the integration of Snowflake with data catalog, visualization, identity, security, and workflow platforms used across the Digital Workplace ecosystem.
• Establish technical 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 platform monitoring.
• Collaborate with governance, cybersecurity, infrastructure, and application teams to ensure data solutions align with federal security and compliance expectations.
• Produce architecture diagrams, implementation guidance, data interface specifications, design decisions, and operational runbooks.

Education and Experience

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Data Analytics, or a related discipline, or equivalent work experience.
• 8+ years of experience in data architecture, cloud data engineering, enterprise analytics, or data platform implementation.
• 4+ years of hands-on experience designing or implementing Snowflake or comparable cloud data platform solutions.
• Experience supporting enterprise data integration, governance, and analytics environments in complex stakeholder settings.

Desired

• SnowPro Advanced Architect, SnowPro Core, or comparable cloud data certification.
• Experience supporting federal government data environments, including security, privacy, and compliance controls.
• Experience integrating Snowflake with data catalog, BI, workflow, and enterprise identity platforms.

Required Skills And Competencies

• Expert knowledge of Snowflake architecture, data modeling, warehouse design, security controls, query performance, and cost optimization.
• Strong understanding of ELT/ETL patterns, data pipelines, APIs, structured and semi-structured data, and data quality controls.
• Ability to define practical architecture standards that engineering teams can implement and operations teams can sustain.
• Experience with cloud services, identity integration, role-based access control, logging, monitoring, and secure data sharing.
• Strong written and verbal communication skills with the ability to explain technical data architecture decisions to technical and non-technical stakeholders.
• Ability to obtain a Public Trust clearance.

Desired Skills And Competencies

• Experience with Azure, AWS, or Google Cloud data services used with Snowflake.
• Experience with dbt, Fivetran, Matillion, Informatica, Airflow, or comparable data integration tools.
• Knowledge of data governance, data lineage, metadata management, and master/reference data practices.
• Familiarity with Agile delivery, DevSecOps, infrastructure as code, and automated deployment patterns for data platforms.4

Our Equal Employment Opportunity Policy

The company is an equal opportunity employer. The company shall not discriminate against any employee or applicant because of race, color, religion, creed, ethnicity, sex, sexual orientation, gender or gender identity (except where gender is a bona fide occupational qualification), national origin or ancestry, age, disability, citizenship, military/veteran status, marital status, genetic information or any other characteristic protected by applicable federal, state, or local law. We are committed to equal employment opportunity in all decisions related to employment, promotion, wages, benefits, and all other privileges, terms, and conditions of employment.

The company is dedicated to seeking all qualified applicants.

Koniag Government Services (KGS) is an Alaska Native Owned corporation supporting the values and traditions of our native communities through an agile employee and corporate culture that delivers Enterprise Solutions, Professional Services and Operational Management to Federal Government Agencies. As a wholly owned subsidiary of Koniag, we apply our proven commercial solutions to a deep knowledge of Defense and Civilian missions to provide forward leaning technical, professional, and operational solutions. KGS enables successful mission outcomes for our customers through solution-oriented business partnerships and a commitment to exceptional service delivery. We ensure long-term success with a continuous improvement approach while balancing the collective interests of our customers, employees, and native communities. For more information, please visit www.koniag-gs.com.

Equal Opportunity Employer/Veterans/Disabled. Shareholder Preference in accordance with Public Law 88-352