Lead Data Modeling Engineer

Posted 5 Days Ago
Be an Early Applicant
Bangalore, Bengaluru Urban, Karnataka, IND
Hybrid
Expert/Leader
Marketing Tech • Analytics
The Role
Designs and develops OLAP data models, improves model performance, manages data relationships and granularity, and aligns models with business requirements. The role includes understanding data pipelines, applying data governance, explaining measure aggregation, translating client requirements into technical specifications, managing vendor relationships, and mentoring engineering leaders. Strong experience in SQL, data warehousing, database design, scripting, visualization, and data modeling tools is required.
Summary Generated by Built In

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

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

      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.

      Skills Required

      • BE, BTech, MTech, or MCA qualification
      • 11–16 years of industry experience
      • At least 5 years of data modeling experience
      • Proficiency in SQL
      • Experience with enterprise data warehousing
      • Experience with SQL and NoSQL database design
      • Knowledge of data structures
      • Experience with Shell Scripting, Python, or C++
      • Experience with data visualization tools such as Tableau or Power BI
      • Experience with data modeling tools such as Erwin, Cognos, or OBIEE
      • Leadership, communication, and stakeholder management skills
      • Experience translating client requirements into technical specifications
      • Experience building client relationships
      • Knowledge of big data infrastructures, MPP databases, distributed data platforms, or cloud platforms
      • Understanding and ability to communicate OLAP principles

      Circana Compensation & Benefits Highlights

      The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Circana and has not been reviewed or approved by Circana.

      • Leave & Time Off Breadth — Unlimited PTO for many exempt roles and paid holidays are frequently highlighted. Feedback suggests these time‑off policies are a notable strength of the package.
      • Parental & Family Support — Paid parental leave is available in the U.S. and is described as competitive and well‑received. Company communications emphasize equal/neutral parental leave, reinforcing family support.
      • Wellbeing & Lifestyle Benefits — A broad slate of extras—such as adoption assistance, tuition/educational assistance, volunteer time off, and EAP—adds to the overall package. Feedback suggests these lifestyle‑oriented offerings complement core medical, dental, and vision coverage.

      Circana Insights

      Am I A Good Fit?
      beta
      Get Personalized Job Insights.
      Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

      The Company
      HQ: Chicago, Illinois
      4,423 Employees
      Year Founded: 2023

      What We Do

      Circana 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. Circana is hiring! To view our current openings, please visit our IRI and NPD LinkedIn company pages.

      Similar Jobs

      Hybrid
      2 Locations
      289097 Employees
      Hybrid
      2 Locations
      289097 Employees
      Hybrid
      3 Locations
      289097 Employees

      Hewlett Packard Enterprise Logo Hewlett Packard Enterprise

      Data Scientist

      Artificial Intelligence • Cloud • Information Technology • Consulting
      In-Office
      Bengaluru, Bengaluru Urban, Karnataka, IND
      85422 Employees

      Similar Companies Hiring

      Milestone Systems Thumbnail
      Artificial Intelligence • Security • Software • Analytics • Big Data Analytics
      Lake Oswego, OR
      1500 Employees
      Golden Pet Brands Thumbnail
      Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
      El Segundo, California
      178 Employees
      Blee Thumbnail
      Artificial Intelligence • Marketing Tech • Software
      New York, New York
      30 Employees

      Sign up now Access later

      Create Free Account

      Please log in or sign up to report this job.

      Create Free Account