Director, ETL

Director, ETL

Let’s be unstoppable together!

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. We have a global commitment to diversity, equity, and inclusion as we believe in the undeniable strength that diversity brings to our business, employees, clients, and communities. With us, you can always bring your full self to work. Join our inclusive, committed team to be a challenger, own outcomes, and stay curious together. Circana is proud to be Certified™ by Great Place To Work®. This prestigious award is based entirely on what current employees say about their experience working at Circana.

Learn more at www.circana.com.

What will you be doing?

Designs, builds, and maintains data systems and pipelines. Ensure data quality and accuracy. Prioritize projects, plan, estimate, design, develop, test, and roll out projects. Monitor data applications and track product quality, performance, and stability. Documenting data engineering processes, best practices, and knowledge sharing to ensure the transfer of knowledge within the team and organization.

Job Responsibilities

• Ability to communicate well with global distributed teams.
• Independently design, code, unit test and deliver testable user stories.
• Demonstrate solutions through documentation, diagrams, code comments with optimized code.
• Maintain security standards compliance.
• Engage with key stakeholders, internal and external.
• Ability to analyze the issue in detail and provide multiple solutions approaches to a problem statement.
• Identifying and resolving performance bottlenecks in data processing and storage systems to ensure optimal performance and efficiency.
• Develop high quality applications that meets the performance and scalability standards in a multi distributed platform.
• Establishing data quality standards, implementing data governance processes, and ensuring data integrity, security, and compliance.

Requirements

• Bachelor’s in computer science, Software Engineering, or related field preferred.
• 10+ years of enterprise software development experience and SDLC.

• 7+ years Business intelligence and Analytics industry experience.
• Extensive experience aligning data from disparate sources with varying granularity.
• Familiarity with data integration techniques and tools, including APIs, data streaming, and ETL processes.
• Extensive experience in Linux or Unix OS or Big Data scripting Languages (Python, Spark, PySpark, Scala).
• Experience in working with third-party job scheduler (Airflow, Control-M a plus).
• Strong communication and leadership skills required.
• Agile Scrum experience required.
• Large-scale big data experience preferred.
• Retail industry experience is preferred.
• Must have experience working with offshore and global distributed teams.

Circana Behaviors

As well as the technical skills, experience and attributes that are required for the role, our shared behaviors sit at the core of our organization. Therefore, we always look for people who can continuously champion these behaviors 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.
• Center 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.

Location

This position can be located in the following area(s): Chicago/Remote 

Prospective candidates may be asked to consent to background checks (in accordance with local legislation and our candidate privacy notice ) Your current employer will not be contacted without your permission.

The below range reflects the range of possible compensation for this role at the time of this posting. We may ultimately pay more or less than the posted range. This range may be modified in the future. An employee’s position within the salary range will be based on several factors including, but not limited to, relevant education, qualifications, certifications, experience, skills, seniority, geographic location, performance, shift, travel requirements, sales or revenue-based metrics, any collective bargaining agreements, and business or organizational needs. The salary range for this role is $138,000.  

This job is also eligible for bonus pay.  We offer a comprehensive package of benefits including paid time off, medical/dental/vision insurance and 401(k) to eligible employees.  

An offer of employment may be conditional upon successful completion of a background check in accordance with local legislation and our candidate privacy notice. Your current employer will not be contacted without your permission.  You can apply for this role through the Circana careers website or Intranet site for internal candidates.  The anticipated application deadline for this position is 5/1/2025.