Lead Data Modeling Engineer

Circana; Bengaluru; On-site; INR 3,000,000 - 6,000,000; Full time

Job summary

Circana in Bengaluru, Karnataka seeks a Lead Data Modeling Engineer to design and optimize OLAP data models, and collaborate with cross-functional teams to align models with business needs.

The role requires 11–16 years in data modeling, strong SQL, data warehousing, and experience with data modeling tools like Erwin, Cognos, and OBIEE; leadership and stakeholder management are essential.

Qualifications

• Master complex data modeling and OLAP design.
• Strong SQL and data warehousing expertise required.
• Experience with data governance and cross-functional collaboration.

Responsibilities

• Design and Develop Data Models within OLAP frameworks.
• Understand data pipelines and implement changes for enhancements.
• Relate entities and data granularity to business requirements.
• Explain roll-up and slicing of measures across models.
• Mentor engineers and lead data modeling initiatives.

Skills

SQL

Enterprise Data Warehousing

Database designs

Data Structures

Shell scripting or Python or C++

Tableau

Power BI

Education

BE/BTech/MTech/MCA

Tools

Erwin

Cognos

OBIEE

Job description

**Lead Data Modeling Engineer****Let’s be unstoppable together!**Circana is a leading provider of technology, AI, and data solutions for consumer packaged goods companies, manufacturers, and retailers. Our predictive analytics and Liquid Data platform help clients measure market share, uncover consumer behavior, and drive growth—powered by six decades of expertise and an expansive, high-quality data set.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’re a global company dedicated to fostering inclusivity and belonging. We value and celebrate the unique experiences, cultures, and viewpoints that each individual brings. By embracing a wide range of backgrounds, skills, expertise, and beyond, we create a stronger, more innovative environment for our 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 CertifiedTM 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.Learn more at www.circana.com.**What will you be doing?**This role involves developing OLAP Data Models for newer data systems, improve existing OLAP Data Models to provide optimal Model performance. Be able to collaborate with cross-functional teams to align Data Models with business requirements. Implement data governance standards and best practices of Data Modeling. Own the outcomes and be able communicate risks in advance. Be a team player and contribute to the success of the Team.**Job Responsibilities*** Design and Develop Data Models within OLAP frameworks.* Understand existing data pipelines and be able to handle changes to the exiting flow to achieve enhancements and change requests.* Be able to understand relationships between different entities in the existing data systems and relate the same with any newer entities getting integrated to the system.* Be able to grasp the granularity of different entities of the data systems and align to the business requirements.* Ability to break down complex requirements into smaller actionable components.* Understand the additive/non-additive nature of various measures and be able to explain roll up of values and interpretation of slicing and dicing of the measures.* Manage vendor relationships, and strategic partnerships related to data infrastructure.* Mentor senior engineers and technical leads, fostering a culture of innovation and continuous improvement.**Requirements*** Qualification - BE, BTech, MTech, MCA.* 11-16 years of industry Experience and minimum of 5 years of experience in **Data Modeling**.* Proficient in SQL, Enterprise Data Warehousing, Database designs (both SQL and No-SQL), Data Structures.* Experienced in **Shell Scripting or Python, or C++*** Experienced in any Data visualization tools like Tableau, Power BI* Experience in Data Modeling tools like **Erwin, Cognos, OBIEE*** Excellent leadership, communication, and stakeholder management skills.* Knowledge and experience on Big Data infrastructures (MPP databases and Distributed Data platforms) and any Cloud platform is a plus* Understanding, as well as the ability to clearly communicate **OLAP principles** is a plus* Passionate about technology, Data, AI, and their application in solving real-world business problems.* Previous experience translating client requirements into technical specifications* Previous experience building relationships with clients.**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): **Bengaluru, Karnataka**