Data Engineer - Snowflake Job at Apptad Inc, Washington DC

bTV3cFJxWlFUVmNOajdyQk9POEQvaWhJ
  • Apptad Inc
  • Washington DC

Job Description

Snowflake Data Engineer Bellevue, WA

Responsibilities

  • Design and develop Snowflake Semantic Views for telecom network domains, including logical tables, facts, dimensions, relationships, and metrics.
  • Translate raw network counters into standardized KPIs aligned with 3GPP measurement definitions .
  • Build time-series models supporting 5-minute, 15-minute, hourly, and daily granularities.
  • Implement correct aggregation logic for additive, semi-additive, and ratio-based KPIs.
  • Develop conformed dimensions for network elements, node types, vendors, regions/sites, time, services, and network slices .
  • Maintain semantic metadata including synonyms, descriptions, metric definitions, and sample questions for Cortex Analyst.
  • Collaborate with Data Engineering teams on Kafka, Snowpipe Streaming, Snowflake Kafka Connector, Openflow, Dynamic Tables, Streams, and Tasks .
  • Implement automated schema drift, data drift, and KPI formula-change detection .
  • Establish data contracts, versioning, change-management, and backward-compatibility standards.
  • Monitor data freshness, latency SLAs, and near-real-time data availability .
  • Manage semantic definitions as code and implement CI/CD pipelines across environments.
  • Develop automated tests for KPI formulas, data quality, row counts, nulls, thresholds, anomalies, and regression validation.
  • Maintain a KPI catalog and business glossary covering definitions, formulas, source counters, ownership, and change history.
  • Optimize Snowflake performance and cost through clustering, warehouse sizing, materialization, and query optimization .
  • Work closely with Data Engineering, BI, and Analytics teams using Power BI, Tableau, and other platforms.
  • Act as the technical SME for metric definitions and resolve KPI discrepancies across teams.

Required Skills

  • Strong hands-on experience with Snowflake and Advanced SQL .
  • Experience with Snowflake Semantic Views and/or Cortex Analyst semantic models .
  • Strong experience with Dynamic Tables, Streams & Tasks, Snowpipe/Snowpipe Streaming .
  • Experience building Semantic Layers / Metrics Layers using technologies such as:
    • Snowflake Semantic Views
    • dbt Semantic Layer / MetricFlow
    • AtScale
    • LookML
    • Power BI Semantic Models
  • Strong knowledge of Kimball dimensional modeling, star schemas, facts, and dimensions .
  • Experience working with high-volume time-series data .
  • Telecom domain knowledge, particularly network performance counters and KPIs , is strongly preferred.
  • Understanding of 3GPP measurement definitions is a plus.
  • Strong understanding of Kafka and streaming concepts , including topics, partitions, event time, processing time, late/out-of-order data, and exactly-once semantics.
  • Experience with Python and/or Snowpark .
  • Experience with CI/CD, automated testing, data quality, and monitoring .
  • Strong analytical and communication skills.

Job Tags

Hourly pay

Similar Jobs

Romeo's Pizza

Assistant General Manager Job at Romeo's Pizza

 ...Romeos Pizza Assistant General Manager Positions Available! At Romeos Pizza, were not just a pizza company, were an Award Winning, Food First, Pizza Community that is dedicated to being local pizza champions that positively impact the communities that we serve... 

Toppers Pizza - Winona WIN

Delivery Drivers Job at Toppers Pizza - Winona WIN

 ...People are the heart and soul of our company, bringing Great Food and Memorable Experiences that friends and families connect over...  ...Opportunities * FUN Atmosphere Prior experience as a delivery driver, messenger service, doordash, grubhub, uber driver, lyft driver... 

Wiser

Mid-Level Identity Intelligence (I2) Analyst (Biometrics) - TS/SCI Job at Wiser

Mid-Level Identity Intelligence (I2) Analyst - TS/SCIQuantico, VATS/SCI Security ClearanceWiser offers innovative solutions to clients in the public, private, and government sectors. We combine technology and expertise to develop inventive solutions that deliver quality... 

PatchitUP of North Dallas

Drywall Repair Technician Associate Job at PatchitUP of North Dallas

 ...and attention to detail? If so, we're looking for a dedicated Drywall Repair Technician Helper to join our team!Company:Join our...  ...Drywall Repair Technician in all aspects of drywall repair and installation.* Prepare surfaces for repair by cleaning, sanding, and... 

HT Executive Search

RN Hospice Executive Director Job at HT Executive Search

 ...clinical knowledge in hospice/palliative care, with the ability to provide hands-on support as needed Experience with Homecare Homebase (HCHB) or similar EMR systems preferred Excellent interpersonal, communication, and organizational skills Proven ability to...