Data Engineer

National Alliance on Mental Illness; Arlington (VA); Hybrid; USD 95,000 - 105,000; Full time

Benefits offered by this job

Health Plans

Dental Plans

Vision Plans

PTO

Parental Leave

403(b) Plan

FSA (Flexible Spending)

Life Insurance

Disability

Flexible Work

Telework

Professional Development

Wellness

Employee Referral

EAP

Job summary

National Alliance on Mental Illness (NAMI) is building and operating a data platform to enable program impact measurement and data-informed decisions across national, state, and local teams.

You will design a central data warehouse, ELT pipelines, and analytics tooling to support leadership with reliable, integrated data, while reducing manual reporting and enabling self-service access for affiliates and partners.

Qualifications

• 3-5 years in data, analytics, or backend engineering.
• Strong proficiency in SQL and Python.
• Experience with version-controlled production ELT/ETL pipelines, including testing and monitoring.
• Solid understanding of data modeling (dimensional modeling, layered architecture).
• Experience with a modern cloud data warehouse.
• Ability to communicate technical concepts clearly to non-technical colleagues.

Responsibilities

• Design and implement a central data warehouse and ELT pipelines pulling from micro-services, Salesforce, and LMS.
• Enable leadership to measure program impact using integrated data.
• Lower manual reporting by delivering curated datasets and self-service reporting for state and local teams.
• Partner with stakeholders to expand on-demand data access and improve reporting workflows.
• Own data quality with automated testing, monitoring, and CI/CD as the platform scales.
• Handle incidents end-to-end from source to dashboard.

Skills

SQL

Python

ELT/ETL pipelines

Data modeling

Cloud data warehouse

Communication

Tools

dbt

Fivetran

Airbyte

Dagster

Airflow

Power BI

Tableau

Metabase

Salesforce

LMS

Job description

Build and run NAMI’s data platform to enable program impact measurement and data-informed decisions across national, state, and local teams.

Responsibilities

• Design and implement a central data warehouse and ELT pipelines that pull from organizational sources such as micro-services, Salesforce, and the LMS
• Enable leadership and teams to measure program impact by supporting strategy decisions with reliable, integrated data
• Lower manual reporting by delivering curated datasets and self-service reporting for state organizations and local affiliates, replacing hand-built affiliate reports
• Partner with stakeholders to expand on-demand access to data and support adoption of improved reporting workflows
• Own data quality by expanding automated quality testing, monitoring, and CI/CD as the platform scales
• Handle incidents end-to-end, from source to dashboard, when issues slip through automated checks
• Establish the foundation for future data hires as the team’s first dedicated data engineer, setting standards, patterns, and review practices
• Build and operate the end-to-end platform: ingestion, transformation, orchestration, and reporting
• Build and operate ELT pipelines
• Create well-modeled transformations using analytics engineering best practices
• Develop trusted, well-documented data products and contribute to their continuous improvement within established architectural patterns

Requirements

• 3-5 years in data, analytics, or backend engineering
• Strong proficiency in SQL and Python
• Experience with version-controlled production ELT/ETL pipelines, including testing and monitoring
• Solid understanding of data modeling (e.g., dimensional modeling, layered architecture)
• Experience with a modern cloud data warehouse
• Ability to communicate technical concepts clearly to non-technical colleagues

Technology Stack

• SQL, Python, ELT, ETL
• CI/CD
• Salesforce
• dbt, Fivetran, Airbyte
• Dagster, Airflow
• Power BI, Tableau, Metabase
• LMS

Preferred Skills & Experiences

• Hands-on experience with a SQL transformation framework such as dbt
• Exposure to managed ingestion or orchestration tooling (e.g., Fivetran, Airbyte, Dagster, Airflow)
• Experience with a BI tool such as Power BI, Tableau, or Metabase
• Experience helping evaluate, adopt, or migrate to new data tooling

Work Location and Schedule

• Arlington, VA (hybrid; remote or optionally hybrid based on preference)
• Availability during standard business hours with core hours between 10:00 a.m. and 3:00 p.m. ET
• 10-20% travel, including overnight

Physical Requirements

• Prolonged periods of sitting at a desk and working on a computer

Compensation

• USD 95,000 - 105,000 per year

Benefits

• Generous and comprehensive Health, Dental, and Vision Plans
• Paid Time Off: Vacation, Personal, and Sick Leave
• Paid Parental Leave
• 403(b) retirement plan
• Flexible Spending Accounts for health care, dependent care, and commuter expenses
• Life Insurance and Disability coverage paid by NAMI
• Flexible Work and Telework programs
• Professional Development Reimbursement program
• Wellness offerings to support team members
• Employee Referral Program
• Employee Assistance Program (EAP) for personal and family support