Viant
Viant automates the planning, buying and measurement of advertising campaigns.
Irvine, CA

Data Engineer (SQL, Python) at Viant

| Orange County
Sorry, this job was removed at 11:35 a.m. (PST) on Friday, August 7, 2020
Find out who's hiring in Los Angeles.
See all Data + Analytics jobs in Los Angeles
Viant’s culture is a unique combination of strong leadership, ambition, collaboration, and fun, with incredible growth opportunities for our employees! We offer a fast-paced work environment, with a strong focus on employee engagement, recognition, and development. With a commitment to innovation from the top down, Viant continues to remain ahead of the curve in the rapidly changing ad tech marketplace. 
Viant’s Engineering team is looking for a Data Engineer to join our Irvine, CA office. The engineer will be involved in the full development lifecycle, contributing to various Viant product lines.

Responsibilities:

  • Writing complex SQL queries.
  • Analyzing and tuning SQL queries.
  • Writing ETL and ELT jobs using various tools and programming languages.
  • Designing, developing, testing, debugging and deploying applications and reports using various technologies.
  • Importing and exporting large amounts of data in formats like CSV, JSON, XML, etc.
  • Need to be able to easily switch between different technologies.
  • Solving complex performance problems, architectural challenges and production issues.
  • Working with product owners, QA engineers and fellow engineers.
  • Following organization processes and procedures.
  • Ad-hoc duties as needed.

Qualifications:

  • 2-3 years of experience in data engineering
  • Minimum B.S in computer science, mathematics or related field.
  • Strong foundation in computer science and OOP
  • Experience with Python (Java a huge plus)
  • Exposure to cloud based technologies like Google Cloud Platform, AWS.
  • Experience with web services.
  • Experience with MySQL, Oracle and other database technologies.
  • Ability to troubleshoot queries, stored procedures, functions, packages and triggers.
  • Excellent problem solving, critical thinking, and communication skills.
  • Ability to learn newer technologies in a short period of time.
  • Good sense of humor and a team player.
  • Exposure or understanding of NoSQL technologies a plus
  • Exposure to machine learning a plus

Benefits:

  • Competitive Salary and Bonuses
  • Paid benefits for the employees: Medical, Dental, Vision, LTD, Life insurance/AD&D
  • Paid parental leave
  • 401k
  • Summer “Work from Anywhere” Fridays
  • Wellness programs – info sessions and occasional chair massages
  • Employee discounts – e.g. gym memberships, wireless plans, entertainment tickets
  • Fully stocked kitchen
  • Casual Office Atmosphere
  • Commuter Benefits Program
  • Ongoing Education & Training
  • Company Sponsored Events & Team Building Experiences

About Viant:
 
Viant is transforming the world of omnichannel, programmatic media buying and advanced data analytics with a wide range of technologies leveraging artificial intelligence and machine learning to advance digital advertising effectiveness.
 
Viant designs and develops cloud-based software systems for automated routine analyses to identify hidden insights and high-value opportunities. We capture and analyze data about demand patterns, product preferences, and content consumption behaviors to improve customer retention and loyalty. Viant is continually optimizing how we measure that experience to determine how and where our clients should advertise and sell their products. Viant aims at uncovering revenue opportunities hidden in customer data and recommends where clients should focus marketing experiments to provide high-impact business breakthroughs faster. Viant’s vision is to improve advertising effectiveness by driving real business outcomes while transforming enterprise data into actionable natural language insights for business leaders.
 
In 2017, Viant acquired Adelphic Inc., a programmatic demand side platform company. Adelphic provides an omnichannel programmatic software solution for agencies, brands and other large media buyers to make meaningful engagements with consumers across today’s fragmented media market. For more information visit us at www.viantinc.com.
#LI-NS1

See More
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Where we are

We're located in a beautiful, new open office next to many eateries with easy access to the 405 freeway.

Technology we use

  • Engineering
  • Product
    • GolangLanguages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • AngularJSFrameworks
    • MySQLDatabases
    • BigQueryDatabases
    • AsanaManagement
    • JIRAManagement
Previous
Next

What are Viant Perks + Benefits

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Team workouts
Retirement & Stock Options Benefits
401(K)
Company Equity
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Company sponsored family events
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Happy Hours
Parking
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Customized development tracks
Paid industry certifications

