Senior Data Engineer

Incident IQ, LLC; United States; Remote; USD 140,000 - 180,000; Full time

Benefits offered by this job

Medical, dental, vision

Life insurance

401k match

PTO

Job summary

Incident IQ, LLC is actively seeking a Senior Data Engineer to lead the design and population of a new BI data warehouse. You will consolidate data from the core SaaS platform and external systems, owning the analytics foundation end-to-end in a greenfield environment.

This role drives data strategy, governance, and scalable pipeline architecture to empower education-focused insights. The ideal candidate has 5–7 years in data engineering or related fields, deep cloud warehousing expertise, and

Qualifications

• 5-7 years of professional experience in Data Engineering or related field.
• Built greenfield data infrastructure end-to-end.
• Deep expertise in modern cloud data warehousing (Snowflake, Databricks, Azure Synapse, or AWS Redshift).
• Experience building ETL/ELT pipelines with dbt, Airflow, or ADF.
• Advanced SQL and query tuning across Azure SQL/SQL Server/PostgreSQL.
• Hands-on experience integrating data from SaaS tools (Salesforce, Gainsight, Marketo).
• Programming in Python, Scala, or C# for data manipulation.

Responsibilities

• Data Warehouse Architecture: design and scale a modern BI warehouse/data lake from the ground up.
• Data Pipeline Engineering: build and maintain automated ETL/ELT pipelines across sources.
• Platform Evaluation: own platform recommendations with cost and performance considerations.
• Data Quality & Governance: enforce data governance and performance optimization.
• Reliability: own data freshness, completeness, and adherence to refresh SLAs.

Skills

5-7 yrs exp

Data warehousing

ETL pipelines

SQL mastery

SaaS integrations

Python/Scala/C#

Tools

dbt

Apache Airflow

Azure Data Factory

Job description

Company Overview:

About Us:
Atlanta-based Incident IQ is the leading workflow management platform built exclusively for K-12 districts. Trusted by over 2,000 districts, Incident IQ powers mission-critical services for more than 12 million students and educators nationwide. By connecting technology and operational workflows, Incident IQ enables schools to streamline processes, reduce administrative burdens, and focus on what matters most: supporting students.

Purpose:
Incident IQ is committed to creating a future where every K-12 district operates with seamless efficiency. When operations are unified on a single platform, districts gain the clarity and control needed to build a stronger foundation for student success. We’re focused on delivering the tools, support, and partnerships that help make that vision a reality.

Mission:
Incident IQ is on a mission to eliminate the friction of disconnected systems and clunky workflows that slow schools down. We’re reimagining the critical work that happens behind the scenes, bringing visibility, efficiency, and impact to the processes that keep classrooms running. By streamlining the complex, automating the routine, and surfacing the insights that matter most, we can create the conditions for educators to teach, students to thrive, and districts to shape the future of education.

Senior Data Engineer Overview:

We are seeking an experienced, hands‑on Senior Data Engineer to lead the design, architecture, and population of our new BI data warehouse. This role is highly cross‑functional and critical to Incident IQ’s next phase of growth. You will be responsible for aggregating complex data streams from our core SaaS platform and third‑party systems into a centralized data warehouse/lake. You will own the analytics foundation end‑to‑end, serving as an architect‑engineer. This is a genuine greenfield seat: the analytics foundation you build becomes how the company and its customers answer their most important questions.

Key Responsibilities

• Data Warehouse Architecture: Design, implement, and scale a modern BI data warehouse/data lake from the ground up. Foundation first — a rudimentary, queryable environment stood up early and built out over time, rather than a spreadsheet‑first interim. You will design at a grain that serves internal analytics today and groundwork for future customer‑facing analytics.
• Data Pipeline Engineering: Build and maintain robust, automated ETL/ELT pipelines to extract and aggregate data from diverse sources, beginning with our Azure-hosted product platform and extending to operational systems (e.g., CRM) and other external APIs as product usage pipelines stabilize.
• Platform Evaluation and Recommendation: Own the written platform recommendation scored on refresh latency, aggregation performance at full volume, schema evolution, tenant isolation, three‑year total cost of ownership, and migration cost. You make the case; selection and purchase are joint decisions with R&D and Finance.
• Data Quality & Governance: Establish and enforce data governance, quality checks, and performance optimization practices to ensure high data integrity and rapid query response times. You will own source‑system semantics and technical implementation.
• Reliability and Continuity: Own freshness, completeness, and reconciliation against a published refresh SLA. Document to the standard that others can run the full cycle unaided.

Qualifications & Experience

• Experience: Minimum of 5-7 years of professional experience in Data Engineering, BI Engineering, Analytics Engineering, or Data Architecture, specifically within a high‑growth SaaS environment.
• 0-to-1 Build Experience: You have owned a greenfield data infrastructure initiative end to end rather than contributed to one. Expect to name it and walk through what you built, what you chose against, and what you would do differently.
• Data Warehousing: Deep expertise in modern cloud data warehousing solutions (e.g., Snowflake, Databricks, Azure Synapse, or AWS Redshift) and data lake architectures.
• Pipeline Development: Proven experience building complex ETL/ELT pipelines using tools like dbt, Apache Airflow, Azure Data Factory, or similar orchestration frameworks.
• Database Mastery: Advanced proficiency in complex SQL and query tuning across relational sources (Azure SQL, SQL Server, PostgreSQL). Experience integrating a non‑relational source such as MongoDB into a relational warehouse is a plus rather than a requirement.
• SaaS Integrations: Hands‑on experience extracting and integrating data from enterprise GTM tools such as Salesforce, Gainsight, Marketo, or similar platforms.
• Programming: Proficiency in languages such as Python, Scala, or C# for data manipulation and automation.

Personality & Soft Skills

• Strategic Builder: You don’t just write scripts; you think holistically about how data architecture drives business outcomes and product differentiation.
• Pragmatic and Cost‑Conscious: You are comfortable standing up something rudimentary that works and improving it, rather than waiting on the ideal platform. You weigh cost against capability and can defend the tradeoff to a non‑technical audience.
• Cross‑Functional Communicator: You can translate complex technical data models into plain business language for stakeholders, and vice versa.
• Autonomous Ownership: You thrive in environments where you can take a high‑level goal, determine the technical path, and execute with minimal hand‑holding.
• Inquisitive Problem Solver: You are naturally curious about how the business operates and how data can be used to uncover hidden efficiencies.
• Collaborative Team Player: Focused on the success of the platform and the company over personal credit.

What This Role Is Not

• Not Just a Dashboard Developer: While reporting is key, this is a heavy data engineering and architecture role. If you prefer to only build visualizations without touching the underlying pipeline and warehouse design, this is not the right fit.
• Not a Maintenance Role: We are building a new data ecosystem from the ground up. This role requires someone who thrives on creating scalable 0‑to‑1 solutions rather than maintaining legacy systems.
• Not an Order Taker: You will be expected to advise leadership on data strategy and best practices, not simply execute assigned tickets.

What makes Incident IQ different:

• We facilitate whole‑person growth where employees can develop personally as well as professionally.
• We offer an energetic and collaborative environment; everyone’s opinion matters!
• We produce software that empowers K‑12 schools to run efficiently, allowing for a better classroom experience for students to THRIVE!
• We provide excellent work/life balance. Two amazing offices - a Downtown Atlanta office location and one at Halcyon in Alpharetta!

Incident IQ offers a competitive salary based on experience with a benefits package for full-time employees that includes medical, dental, vision, life insurance, 401k match, and paid‑time off (PTO).

Incident IQ is an Equal Opportunity Employer