Sr Data Analyst
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.
We understand more about the complete consumer, the complete store, and the complete wallet so our clients can go beyond the data to apply insights, ignite innovation, meet consumer demand, and outpace the competition.
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. Learn more at
What will you be doing?
The selected candidate will be a part of our Business Intelligence (BI) team for the In Store Audits group. The candidate will be responsible for delivering ad hoc and custom BI reports for different Circana clients based on specific In store conditions.
Job Responsibilities
- Building custom ad hoc BI reports based on the business need of the different client
- Use SQL , Custom visualizers to build and visualize the report
- Compute different Sales and Shelf measure based on the type of analysis
Experience : 5 years
Technical Skills
- Hands on with SQL coding and scripting. This is a must have skill (primary skills)
- Hands on experience in writing and optimizing SQL queries in SSMS.
- Skilled in writing SQL stored procedure coding and custom functions for either derived tables or reports.
- Proficient in using Tableau / Power BI to create tabular report and visualizations. (Secondary skills)
- Experience in Data analysis (familiar with Imputation, outlier detection, etc.)
- Experience in working with large volumes of data
- Good quantitative skills
- Experience in SSRS to create tabular / drill down reports is not mandatory but good to have.
- Experience in Python , R would be good to have.
Non-Technical Skills
- Analytical ability - Must have a clear understanding and experience in extracting Insights from data
- Should be familiar with CPG / Retail Domain. Familiarity with IRI / Nielsen data would be a big plus
- Communication - Strong communication skills with the ability to put across discussion points / viewpoints for both technical and non-technical audiences.
- Team working - Ability to work with and in cross-functional and virtual teams across locations.
- Organizational awareness Ability to see the whole picture’ and recognize the impact and opportunities of activities across the organization.
- Innovation Ability to develop innovative ways to solve complex problems, within constraints.
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) : Bangalore