An Insider's view of Viant

What’s the vibe like in the office?

It's a casual environment so you're not intimidated when talking to someone higher up. The open layout makes it so you're not closed out from others and people are more approachable. There are also a lot of events that help team interconnectivity and building relationships with team members. The work environment helps me do the best work I can do.

Chase

Ad Operations Coordinator

What kinds of technical challenges do you and your team face?

The challenge we have is each day we're facing a different, unique problem and we have to figure out a solution. Our data is so large and it creates many edge cases. We have to figure out how to cache the data, dig through the data and figure out if the data is valid. It's not routine work and we have to solve the problem in a short amount of time.

Mike

Software Developer

How has your career grown since starting at the company?

I joined Viant as a Campaign Manager. It allowed me to learn about the industry and managing effective marketing campaigns. I used the knowledge I gained to grow within the organization and I now work on our Sales Team as an Account Executive.

Stephanie

Account Executive

How do you make yourself accessible to the rest of the team?

Being accessible and approachable is key to developing a relationship with my team. The benefits of technology definitely allows for a more open door experience. Regardless of what I’m doing, they can message me at any time and I respond as soon as I can. In addition, we hold weekly 1:1s to regroup on key priorities and discuss anything they need.

Michelle

VP, Operations

How does the company support your career growth?

We have great managers that don't put limitations or restriction on growth. They expect more from you and give you the encouragement to learn and develop. They are good at teaching and recognizing hard work. It's up to you as an individual to choose what you want to learn and how you want to move your career path.

Brian

Jr. Site Reliability Engineer

Jobs at Viant
15

All Jobs
All Jobs
Finance
Design + UX
Dev + Engineer
Product
Sales
Tap to close

Product Manager, Algorithm & Bidding

Viant
Greater LA Area
1 week ago
+45
We are looking for a Product Manager who will own, lead and manage key initiatives within the Adelphic Demand Side Platform’s (DSP) bidding algorithm, verification integrations, and location data offerings from ideation/inception, to requirements definition, to design and release.

Product Manager, Usability & Workflow

Viant
Greater LA Area
1 week ago
+45
The Sr. Product Manager will own, lead and manage key initiatives for Adelphic DSP’s user experience (UX) capabilities iterating from ideation/inception, to requirements gathering, design, review, QA, release and product marketing towards Product Market Fit. This role is an individual contributor.

UX Designer

Viant
Orange County
1 week ago
+45
Viant’s culture is a unique combination of strong leadership, ambition, collaboration, and fun, with incredible growth opportunities for our employees! We offer a fast-paced work environment, with a strong focus on employee engagement, recognition, and development. With a commitment to innovation from the top down, Viant continues to remain ahead of the curve in the rapidly changing ad tech marketplace.    About the role: We are looking for a

Sr. Account Executive

Viant
Greater LA Area
1 week ago
+45
The ideal Account Executive candidate has a solid understanding of digital media and ad tech, and is an enthusiastic and outgoing self-starter who is a key player in driving revenue and building a growing client base. With excellent communication and interpersonal skills, the ideal candidate works well, collaborates with team members, and possesses the passion to drive change in digital media. The Account Executive should be ready to hit the ground running to close new business, and thrive in an entrepreneurial, fast-paced environment.

Software Engineer (Ad Serving, Java, SQL)

Viant
Greater LA Area
1 week ago
+45
Provides technical expertise to implement and deliver various web and other system projects. Gathers and analyzes requirements, design and development of the projects. Organizes and participates in review sessions and contribute to design insights for the projects. Develops good quality projects in a challenging timeframe and assists other members of the team. Participates in system testing to ensure quality deliverables. Contributes to the development and continuous review of the existing projects as well as participate in view and scope of future projects. Engage in all phases of software development life cycle. Interfaces with program managers and other developers for project-based assignments. Contributes to and has responsibility for completion of assigned project.

DevOps Engineer

