Data Engineer

Mediavine is a fast-growing advertising management company representing over 10,000 websites. Founded by content creators, for content creators, Mediavine is a Top 20 Comscore property reaching over 125 million monthly unique visitors. The Data & Analytics team is looking for a Data Engineer to build and maintain their data infrastructure, focusing on scalable data pipelines, transformation processes, and data quality.

About This Role

The Data Engineer will be responsible for building and maintaining Mediavine's data infrastructure, including creating scalable data pipelines, managing transformation processes, and ensuring data quality and security. You will work with Python, SQL, and AWS, and be involved in decisions regarding tool selection and coding standards. The role offers the opportunity to contribute to a modern data stack and influence the team's technical direction.

Essential Responsibilities

• Create data pipelines to make data available for analytic and application use cases.
• Develop self-healing, resilient processes that run smoothly with minimal oversight.
• Create meaningful data quality notifications with clear actions.
• Lead projects from a technical standpoint, creating Technical Design Documents.
• Support data analysts and analytics engineers in meeting organizational needs.
• Participate in code reviews, adhere to coding standards, ensure test coverage, and follow best practices.
• Build or implement tooling for data quality, governance, and lineage within dbt and Snowflake, and externally as needed.
• Provide advanced support when data issues are discovered.
• Collaborate with data analysts and analytics engineers to standardize transformation logic in dbt for consistency.
• Provide data modeling guidance, query optimization, and aggregation advice to analytics engineers and data analysts.

Required Qualifications

• 3+ years of experience in a data engineering role.
• Strong Python skills (understanding tradeoffs, optimization, etc.).
• Strong SQL skills (CTEs, window functions, optimization).
• Experience working in cloud environments (AWS preferred, GCS, Azure).
• Experience managing complex dbt environments with hundreds or more flows.
• Understanding of structuring data for internal and external analytics.
• Familiarity with calling APIs to retrieve data (Authentication flows, filters, limits, pagination).
• Experience working with DevOps to deploy, scale, and monitor data infrastructure.
• Scheduler experience (traditional or DAG-based).
• Experience using AI-powered tools for code generation, documentation, and diagramming.
• Comfortable working with multi-TB cloud data warehouses (Snowflake preferred, Redshift, Big Query).
• Experience with other DBMS systems (Postgres in particular).
• Ability to travel up to approx. 15%.

Nice to Haves

• Experience with web analysis (e.g., product funnels, user behavior analysis).
• Understanding of Snowflake external stages, file formats, and snowpipe.
• Experience managing the semantic layer in dbt or Snowflake.
• Experience with orchestration tools across different technologies.
• Knowledge of Ad Tech, Google Ad Manager.
• Ability to make teammates laugh and be fun to work with.
• Familiarity with event tracking systems (Snowplow, etc.).
• Experience with major BI tools (Omni, Sigma, Metabase, etc.).

Benefits

• 100% remote work.
• Comprehensive benefits including Medical, Dental, Vision, Disability, and Life Insurance.
• 401(k) with company matching.
• Generous PTO.
• Wellness initiatives and employer-sponsored mental health resources.
• Professional development opportunities.
• Inclusive, collaborative, and entrepreneurial company culture.