Lead Data Modeling Engineer

BuddiesHR; Bengaluru; On-site; INR 2,400,000 - 3,600,000; Full time

Job summary

Circana in Bengaluru is seeking an experienced Data Modeler to design OLAP data models and optimize performance. You will collaborate with cross-functional teams to align data models with business needs and apply governance standards.

The role requires 11–16 years in industry with at least 5 years in Data Modeling, strong SQL, data warehousing, and BI tools, plus leadership and stakeholder management.

Qualifications

• BE/BTech/MTech/MCA required with strong SQL and data warehousing experience.
• 11–16 years in industry with at least 5 years in Data Modeling.
• Proficient in SQL, EDW, NoSQL; experience with OLAP, data governance, and BI tools.

Responsibilities

• Design and Develop Data Models within OLAP frameworks.
• Understand existing data pipelines and implement changes to enhance performance.
• Relate relationships between entities and integrate newer entities.
• Grasp the granularity of entities to meet business requirements.
• Break down complex requirements into actionable components.
• Explain roll-up and slicing of measures for accurate interpretation.
• Manage vendor relationships and data infrastructure partnerships.
• Mentor senior engineers and technical leads.

Skills

SQL

Enterprise Data Warehousing

NoSQL

Data Structures

Shell Scripting

Python

C++

Tableau

Power BI

Erwin

Cognos

OBIEE

OLAP Principles

Education

BE/BTech/MTech/MCA

Tools

Erwin

Cognos

OBIEE

Tableau

Power BI

Job description

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 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.

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 abouttechnology, Data, AI, and their applicationin solving real-world business problems.
• Previous experience translating client requirements into technical specifications
• Previous experience building relationships with clients.

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

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.