Let's be unstoppable together! Circana (formerly IRI and NPD) is the leading advisor on the complexity of consumer behaviour. 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 fuelled 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.
So, why Circana?
We're progressive, inclusive and people focused. We seek to create a down to earth culture which balances work and home life and enables our team to be the best that it can be. Our people are important to us and we offer a number of fantastic benefits including;
- Flexibility with the hours you work, and where you work them
- Employee training and continuous development programs
- Up to 5 weeks annual leave and holiday buy back scheme
- 16 weeks paid parental leave
- Birthday leave
- Summer half days
- Circana "Me" Days
- Cultural swap days
- Free onsite gym and swimming pool
Key responsibilities:
You will make enhancements to our current ETL workflows to ensure that large volumes of data can be processed more efficiently, in terms of scale and speed.
You will migrate other scheduled ETL workflows to Airflow. All ETL processes will be executed, and notification will be sent to the Operations team from the same framework.
More specifically, you will:
- Design, develop and implement automated high performance ETL systems
- Work with a variety of different data sources, including SQL databases and flat files
- Efficiently manage structured data and meta data
- Work with querying and reporting tools, application development tools, data mining and OLAP tools
- Manage the data cleansing and data enrichment process
- Design data warehouse architectures
- Test tools, models, and data pipelines
- Create and maintain detailed technical documentation
We're looking for:
- Tertiary qualification in Technology preferred
- Strong experience in workflow management and automation systems such as Airflow or Control-M (3+ years)
- Previous experience in ETL development (5+ years)
- Experience with Bash, Python and SQL scripting, in a Linux/Unix environment
- Knowledge and expertise in data model testing, data flow validation and system performance testing
- Proven experience with designing, implementing and optimising ETL processes
- Experience with designing data modelling and data warehouse architectures
- Strong communication and problem solving skills
Circana Behaviours
As well as the technical skills, experience and attributes that are required for the role, our shared behaviours sit at the core of our organization. Therefore, we always look for people who can continuously champion these behaviours throughout the business within their day-to-day role:
- Stay Curious: Being hungry to learn and grow, always asking the big questions
- Seek Clarity: Embracing complexity to create clarity and inspire action
- Own the Outcome: Being accountable for decisions and taking ownership of our choices
- Centre on the Client: Relentlessly adding value for our customers
- Be a Challenger: Never complacent, always striving for continuous improvement
- Champion Inclusivity: Fostering trust in relationships engaging with empathy, respect and integrity
- Commit to each other: Contributing to making Circana a great place to work for everyone
Interested?
We would LOVE to hear from you. Please apply online with your CV.