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 ( currently using Python )
Participate in design and code reviews
Document implemented ETL designs
Develop automated test scripts
Participate in Daily 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
Qualifications
Must Have/Core Competencies:
Requires 5-10 Years of experience as an ETL developer -Experienced in Java development
Very strong knowledge of Jira-Very strong knowledge of Agile development
Good Understanding of Databases and Datawarehouse tools
Experienced in Python development
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:
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