Let’s be unstoppable together! Circana (formerly IRI and NPD) is the leading advisor on the complexity of consumer behavior. Through unparalleled technology, advanced analytics, cross-industry data and deep expertise, we provide clarity that helps almost 7,000 of the world’s leading brands and retailers take action and unlock business growth. At Circana, we are fueled by our passion for continuous learning and growth, we seek and share feedback freely, and we celebrate victories both big and small in an environment that is flexible and accommodating to our work and personal lives. Join our inclusive, committed team to be a challenger, own outcomes, and stay curious together. Learn more at www.circana.com
Overview of the role:
Autobahn ETL Senior Engineer will be one of the key roles inside current Autobahn ETL team at Circana. Autobahn is a Circana core product process which delivers Market Insights to our clients by leveraging Unify® advanced capabilities and Circana Liquid Data architecture. All data transformation steps are performed in a totally automated way on a weekly basis and produces thousands of deliverables for Circana European clients.
The Autobahn Senior ETL Engineer will report to the Senior Technology Manager of Autobahn team and will be responsible for supporting Autobahn ETL processing, ongoing ETL optimizations and helping design new solutions in the field of big data with continued technology improvements, as well as supporting actual Senior Manager to coordinate the activities of current ETL development team. The Autobahn ETL team is a team of talented individuals highly committed to our clients and we are seeking a self-motivated person who is keen to design, develop and/or optimize technical solutions in the CPG domain.
Main role responsibilities:
Work with internal team members to develop and implement new ETL functionalities and modify existing ones, by using common programming languages Python and Linux Bash
Read and analyze existing software code and scripts to determine functionality
Technical Support (Issue investigation, application of fixes and / or direction to Operations teams) on platform processing
Coordinate Autobahn ETL offshore team activities and monitor daily status
Create and maintain process documentation
Skills and Experience Required:
3-5 years’ experience in active SW design & development roles on big data environment. Computer Science degree or equivalent is prefered
Strong ETL processing experience
Deep experienced with Linux shell scripting in Bash
Proficient with Python
Strong Relational database experience on any of the following: PostgreSQL, Oracle, MonetDB, MySQL, MS SQL Server
Excellent written and verbal communication in English language
Highly motivated, self-driven individual with attention for detail, and willing to learn new things
Building relationships with colleagues across countries and teams, in a virtual work environment
Bonus points for:
Previous experience operating under DevOps culture
Proficient with Java, Apache Airflow
Any cloud platforms experience on AWS, Azure, Oracle & Google Cloud