Staff Data Architect

🔥 13 minutes ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

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

Upload Resume

Apptegy

WebsiteLinkedInAll Job Openings

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

• Define and evolve the enterprise data architecture across ingestion, storage, transformation, semantic modeling, and consumption layers, with Snowflake as the core platform. • Design and own the medallion architecture across Bronze, Silver, Gold, and Semantic layers, establishing clear standards for schema design, object naming, access patterns, and layer boundaries. • Lead semantic model strategy by defining how key business entities, metrics, and KPIs are represented in Snowflake and surfaced through BI tools. • Drive architectural decisions across the modern data stack, including ingestion through Fivetran, transformation through Coalesce and related conventions, and BI delivery through Tableau. • Identify and resolve performance, scalability, and cost-efficiency challenges in Snowflake, including query optimization, clustering strategy, virtual warehouse sizing, and storage management. • Design the platform to serve as a reliable enterprise context layer for AI by establishing patterns for metadata enrichment, semantic data modeling, contextual retrieval, and curated data products.

🎯 Requirements

• 8+ years of experience in data engineering, analytics engineering, or data architecture roles, with at least 3 years in an architecture-focused capacity. • Expert-level Snowflake proficiency, including schema design, performance tuning, virtual warehouse management, RBAC, data sharing, and cost governance. • Deep experience with modern data transformation practices, including strong design principles and hands-on experience with Coalesce. • Strong data modeling fundamentals, including dimensional modeling, normalization, entity-relationship design, and semantic layer concepts. • Demonstrated ability to design and govern a medallion or layered architecture at scale across multiple business domains. • Experience with data governance, including access controls, PII classification, lineage tracking, documentation standards, and data contract expectations. • Experience designing or implementing a data observability practice, including freshness monitoring, anomaly detection, SLA definition, and incident response for data pipelines. • Strong SQL across analytical workloads, with the ability to review, optimize, and improve complex query patterns. • Excellent communication skills, including the ability to create architecture diagrams, write clear decision records, and present technical direction to non-technical leadership. • Understanding of enterprise AI application patterns, including RAG pipelines, vector search, and agent frameworks.

🏖️ 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.