Insomniac Design

Global agency delivering technology solutions

Senior Data Engineer

Data EngineeringConfirmed live in the last 24 hours

Full-time$115k - $150k

About the Job

Requirements

At least 7 years of experience in data engineering building scalable data solutions.
Expertise in SQL and relational database management systems, including MySQL, PostgreSQL, and Oracle.
Proficiency in Python or similar languages for data processing and automation.
Deep understanding of AWS, GCP, or Azure and their cloud-native data services, including Redshift, Glue, S3, Synapse, Data Factory, BigQuery, and Dataflow.
Hands-on experience with Apache Spark, Kafka, Airflow, dbt, Snowflake, and Databricks.
Expertise in data modeling.
Strong knowledge of data security, governance, and compliance frameworks.
A 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 and tools such as Jira and Git.
Strong communication and stakeholder management skills.

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, including partitioning, indexing, and cost-efficient cloud solutions.
Evaluate and integrate emerging 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 continuous integration and continuous delivery (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 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, including GDPR and CCPA, and enforce security best practices.
Develop frameworks for data quality validation, anomaly detection, and integrity checks.
Collaborate with clients and project managers 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 IaC solutions.

Desired Qualifications

Certifications in cloud or data technologies, such as AWS Certified Data Analytics or Google Cloud Data Engineer.
Experience with machine-learning pipelines, including feature stores and model deployment.
Contributions to open-source data projects.

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

About the Company

Insomniac Design

Global agency delivering technology solutions

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: Not listed
Total funding: Not listed
Headquarters: Washington DC, District of Columbia
Founded: 2001

Recently Posted Jobs

Explore more opportunities at Insomniac Design

See more jobs