Mediavine ยท 14 hours ago
Data Engineer II - (Remote - US)
Maximize your interview chances
AdvertisingInformation Technology
Insider Connection @Mediavine
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Create data pipelines that make data available for analytic and application use cases
Develop self-healing, resilient processes that do not require constant care and feeding to run smoothly
Create meaningful data quality notifications with clear actions for interested parties including other internal teams and other members of the data and analytics team
Leading projects from a technical standpoint, creating project Technical Design Documents
Support data analysts and analytics engineers ability to meet the needs of the organization
Participate in code reviews, understanding coding standards, ensuring test coverage and being aware of best practices
Build or implement tooling around data quality, governance and lineage, in the dbt framework and Snowflake but external to that as needed
Provide next level support when data issues are discovered and communicated by the data analysts
Work with data analysts and analytics engineers to standardize transformation logic in the dbt layer for consistency and ease of exploration by end users
Enable analytics engineers and data analysts by providing data modeling guidance, query optimization and aggregation advice
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Applicants must be based in the United States
3+ years of experience in a data engineering role
Strong Python skills (Understands tradeoffs, optimization, etc)
Strong SQL skills (CTEs, window functions, optimization)
Experience working in cloud environments (AWS preferred, GCS, Azure)
An understanding of how to best structure data to enable internal and external facing 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 either traditional or DAG based
Comfortable working with multi-TB cloud data warehouses (Snowflake preferred, Redshift, Big Query)
Experience with other DBMS systems (Postgres in particular)
Preferred
Experience with web analysis such as creating data structure that support product funnels, user behavior, and decision path analysis
Understanding of Snowflake external stages, file formats and snowpipe
Experience with orchestration tools particularly across different technologies and stacks
Experience with dbt
Knowledge of Ad Tech, Google Ad Manager and all of it's fun quirks (so fun)
The ability to make your teammates laugh (it wouldn't hurt if you were fun to work with is what I'm saying)
Familiarity with event tracking systems (NewRelic, Snowplow, etc)
Experience with one or more major BI tools (Domo, Looker, PowerBI, etc.)
Benefits
Comprehensive benefits including Health, Dental, Vision and 401k match
Generous paid time off
Wellness and Home Office Perks
Up to 12 weeks of paid Parental Leave
Inclusive Family Forming Benefits
Professional development opportunities
Travel opportunities for teams, our annual All Hands retreat as well as industry events
Company
Mediavine
Mediavine is the largest exclusive ad management company in the U.S., and a Comscore top five lifestyle property.
Funding
Current Stage
Growth StageRecent News
2024-05-21
2024-05-21
Company data provided by crunchbase