--- title: 'Senior Data Engineer at Insomniac Design' canonical: 'https://feeny.ai/job/senior-data-engineer-insomniac-design-washington-6qag9n7h6kzk' type: 'job' last_seen: '2026-09-07' --- # Senior Data Engineer at Insomniac Design - **Company:** Insomniac Design - **Location:** Washington, DC - **Employment:** full-time - **Work type:** hybrid - **Posted:** 2026-07-06 - **Last confirmed live:** 2026-09-07 - **Apply:** https://jobs.lever.co/insomniacdesign/2079cb51-18bc-4bae-920e-95ec6e43324b ## Job description 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. ## About Insomniac Design ## Company Overview - **One-liner**: A global digital agency that strategically designs and delivers technology solutions, helping organizations create lasting impact through human-centered design and digital transformation. - **Entity Type**: Private (Privately Held) - **Headquarters**: Washington, D.C., United States - **Founded**: 1999 - **Founders**: Not publicly available ## Core Business - **Primary industry**: Technology, Information and Internet; Digital Agency - **Target customers**: B2B, Enterprise, Government Agencies, Fortune 500 companies, Non-profits, Media, Finance, Energy, Healthcare, Travel, Retail - **Mission/Purpose**: "Great Work Never Sleeps" – combining visionary thinking, an agile process, and powerful technology to create work that drives real-world change. ## Products & Services Insomniac Design offers a range of digital services, not packaged products. Key offerings include: - **Accelerated AI**: AI-driven solutions to transform business processes. - **Permitting Modernization**: Streamlining government permitting systems. - **Technology Strategy**: Strategic consulting for digital transformation. - **Creative Management**: Branding, design, and creative direction. - **Insights & Data Visualization**: Building data portals, dashboards, and visualization tools (e.g., UN Women gender data portal, Public Health Accreditation Board tool). - **Web Development & CMS**: Full-stack development, including Drupal/CMS solutions for government and enterprise clients. - **Digital Product Design**: User experience (UX) and human-centered design for complex platforms. ## Market Standing - **Valuation/Market Cap**: Not disclosed - **Key Metric**: Annual Revenue of approximately **$10.9M** (2025/2026 estimate) - **Notable Clients/Partners**: Brand USA, UN Women, Public Health Accreditation Board, Caribbean Development Bank, Politico, DC Courts, Environmental Defense Fund, Cvent - **Growth Signals**: Headcount of 36 (down 9.5% YoY), but active job postings show +16.7% yearly increase. Global presence across 7 countries (US, UK, Moldova, Romania, Bosnia, Italy, Spain). Recent project wins with major government and non-profit organizations. ## Competitive Advantages - **Human-Centered Design**: Deep focus on design thinking and user experience, particularly for complex government and public-sector projects. - **Global, Multilingual Team**: Team members speak 11 languages, enabling work with diverse international clients. - **Agile & Versatile**: Combines strategic consulting with technical execution, offering end-to-end solutions from strategy to build. - **Proven Track Record with High-Stakes Clients**: Experience with UN agencies, federal courts, and Fortune 500 companies builds trust and credibility. ## Strategic Focus - **Government & Public Sector**: Strong emphasis on digital modernization for government agencies (permitting, courts, health data). - **AI & Data**: Expanding into AI-powered solutions and data-driven insights. - **Client Partnerships**: Long-term collaborative relationships rather than one-off projects. ## Why Work Here - **Culture**: "Great Work Never Sleeps" – impact-driven, versatile, client-centric, and human-focused. Team-building and culture are significant priorities. - **Work Model**: Offers remote, hybrid, and on-site options depending on role. Headquarters in Washington, D.C. with offices in London, Bucharest, and Chișinău. - **Global Team**: Diverse colleagues across multiple countries and time zones. - **Meaningful Work**: Projects often have societal impact (e.g., gender data, public health, environmental conservation). - **Engineering & Design Focus**: Strong technical and creative teams; opportunities to work on full-stack development, AI, and complex systems. ## Sources 1. [insomniacdesign.com/careers](https://insomniacdesign.com/careers) 2. [linkedin.com/company/insomniacdesign](https://linkedin.com/company/insomniacdesign) 3. [jobs.lever.co/insomniacdesign](https://jobs.lever.co/insomniacdesign) 4. [insomniacdesign.com/about](https://insomniacdesign.com/about) 5. [insomniacdesign.com/work](https://insomniacdesign.com/work) ## Other roles at Insomniac Design - [CMS Full Stack Developer (cloud certified)](https://feeny.ai/job/cms-full-stack-developer-cloud-certified-insomniac-design-washington-e0d2fxeyqsfx) — Washington, DC - [Senior Solution Architect](https://feeny.ai/job/senior-solution-architect-insomniac-design-washington-at5k51qdg8kg) — Washington, DC - [Senior Solutions Architect – Government Systems](https://feeny.ai/job/senior-solutions-architect-government-systems-insomniac-design-washington-1avxew9s06xh) — Washington, DC - [Senior Technical Project Manager – Public Sector IT](https://feeny.ai/job/senior-technical-project-manager-public-sector-it-insomniac-design-washington-k2fd5x22vve9) — Washington, DC - [Senior Business Analyst (Government Services)](https://feeny.ai/job/senior-business-analyst-government-services-insomniac-design-washington-3t8ygbg0vvqp) — Washington, DC - [Senior Business Analyst](https://feeny.ai/job/senior-business-analyst-insomniac-design-washington-06hvrneexpts) — Washington, DC - [Solution Architect](https://feeny.ai/job/solution-architect-insomniac-design-chisinau-xsagxve0d54k) — Chisinau, Moldova - [Senior Data Engineer](https://feeny.ai/job/senior-data-engineer-alpaca-americas-htyrgy9wcxp0) — Americas - [Senior Data Engineer](https://feeny.ai/job/senior-data-engineer-nelo-mexico-city-rdvx7tz6atwf) — Mexico City, Mexico - [Senior Data Engineer](https://feeny.ai/job/senior-data-engineer-super-payments-london-gh9t2xej2r1x) — London, United Kingdom