Full-Time

Senior Data Engineer

Updated on 9/4/2026

Insomniac Design

Insomniac Design

11-50 employees

Global agency delivering technology solutions

Compensation Overview

$115k - $150k/yr

No H1B Sponsorship

Washington, DC, USA

Hybrid

Hybrid: some on-site days in Washington, DC.

Category
Data & Analytics (1)
Required Skills
Microsoft Azure
Redshift
Python
Airflow
MySQL
BigQuery
Apache Spark
SQL
Apache Kafka
Postgres
ETL
Infrastructure as Code (IaC)
Role-based Access Control
AWS
Oracle
Databricks
Snowflake
Google Cloud Platform

Get referred to Insomniac Design

See people who can refer or advise you

Requirements
  • 7+ years of experience in data engineering with a proven track record of building scalable data solutions.
  • Expertise in SQL and relational database management systems (MySQL, PostgreSQL, Oracle).
  • Proficiency in Python (or similar languages) for data processing and automation.
  • Deep understanding of cloud platforms (AWS, GCP, Azure) and cloud-native data services:AWS (Redshift, Glue, S3)Azure (Synapse, Data Factory)GCP (BigQuery, Dataflow)
  • Hands-on experience with big data tools:Apache Spark, Kafka, Airflow, dbt, Snowflake, Databricks
  • Expertise in data modeling.
  • Strong knowledge of data security, governance, and compliance frameworks.
Responsibilities
  • Architect and implement enterprise-grade data platforms, including data lakes, warehouses, and real-time pipelines.
  • Define and enforce data engineering standards, including ETL/ELT frameworks, data modeling, and quality controls.
  • Lead performance optimization of databases, queries, and pipelines (e.g., partitioning, indexing, cost-efficient cloud solutions).
  • Stay updated with emerging trends, evaluating and integrating new technologies.
  • Design and implement scalable data architecture that ensures high availability, security, and performance.
  • Define best practices for data modeling, storage, retrieval, and governance.
  • Optimize database structures, schemas, indexing, and partitioning for efficient query performance.
  • Implement CI/CD for data pipelines and automate infrastructure using Infrastructure-as-Code (IaC) tools.
  • Architect and develop end-to-end ETL/ELT pipelines for structured and unstructured data ingestion, processing, and transformation.
  • Automate and optimize data workflows using tools like Apache Spark, Kafka, Airflow, and dbt.
  • Monitor, troubleshoot, and optimize data pipeline performance.
  • Implement data governance policies, including metadata management, lineage tracking, and role-based access control (RBAC).
  • Ensure compliance with data privacy regulations (e.g., GDPR, CCPA) and enforce security best practices.
  • Develop frameworks for data quality validation, anomaly detection, and integrity checks.
  • Collaborate with stakeholders (clients, PMs) to translate business needs into technical specifications and scalable architectures.
  • Develop interactive dashboards and reporting solutions to provide actionable insights.
  • Lead technical discussions, workshops, and knowledge-sharing sessions within the team.
  • Mentor junior engineers, conduct code reviews, and set best practices.
  • Drive automation of data workflows, including CI/CD for pipelines and Infrastructure-as-Code (IaC) solutions.
Desired Qualifications
  • Certifications in cloud/data technologies (e.g., AWS Certified Data Analytics, Google Cloud Data Engineer).
  • Experience with ML pipelines (e.g., feature stores, model deployment).
  • Contributions to open-source data projects.

Insomniac Design is a global agency that designs and delivers technology solutions in partnership with organizations seeking a lasting impact. With a globally diverse team headquartered in Washington D.C. and offices in London, Bucharest, and Chișinău, it combines strategic thinking, an agile process, and strong technology to create work that “never sleeps.” How it works: the company partners with clients to understand their goals, then uses a rapid, iterative approach to design and build technology solutions — from strategy through delivery — leveraging cross‑regional collaboration and modern tech stacks. What sets it apart: a worldwide, diverse team plus an emphasis on turning strategic insight into actionable technology outcomes through an agile, collaborative process that stays closely aligned with client needs. Its goal is to help organizations achieve a meaningful, lasting impact by delivering technology solutions that address real problems and move projects forward quickly.

Company Size

11-50

Company Stage

N/A

Total Funding

N/A

Headquarters

Washington DC, District of Columbia

Founded

2001

Get referred to Insomniac Design

See people who can refer or advise you

Simplify Jobs

Simplify's Take

What believers are saying

  • Brand USA hired Insomniac in 2026 for a company-wide intranet and platform overhaul.
  • Updated 2026 case studies show active delivery for public health, tourism, and courts.
  • Global offices in London, Bucharest, and Chisinau support delivery across U.S. and international clients.

What critics are saying

  • Revenue depends on procurement cycles at Brand USA, UN Women, and government agencies.
  • Large consultancies and specialist civic-tech firms can outbid on enterprise transformation deals.
  • If Permitix fails to win scaled government adoption, agency growth stays services-led and fragile.

What makes Insomniac Design unique

  • Washington D.C.-based global agency serving government, aid, and policy clients across four offices.
  • Combines design, engineering, Data, AI, and technology for complex public-sector platforms.
  • Permitix targets permitting workflows for states and federal agencies, not generic marketing websites.

Help us improve and share your feedback! Did you find this helpful?

Benefits

Health Insurance

Life Insurance

401(k) Retirement Plan

401(k) Company Match