Staff Data Engineer

Job not on LinkedIn

🔥 0 minutes ago

Apply Now
Find Similar Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Logo of Apptegy

Apptegy

201 - 500 employees

Founded 2013

📚 Education

☁️ SaaS

💰 $13.2M Venture Round - Apptegy on 2019-03

Education • SaaS

Apptegy is an all-in-one communications platform for K–12 school districts that centralizes and streamlines district and school communications. The platform provides a content management system and drag-and-drop website builder, district-branded mobile apps, mass notifications and alerts, secure two-way messaging, automated translation, newsletters and social publishing, ADA compliance tools, and hands-on client support and training. Apptegy emphasizes brand consistency, community engagement, and thought leadership (SchoolCEO content) to help districts build trust and connect with families; the company states over 5,273 districts use its platform.

📋 Description

• Design, build, and own high-impact data pipelines and platform primitives across ingestion, storage, transformation, and consumption, with Snowflake as the core platform • Build and evolve the medallion architecture across Bronze, Silver, Gold, and Semantic layers • Ship semantic models for key business entities, metrics, and KPIs in Snowflake and expose them to BI tools • Lead engineering execution across Fivetran ingestion, Coalesce and related transformation tooling, and Tableau BI delivery • Resolve Snowflake performance, scalability, and cost issues through query optimization, clustering, warehouse sizing, and storage management • Build AI-ready platform capabilities supporting LLM, RAG, and AI agent use cases • Implement and enforce data governance, including naming conventions, data contracts, PII handling, access controls, lineage, and documentation • Build data observability practices covering freshness monitoring, anomaly detection, pipeline reliability, SLA tracking, and incident response • Partner with security and stakeholders on compliance, risk, and regulatory requirements • Maintain technical documentation, data flow diagrams, decision records, and data dictionaries • Drive design reviews, resolve technical ambiguity, and set engineering standards • Evaluate tools and platforms and lead build-versus-buy decisions • Partner with the VP of Data & Analytics on roadmap execution, prioritization, and platform partnerships • Mentor Data Engineers and Analytics Engineers through pairing, code review, and hands-on support • Communicate technical direction to engineering leaders, business stakeholders, and executive partners • Collaborate cross-functionally to turn data requirements into scalable pipelines and data products • Define data contracts and durable product data integration patterns with engineering • Work with BI and analytics consumers to enable self-service and consistency • Collaborate with Data Scientists and AI/ML Engineers to deliver contextualized, AI-ready data

🎯 Requirements

• 8+ years of experience in data engineering, analytics engineering, or platform engineering, with production data infrastructure experience at Staff or Principal level • Expert-level Snowflake proficiency, including schema design, performance tuning, virtual warehouse management, RBAC, data sharing, and cost governance • Deep hands-on experience with modern data transformation practices and production Coalesce or equivalent dbt experience • Strong data modeling fundamentals, including dimensional modeling, normalization, entity-relationship design, and semantic layer concepts • Demonstrated experience building and operating medallion or layered architecture at scale across multiple business domains • Production experience with data governance, including access controls, PII classification, lineage, documentation, and data contracts • Experience building or operating data observability practices, including freshness monitoring, anomaly detection, SLA definition, and incident response • Expert-level SQL across analytical workloads, including complex query review and optimization • Excellent written and verbal communication, including technical designs, decision records, and presentations to non-technical leadership • Working understanding of enterprise AI application patterns, including RAG pipelines, vector search, and agent frameworks • Familiarity with AI/ML workflows, semantic context, retrieval patterns, and governed access to reliable enterprise data • Standout: inbound and outbound connectors; Tableau BI consumption; SaaS business experience; Snowflake Cortex or related AI features; unstructured data and embedding-based retrieval; tooling evaluations or vendor selection

🏖️ Benefits

• Comprehensive medical, dental, vision, and life insurance coverage • Retirement 401(k) with employer match • Health Savings Accounts (HSA) and Flexible Spending Accounts (FSAs) • Mental Health Reimbursement • Unlimited paid time off, including seasonal (December) company-wide time off • Paid parental and medical leave • Private medical insurance for you and your dependents • Life insurance • 15 days Aguinaldo • Vales de Despensa • Fondo de Ahorro • Caja de Ahorro • Flexible paid time off policy • Paid travel to/from Little Rock, Arkansas for onboarding

Apply Now