Insomniac Design Logo

Insomniac Design

Senior Data Engineer

Reposted 3 Hours Ago
Be an Early Applicant
In-Office or Remote
Hiring Remotely in Chisinau, Chișinău
Senior level
In-Office or Remote
Hiring Remotely in Chisinau, Chișinău
Senior level
The Senior Data Engineer will architect and manage scalable data platforms, optimize data pipelines, ensure data governance, and mentor junior engineers.
The summary above was generated by AI
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.

Top Skills

Airflow
Spark
AWS
Azure
BigQuery
Data Factory
Databricks
Dataflow
Dbt
GCP
Glue
Kafka
MySQL
Oracle
Postgres
Python
Redshift
S3
Snowflake
SQL
Synapse

Similar Jobs

An Hour Ago
Remote
21 Locations
87K-161K Annually
Senior level
87K-161K Annually
Senior level
Healthtech
The Senior Data Engineer will develop and optimize data pipelines, ensure data quality, and guide other engineers in data management processes for advanced analytics.
Top Skills: PythonSnowflakeSQL
An Hour Ago
Remote
21 Locations
87K-161K Annually
Senior level
87K-161K Annually
Senior level
Healthtech
The Senior Data Engineer will develop and optimize data pipelines, ensure data quality, and guide other engineers in data management processes for advanced analytics.
Top Skills: PythonSnowflakeSQL
3 Hours Ago
In-Office or Remote
18 Locations
Mid level
Mid level
Information Technology • Software
The Email Marketing Growth Manager will design and analyze A/B tests, manage experiments to optimize email marketing growth, conversion, retention, and user activation, leveraging insights for performance improvements.
Top Skills: Customer.IoMixpanel

What you need to know about the Seattle Tech Scene

Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.

Key Facts About Seattle Tech

  • Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Amazon, Microsoft, Meta, Google
  • Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Madrona, Fuse, Tola, Maveron
  • Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account