Senior Data Engineer
Remote US
Ad Tech (Flashtalking) – Flashtalking Tech /
Full-time /
Remote
What You Will Do:
As a member of the TVIQ team, you will work with a talented team developing a new cutting-edge linear and CTV media planning and buying platform with a heavy focus on data science and analytics. Your primary role will be the TVIQ team’s data engineer and architect. You will be expected to make design decisions on how the platform functions in terms of data handling. You will be responsible for all aspects of the product’s data pipelines, ETL, warehousing, SQL queries and will be working with data science and UI teams to orchestrate plan creation, optimization, and analytics.
Responsibilities will include:
- Managing the overall data engineering and data strategy for the Converge Media Planner development initiative
- Developing and maintaining ETL processes for various TV–based data sources e.g. Automatic Content Recognition (ACR), Nielsen Panel Data, etc.
- Architecting the TVIQ data warehouse including all schemas, tables, and views
- Translation of complex json structures into relevant SQL queries
- Working with team members to define and develop process orchestration in Airflow and Python
- Leading the transformation and translation of data into inputs for analytic processes
- Design and develop solutions in AWS
- Design and develop solutions in Snowflake
- Working with data science team members to develop linear and CTV plan optimizations
- Developing a thorough understanding of media buying for both linear and CTV space
- Develop reporting of KPIs, insights and recommendations
- Recommending technologies and products to improve department-wide processes
Who You Are:
- 7+ years of experience in a data engineering or related role.
- Experience with data modeling and ease working within databases; experience with designing and building products is preferred
- Required Skills: SQL, Python, AWS, Unix/Linux OS, RDS, Snowflake
- Preferred Skills: Airflow, Elasticsearch
- Excellent analytical skills
- You pride yourself on your ability to think and can break down complex problems into simple, solvable pieces
- Love for technology – Exposure to databases, programming, web design and software development methodologies a plus
- A mountain of patience when it comes to problem solving
- Willing to do whatever it takes. Failure isn’t an option for you
- You believe in having standards, strong principles and values
- Preference for delivering simple and effective solutions
- A desire to continuously learn and challenge yourself and a readiness to step out of your comfort zone
Why Mediaocean?
- Competitive total compensation, including 401(K) employer match and financial wellness seminars
- Extensive medical, dental, and vision plan – Keep your family (or just yourself!) safe and healthy
- Flexible time off – In addition to our 14 company holidays, we provide open PTO to all U.S.- based Mediaocean employees. So take a sick day, vacation day, or mental health day
- Bonding Leave – After six months of employment at Mediaocean, mothers and fathers, including same-sex parents, can take job-protected, paid time off to bond with their child within the first 12 months of the child’s birth or adoption
- Insurance, Pet Insurance, employer matched Health Savings Account and Flexible Spending Accounts
- Professional development – Personalized development plan created with your manager, continuous internal and external trainings, official company-wide mentorship program, professional development rewards program, management, leadership, and function-specific training for top performance, education reimbursement
- Get rewarded for demonstrating Mediaocean values
- Active affinity-based groups – Form connections with similar peers in offices around the world. Groups include: Women at MO, Black Employees at Mediaocean (BEMO), Pride at MO, Mi gente (Hispanic/Latinx community), AAPI at MO, Parents at MO, International Enrichment, Language Lovers, Books & Beyond, DEI in Engineering, and Mental Health & Wellness, and Caregivers United
- Wellness opportunities – Free virtual yoga and abs and glutes classes, company-paid Headspace meditation app membership, company-wide steps challenges, complimentary snacks in-office
- Bikeshare program in select offices, (Divvy and CitiBike for Chicago and New York offices)
- All of these benefits/perks are effective on the date of hire
