Viant
is hiring
Data Analyst
About Our Company
Viant® is a publicly traded (Nasdaq: DSP) people-based advertising software company that enables ad buyers to plan, create, execute, and measure their omnichannel digital advertising investments. Its self-service DSP for omnichannel advertising, Adelphic®, provides the ability to execute programmatic advertising campaigns across TV, mobile, desktop, audio, digital out-of-home, and is the only DSP with IPv6 support for CTV environments. Viant’s proprietary, first-party data is linked to 115 million households, over 1 billion connected devices, and is combined with access to more than 280,000 audience attributes from more than 70 people-based data partners to enable scaled and accurate audience targeting and attribution. Viant is an Inc. Best Places to Work award winner and Adelphic is featured on AdExchanger’s Programmatic Power Players list.
Job Description & Responsibilities
You will have the opportunity to work on the design and implementation of big data systems, working with petabytes of data and billions of transactions in real-time. Our platform uses advanced machine learning techniques and the newest big data processing technologies and is deployed in a distributed, multi-region, cloud-based infrastructure.
THE DAY-TO-DAY
- Be a data analysis expert of the data engineering team to help with designing, developing, testing, and debugging big data applications using various technologies in a hybrid cloud environment in GCP and AWS.
- Write, analyze, and tune complex SQL queries.
- Write ELT jobs using various tools and programming languages.
- Proactively improve existing code and optimize existing ETL process based on constraints of time and cost.
- Import and export large amounts of data in formats like CSV, JSON, Parquet, etc.
- Solve complex performance problems, architectural challenges, and production issues related to big data usage.
- Working with product owners, fellow engineers, and operations team members.
Requirements
GREAT TO HAVE
- Minimum B.S. in computer science/data analytics. 2+ years of experience in computer science or big data field.
- Experience with understanding and working on big data projects and analysis is a must.
- Experience with using web services or RESTful services or micro-services.2+ years of experience working with a programming language like Python or and/or Bash.
- Experience performing requirements gathering and identifying the requirement gapAbility to analyze incoming data from 3rd parties and identify data issues using SQL and Excel.
- Good to have - Exposure to data visualization platforms like Tabea, Looker, or Data Studio.
- Ability to mentor others/Jr. team members when needed.
What we offer
LIFE AT VIANT
- Investing in our employee’s professional growth is important to us, but so is investing in their well-being. That’s why Viant was voted one of the best places to work and some of our favorite employee benefits include fully paid health insurance, paid parental leave and unlimited PTO and more.
$80,000 - $95,000 a year
In accordance with California law, the range provided is Viant’s reasonable estimate of the compensation for this role. Final title and compensation for the position will be based on several factors including work experience and education.