Snowflake Data Platform Architect & Engineer

Openkyber; Alaska; On-site; USD 120,000 - 180,000; Full time

Job summary

Openkyber seeks a Data Engineer to build and operate a modern cloud data platform (Snowflake, dbt, Fivetran) across ingestion, transformation, and delivery layers. You will modernize legacy SQL Server/SSIS/SSAS workloads into scalable cloud pipelines with automation, data lineage, and reporting readiness.

You will design and optimize Snowflake databases, implement cloud ingestion, and collaborate with analytics teams to deliver trusted analytics-ready data for Sigma BI and other tools, while

Qualifications

• Strong hands-on Snowflake in enterprise environments.
• Deep knowledge of SQL, query optimization, performance tuning, and warehouse design.
• Experience migrating from legacy EDW platforms such as SQL Server, SSIS, and SSAS.
• Exp. with dbt, Fivetran, AWS, and Sigma BI/reporting integrations.
• Hands-on experience with Fivetran or comparable cloud ingestion tools.
• Strong AWS fundamentals: S3, IAM, KMS, VPC, PrivateLink for Snowflake connectivity.
• Strong understanding of source-to-target mapping, CDC concepts, and incremental loading.
• NICE TO HAVE Snowflake SnowPro Core or Advanced: Data Engineer certification; cost optimization exp.

Responsibilities

• Design, configure, and maintain the Snowflake platform, including databases, schemas, warehouses, roles, security policies, and environment setup.
• Implement and manage cloud-based ingestion using Fivetran for legacy, operational, and SaaS source systems.
• Build and optimize the target data architecture across raw, staging, curated, and reporting-ready layers.
• Develop, test, and maintain dbt models that replace legacy SSIS transformation logic.
• Translate legacy constructs into modern Snowflake and dbt implementations.
• Configure AWS integrations required for the data platform, including S3 stages, IAM roles, and storage integrations.
• Establish and support source-to-target mappings and metadata lineage.
• Implement automated data quality checks and reconciliation controls.
• Monitor ingestion pipelines, troubleshoot failures, and optimize Snowflake performance.
• Support downstream analytics teams by delivering analytics-ready data terrains for Sigma and others.
• Contribute to CI/CD, release automation, and Git-based workflows for dbt and Snowflake.
• Produce runbooks and handover materials for ongoing support.

Skills

Snowflake implementation

SQL optimization

EDW migration

dbt

Fivetran

AWS fundamentals

data governance/lineage

data quality checks

Tools

Snowflake

dbt

Fivetran

Sigma BI

Job description

Openkyber seeks a Data Engineer to build and operate a modern cloud data platform (Snowflake, dbt, Fivetran) across ingestion, transformation, and delivery layers. You will modernize legacy SQL Server/SSIS/SSAS workloads into scalable cloud pipelines with automation, data lineage, and reporting readiness.

You will design and optimize Snowflake databases, implement cloud ingestion, and collaborate with analytics teams to deliver trusted analytics-ready data for Sigma BI and other tools, while