Back to jobs

Senior Data Engineer

Pay
$115,000–150,000/yearAnnual period assumed — pay source
Contributions to open-source data projects. Insomniac Design offers a competitive salary and benefits package including health and life insurance as well as 401k contribution. Salary range: $115,000 - $150,000. Applicant Eligibility: Please note, candidates who are eligible to work in the US without visa sponsorship are eligible to apply. We are not accepting applicants from recruiters or staffing agencies
Read the full posting
Work setting
Hybrid — work setting source
Work setup in the employer’s posting: hybrid
From the employer’s posting
Employment
Full-time — employment source
Employment type Full-time
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Architect and build data lakes, warehouses and real-time pipelines

  • Develop end-to-end ETL/ELT pipelines for structured and unstructured data

  • Optimize database structures, queries and pipeline performance

  • Implement data governance, RBAC and privacy compliance (GDPR, CCPA)

  • Mentor junior engineers and conduct code reviews

From the employer’s posting
Architect and implement enterprise-grade data platforms, including data lakes, warehouses, and real-time pipelines.
Architect and develop end-to-end ETL/ELT pipelines for structured and unstructured data ingestion, processing, and transformation.
Optimize database structures, schemas, indexing, and partitioning for efficient query performance.
Implement data governance policies, including metadata management, lineage tracking, and role-based access control (RBAC).
Mentor junior engineers, conduct code reviews, and set best practices.

Before you apply

Work authorization
Must already have the right to work in the USPlease note, candidates who are eligible to work in the US without visa sponsorship are eligible to apply
Apply at Insomniac Design

Posting record

Report an error

Open 4 monthsWe first saw this posting 136 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jul 8, 2026136 days ago
Recorded sightings
44
Last seen by us
Nov 21, 2026
Employer says posted
Jul 6, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

In line with similar jobs

$115K–$150K against $127K–$189K, the middle half of what similar US postings state.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 136

Up longer than most. Similar jobs usually come down between day 6 and day 56.

From 14,767 similar postings that came down. Coming down is not always a hire.

Insomniac Design is hiring

1 open job

  • No new data jobs since July
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • AWS
  • Azure
  • BigQuery
  • Databricks
  • dbt
  • GCP
  • Kafka
  • MySQL
  • Oracle
  • PostgreSQL
  • Redshift
  • S3
  • Snowflake
  • Spark
  • Airflow
Where the posting names them
- 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)
- 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.
- 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
Nice-to-Have (Bonus Skills): - 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).
- 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.
- 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.

Your next step

Complete your application on jobs.lever.co. The employer’s form will show what is required.

Applying through Lever

  • No account needed: one form, and Lever reads your resume into the profile recruiters search.

Already applied? Track this application

Job description

View original posting ↗

Insomniac Design is a global digital agency headquartered in Washington D.C., with offices in London, Bucharest and Chisinau.  We’re an agile, determined and innovative team organized by functional areas of expertise — Creative, Technology, Strategy, and Management. We specialize in human-centered design with deep focus on design thinking and digital transformation. 
 
At Insomniac, we leverage AI to free our teams from routine tasks so they can focus on the aspects of our functions that are most valuable. We thrive on creative problem-solving, collaboration, and innovation. By thoughtfully integrating AI into our workflows, we’re not only improving productivity but also ensuring our people have the tools to do their best work. This empowers us to build smarter solutions and deliver stronger results for our clients.
 
As a Senior Data Engineer, you will architect, build, and optimize scalable data platforms that empower our clients with unified, actionable insights. You will lead the design of robust data pipelines, enforce best practices in data governance and security, and mentor junior engineers. Your expertise will bridge technical execution and strategic vision, ensuring high-performance, secure, and scalable data solutions that drive business impact.

Technical Leadership & Strategy:

  • 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.

Data Architecture & Infrastructure:

  • 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.

Data Pipelines & ETL Development:

  • 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.

Data Governance, Security & Compliance:

  • 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.

Business & Stakeholder Engagement:

  • 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.

Innovation & Mentorship:

  • 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.

Technical Skills & Experience:

  • 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.

Leadership & Soft Skills:

  • Proven track record of leading data projects, including migrations, warehousing, and real-time analytics.
  • Ability to lead cross-functional teams and manage client expectations.
  • Strong problem-solving skills for debugging distributed systems and resolving data anomalies.
  • Experience with Agile/Scrum methodologies, including tools like Jira, Git.
  • Excellent communication and stakeholder management skills.

Nice-to-Have (Bonus Skills):

  • 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 offers a competitive salary and benefits package including health and life insurance as well as 401k contribution. Salary range: $115,000 - $150,000.
 
Applicant Eligibility: Please note, candidates who are eligible to work in the US without visa sponsorship are eligible to apply. We are not accepting applicants from recruiters or staffing agencies

Employment type

Full-time

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Contributions to open-source data projects. Insomniac Design offers a competitive salary and benefits package including health and life insurance as well as 401k contribution. Salary range: $115,000 - $150,000. Applicant Eligibility: Please note, candidates who are eligible to work in the US without visa sponsorship are eligible to apply. We are not accepting applicants from recruiters or staffing agencies
Location & working pattern

Washington, DC

Working pattern and location restrictions need checking in the full posting.

Work authorization
Insomniac Design offers a competitive salary and benefits package including health and life insurance as well as 401k contribution. Salary range: $115,000 - $150,000. Applicant Eligibility: Please note, candidates who are eligible to work in the US without visa sponsorship are eligible to apply. We are not accepting applicants from recruiters or staffing agencies Employment type

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.