Job Description
Data Engineer I – (Remote – US)
RemoteAtlanta, Georgia, United States
Engineering
Full time
Description
Mediavine is seeking a Data Engineer to join our engineering team. We are looking for someone who enjoys solving interesting problems and wants to work with a small team of talented engineers on a product used by thousands of publishers. Applicants must be based in the United States.
About Mediavine
Mediavine is a fast-growing advertising management company representing nearly 10,000 websites in the food, lifestyle, DIY, and entertainment space. Founded by content creators, for content creators, Mediavine is a Top 20 Comscore property, exclusively reaching over 125 million monthly unique visitors. With best-in-class technology and a commitment to traffic quality and brand safety, we ensure optimal performance for our creators.
Mission & Culture
We help content creators build sustainable businesses. From educational tools and cutting-edge plugins to ad technology that maximizes earnings without slowing down your site, our motivation is to ensure their brand and business grow in every respect.
We are striving to build an inclusive and diverse team of highly talented individuals that reflects the industries we serve and the world we live in. We are committed to creating a culture where everyone feels welcome. We are looking for individuals that will challenge us to continuously evolve and make Mediavine the employer of choice for people of all backgrounds. We strongly encourage minorities and individuals from underrepresented groups in technology to apply for this position.
Diversity and inclusion aren’t platitudes to us; we take them seriously. Have a look at our team and read through our blog posts to learn more about our values and discover if Mediavine is the place for you!
Position Title & Overview
The Data & Analytics team consists of data analysts, data engineers and analytics engineers working to build the most effective platform and tools to help uncover opportunities and make decisions with data here at Mediavine. We partner with Product, Support, Ad Operations and other teams within the Engineering department to understand behavior, develop accurate predictors and build solutions that provide the best internal and external experience possible.
A Data Engineer at Mediavine will help build and maintain our data infrastructure. Building scalable data pipelines, managing transformation processes, and ensuring data quality and security at all steps along the way. This will include writing and maintaining code in Python and SQL, developing on AWS, and using third-party tools like Rundeck, Metabase, and others to round out the environment.
Our current data engineering toolkit consists of custom Python data pipelines, AWS infrastructure including Kinesis pipelines, Rundeck scheduling, dbt for transformation and Snowflake as our data warehouse platform..
Essential Responsibilities
- Maintain and support data pipelines that make data available for analytic and application use cases
- Follow established best practices in creating new pipelines
- React to data quality notifications, working with users and other developers to communicate the issue and resolve
- Grow in technical knowledge and expand your ability to contribute to the team
- 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 as needed
- Provide support when data issues are discovered by users or other team members
- Work with data analysts and analytics engineers to standardize transformation logic in the dbt layer for consistency and ease of exploration by end users
Requirements
Location:
- Applicants must be based in the United States
You Have:
- 1+ years of experience in a data role
- Experience with Python (Understands libraries, classes, functions)
- Proficient SQL skills (CTEs, window functions)
- An understanding of data modeling concepts
- Experience checking in code to production with source control, pull reviews, approvals, etc.
- Experience working with DevOps to deploy, scale and monitor data infrastructure
- Scheduler experience either traditional or DAG based
- Understanding of relational databases (Postgres, MySQL, SQL Server)
- Comfortable working with cloud data warehouses (Big Query, Snowflake, Redshift)
Nice to haves:
- Experience with web analysis such as creating data structure that support product funnels, user behavior, and decision path analysis
- Experience with dbt
- Experience with orchestration tools particularly across different technologies and stacks
- The ability to make your teammates laugh (it wouldn’t hurt if you were fun to work with is what I’m saying)
- Experience with unstructured data
- Experience with REST APIs
- Familiarity with event tracking systems (NewRelic, Snowplow, etc)
- Experience with one or more major BI tools (Domo, Looker, PowerBI, etc.)