Strategy Market Intelligence Analytics & Knowledge Systems

Overview

Lead the analytical and data foundation of Johnson Controls' new Market Intelligence team in Gurugram, supporting the global Strategy and M&A organization as a founding member.

What you'll do

• Build and maintain Excel-based market models across strategic sectors, product lines, and geographies, and translate new intelligence into model updates.
• Design and maintain Power BI dashboards that track market size, competitor performance, and customer developments.
• Use SQL and Python to extract, clean, and integrate internal and external datasets, and automate recurring refreshes.
• Design and build the team's intelligence database and exhibits and reports library, establishing taxonomy, version control, and search conventions, and running these systems with AI assistance.
• Serve as the point of expertise on Johnson Controls internal data, including finance systems and Salesforce: access, definitions, filters, limitations, and how they inform models.
• Design and deploy AI-enabled workflows that source, synthesize, and validate insights, and set the quality checks AI-assisted outputs must pass before reaching executive and Board audiences.
• Deliver analysis on short timelines for M&A screening, diligence, and strategy initiatives.

What you'll need

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

Nice to have

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

Details

• Location: Gurugram (Delhi-Delhi-India as listed by the source ATS).