Job Information

AT&T Software Engineer II in El Segundo, California

Xandr is looking for a seasoned ETL Developer to join our team. We’re working on a cutting-edge Advertising reporting & analytics platform built on Snowflake + Looker.

This role will focus on designing ETLs to deploy large data sets on our cloud centric platform used to power our analytics. This role is ideal for a candidate who has a keen interest in working with large data sets to develop a BI platform (reports, visualization, data feeds), in this case for Media & Advertising landscape. The outputs and data sets are used for campaign planning & post-campaign reporting, which include campaign data, audience data and impression data across multiple data sources.

Core Responsibilities:

  • Design & Develop ETL code

  • Develop scripts or workflows to facilitate complex ingress processes

  • Participate in design and code reviews

  • Document implemented ETL designs

  • Develop automated test scripts

  • Participate in Scrum calls as well as sprint planning sessions to support development efforts

  • Effectively use Jira to estimate & track user stories and tasks

  • Proactively review, streamline and suggest improvements to our current processes and documentation

  • Establish a good working rapport with Dev Lead, System Engineers, Quality Assurance/Testers

Must Have/Core Competencies:

  • Requires 5-10 Years of experience as an ETL developer

  • Experienced with Teradata

  • Experience in the Addressable Advertising Technology industry

  • Very strong knowledge of Jira

  • Very strong knowledge of Agile development

  • Good Understanding of Databases and Datawarehouse tools

  • Expert-level SQL skills, including query optimization & stored procedures

  • Prior Experience working with Cloud based data warehouses

  • Some experience working in AWS environments (currently using S3 and EC2)

  • Some experience using Git or Source Code Control System in a multi-developer setting

  • Requires minimum supervision

  • Communicates & collaborates effectively with the team

Good to have, but not necessary:

  • Experience with Informatica

  • Some knowledge of Continuous Integration (CI)\Continuous Deployment (CD) pipelines (preferably Jenkins )

  • Some knowledge of QA test automation

  • Some experience Unix Shell \ Bash scripting

  • Some experience working with Workflow tools (such as Apache AirFlow)

  • Familiar with Data visualization/Business Intelligence tools

We expect employees to be honest, trustworthy, and operate with integrity. Discrimination and all unlawful harassment (including sexual harassment) in employment is not tolerated. We encourage success based on our individual merits and abilities without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, disability, marital status, citizenship status, military status, protected veteran status or employment status.