Sr. Software Engineer, Core Metrics

As a Sr. Software Engineer at Viant, you'll be responsible for designing, developing, and deploying big data systems that manage key metrics for billable events. This role involves optimizing complex SQL queries, developing ELT jobs, and ensuring the quality and performance of our data engineering pipelines. Your responsibilities also include collaborating with product teams, mentoring junior engineers, and participating in rotating on-call duties for data pipelines.

Viant looks for candidates with a minimum of 5 years of professional experience in software development, with at least 2 years focused on big data projects. Proficiency in SQL, extensive experience with Big Data technologies, and familiarity with cloud ecosystems such as AWS and GCP are essential. Candidates should also possess strong troubleshooting skills and a 'figure-it-out' attitude.

In the Sr. Software Engineer role at Viant, you'll engage with tools and technologies like Google BigQuery for data analysis, as well as various programming languages for ELT development. Expect to work within hybrid cloud environments in GCP and AWS, optimizing data processing and implementing machine learning techniques as well.

The Core Metrics team at Viant plays a vital role by managing the metrics that directly impact our billing and reporting systems. By ensuring data accuracy, auditability, and compliance, the team supports financial integrity and operational efficiency. This ultimately helps Viant deliver top-tier ad solutions and maintain a competitive edge in the digital marketing landscape.

At Viant, the work culture fosters collaboration, innovation, and continuous learning. As a Sr. Software Engineer, you'll be part of a supportive environment where mentoring is encouraged, and team members work together to solve complex problems. Viant values ownership and quality in the work produced, which contributes to individual satisfaction and collective success.

When answering this question, focus on specific big data technologies you have used, such as Apache Spark, Hadoop, and Google BigQuery, emphasizing projects where you've implemented these technologies and the results achieved.

To answer this question, share techniques you use to optimize SQL queries, such as indexing, query rewriting, and using efficient joins. Provide an example from your past experience where these optimizations led to significant performance gains.

In your response, highlight your approach to mentoring, including sharing knowledge through code reviews, pair programming, and providing constructive feedback. Mention the importance of fostering a supportive learning environment.

Use this opportunity to discuss a specific project, detailing the challenges faced, your problem-solving approach, and the outcome. This showcases both your technical skills and your ability to adapt under pressure.

When discussing data governance, outline your understanding of compliance, accuracy, and standardization. Share past experiences where you've implemented data governance practices and the benefits they brought to your projects.

Detail your process for testing and validation, such as unit testing, integration testing, and code reviews. Emphasize your commitment to maintaining high coding standards and delivering reliable applications.

Explain your strategy for engaging with product owners, focusing on clear communication, understanding project requirements, and providing technical insights during the development process to align goals.

Discuss your experience with on-call responsibilities and how you prioritize tasks, manage incidents, and communicate effectively with the team during critical situations to ensure system stability.

Describe a specific ETL process you improved, outlining the initial challenges and the changes you implemented. Provide quantifiable results to highlight the impact of your enhancements.

Your answer should reflect your passion for innovation in digital marketing and your desire to work in a forward-thinking company like Viant. Mention specific aspects of Viant's mission and technology that resonate with you.