Strategy Market Intelligence Analytics & Knowledge Systems

About the Team

Johnson Controls is establishing a Market Intelligence team in Gurugram to support its global Strategy and M&A organization, which has a presence on every continent. The team will be the company’s central source of market sizing, competitive monitoring, and trend intelligence across strategically important sectors, product lines, and geographies.

As a founding member, you will define how this function operates for the long term. With support from the global Strategy team, you will establish its methods, tools, and standards. The team will build its infrastructure once and run it with AI assistance, so its members can concentrate on analysis and insight.

Role summary

You will lead the analytical and data foundation of the team. You will design and build the market models, dashboards, and intelligence systems that let the Strategy and M&A team answer questions faster and with greater confidence. You will also be the team’s authority on where data resides inside and outside Johnson Controls and how to use it.

Key responsibilities

• Market models: Build and maintain Excel-based market models across strategic sectors, product lines, and geographies, and translate new intelligence into model updates.

• Dashboards: Design and maintain Power BI dashboards that track market size, competitor performance, and customer developments.

• Data engineering: Use SQL and Python to extract, clean, and integrate internal and external datasets,and automate recurring refreshes.

• Intelligence systems: Design and build the team’s intelligence database and exhibits and reports library. Establish the taxonomy, version control, and search conventions, then run these systems with AI assistance to accelerate ad hoc work.

• Internal data access: Serve as the point of expertise on Johnson Controls internal data, including finance systems and Salesforce. This covers access, definitions, filters, limitations, and how they inform our models

• AI enablement: Design and deploy AI-enabled workflows that source, synthesize, and validate insights. Set the quality checks that AI-assisted outputs must pass before they reach executive and Board audiences.

• Ad hoc support: Deliver analysis on short timelines for M&A screening, diligence, and strategy initiatives.

Qualifications – Required

• 8+ years of experience, including 5+ years at a top-tier strategy consulting firm or its research or analytics center

• Advanced Excel modeling, with demonstrated experience in market sizing

• Working proficiency in SQL and Python, including use of AI-assisted coding and familiarity with software development best practices such as version control, code documentation, and long-term code maintenance

• Experience evaluating data sources, including assessing quality, coverage, and strategic fit to support business and market analysis

• Experience developing and evaluating financial models, including comparing and assessing alternative modeling approaches

• Experience building dashboards in Tableau and/or Power BI

• Experience designing a knowledge repository, research database, or comparable system

• Bachelor’s degree in engineering, economics, statistics, or a related field; MBA or master’s degree preferred

• Excellent written and spoken English, with the ability to present to senior global stakeholders

Qualifications – Preferred

• Exposure to industrial, building technology, HVAC, or B2B equipment markets

• Experience with Salesforce data and enterprise finance systems

• Hands-on experience applying generative AI tools to analytics workflows
• Experience developing executive-level presentations using PowerPoint and Think-Cell, including advanced charting and storytelling techniques

Attributes we value

• Self-starter who takes ownership and shapes a new function

• Curiosity about the markets, technologies, and companies under study

• Interest in how AI can make research more insightful, timely, and accurate
• High standards for accuracy and source discipline