Senior Software Engineer, Data Pipelines

Core responsibilities:

• Plan, architect, test, and deploy data warehouses, data marts, and ETL/ELT pipelines primarily within AWS and Snowflake environments
• Build scalable data pipelines capable of handling structured, unstructured, and high-throughput biological data from diverse sources
• Develop data models using dbt with rigorous testing, documentation, and stakeholder-aligned semantics to ensure analytics-ready datasets
• Build robust, production-ready data workflows using AWS, Kubernetes, Docker, Airflow, and infrastructure-as-code (Terraform/CloudFormation)

This role builds critical biosecurity data systems that help governments detect, attribute, and deter biological threats, supporting public health, national security, and global defense by enabling rapid identification of dangerous pathogens and informed response.

Required qualifications:

• 7+ years of professional experience in data or software engineering, with a focus on building production-grade data products and scalable architectures
• Expert proficiency with SQL for complex transformations, performance tuning, and query optimization
• Strong Python skills for data engineering workflows, including pipeline development, ETL/ELT processes, and data processing
• Proven experience with dbt for data modeling and transformation, including testing frameworks and documentation practices
• Hands-on experience with cloud data warehouses (Snowflake, BigQuery, or Redshift)
• Experience with workflow orchestration tools (Airflow, Dagster, or equivalent) for production data pipelines
• Solid grounding in software engineering fundamentals: system design, version control (Git), CI/CD pipelines, containerization (Docker), and infrastructure-as-code (Terraform, CloudFormation)

Compensation and benefits:

• Base salary range: $134,300-$189,900
• Company stock awards
• Comprehensive benefits package including medical, dental & vision coverage
• Health spending accounts
• Voluntary benefits
• Leave of absence policies
• 401(k) program with employer contribution
• 8 paid holidays plus full-week winter shutdown
• Unlimited Paid Time Off policy