Viant
Greater LA Area
1 week ago
+45
The Site Reliability Engineer will be responsible for writing and integrating various open source and closed sources tools. The ideal candidate will possess a deep understanding of systems engineering and automation, including configuration management, containerization, and scripting. If you are a self-starter, highly motivated, and take pride in what you do, then this is an excellent opportunity to hone your craft in one of the largest-scale Linux environments in the Los Angeles area. We are a top-notch team of hard working individuals who are dedicated to ensuring that the supported organizations have the tools needed to do their jobs. We’re looking for like-minded geeks that enjoy what they do.

Software Developer (TechOps)

Viant
Orange County
1 week ago
+45
The Software Developer will build internal tools to improve automation, scalability, monitoring and security for our core infrastructure. You will collaborate with software engineering in the design and implementation of new infrastructure and applications. The ideal candidate is a coder at heart with an interest in DevOps, infrastructure and building tools with the newest cutting-edge technologies. 

Sr. Revenue Accountant

Viant
Orange County
1 week ago
+45
The Sr. Revenue Accountant will report directly to the Revenue Manager and will be responsible for ensuring that monthly billed amounts are within contract and credit limits. This position will not only perform billing tasks, but will be responsible for day-to-day accounting functions, recording and reconciling accounts, assisting with credit and collections, and various ad hoc projects.

Full-Stack Software Engineer (Angular, Java)

Viant
Orange County
1 week ago
+45
Designing, developing, testing, debugging and deploying applications and reports using various technologies. Writing complex SQL queries. Need to be able to easily switch between server-side and client-side technologies. Solving complex performance problems, architectural challenges and production issues. Working with product owners, QA engineers and fellow engineers. Following organization processes and procedures. Ad-hoc duties as needed.

Senior Manager, Tax

Viant
Orange County
1 week ago
+45
Responsible for the accurate and timely performance of various assigned functions in support of the monthly, quarterly and annual transactional tax returns and month-end close process. Ensure the accuracy of tax liabilities and payments, reports and data files; reviews the financial results and provides communication to management. Design and implement necessary controls to ensure the Company's tax liabilities and financial statements are accurate, reliable and in conformity with individual local and state laws as well as Generally Accepted Accounting Principles (GAAP). Manage relationships with third party tax advisors. Keep up to date with ongoing trends and changes to legislation that will affect planning activities.

Product Manager, Data

Viant
Orange County
1 week ago
+45
The Product Manager, Data will own, lead, and manage key initiatives of Adelphic Demand Side Platform's (DSP) end user data, identity and graph capabilities, iterating from ideation/inception to requirement gathering, design, review, QA, release and product marketing towards Product Market Fit. This role is an individual contributor.

DevOps Engineer

Viant
Orange County
1 week ago
+45
The Site Reliability Engineer will be responsible for writing and integrating various open source and closed sources tools. The ideal candidate will possess a deep understanding of systems engineering and automation, including configuration management, containerization, and scripting.

Back-End Software Engineer

Viant
Orange County
1 week ago
+45
Designing, developing, testing, debugging and deploying applications and reports using various technologies. Writing complex SQL queries. Need to be able to easily switch between technologies. Solving complex performance problems, architectural challenges and production issues. Working with product owners, QA engineers and fellow engineers. Following organization processes and procedures. Ad-hoc duties as needed.

Accounting Supervisor

Viant
Orange County
1 week ago
+45
This role is an exciting opportunity to join a dynamic team at a leading and growing advertising technology company operating in a fast-paced industry. This role would be heavily involved in certain aspects of the financial close improvement process as the Company transitions to an SEC compliant close and reporting cadence. This role will assist the Accounting Manager and Assistant Controller with certain aspects of the financial close process and collaborate daily with the other Accounting Supervisor on staff to strategize and tackle the coordination of the monthly financial close, handling of audits requests, process improvement projects, and other various internal reporting requests as needed. This is a supervisory role that comes with the opportunity to supervise two junior-level general ledger staff with varying levels of skillsets.

Accounting Manager

Viant
Orange County
1 week ago
+45
This role is an exciting opportunity to join a dynamic team at a leading and growing advertising technology company operating in a fast-paced industry. This role would be heavily involved in the financial close improvement process as the Company transitions to an SEC compliant close and reporting cadence. This role will assist the Assistant Controller with all aspects of the financial close process and other crucial internal and external reporting needs. This is a management position that comes with the opportunity to manage multiple accounting personnel with varying levels of skill-sets.