Program Data Analyst - Digital Enablement, Sustainable Infrastructure

Johnson Controls, Inc.; Rockville (VA); On-site; USD 61,000 - 83,000; Full time

Benefits offered by this job

Competitive benefits package

Job summary

Johnson Controls is seeking a Program Data Analyst to transform messy project data into actionable insights. You will prepare large datasets, answer analytical questions under deadlines, and prototype AI-driven solutions for evaluation and budgeting decisions.

The role involves collaborating with project teams, engineering, sales, and leadership to deliver accurate outputs and documented methods that can be repeated and reasoned about.

Qualifications

• Master's degree in engineering, data science, CS, information systems, or related field.
• Experience processing large, inconsistent datasets end to end.
• Proficiency in Python, advanced Excel, and SQL.
• Experience calling/integrating APIs and building small automations.
• Experience applying AI services to real workflows.
• Clear written communication and documentation practices.

Responsibilities

• Process project data from multiple sources and normalize for analysis.
• Analyze datasets to answer defined questions and create visualizations for leadership.
• Identify and evaluate AI use cases with business owners and feasibility checks.
• Develop proofs of concept using scripting, cloud services, and API integrations.
• Collaborate with project teams, IT, sales, and leadership to fulfill requests.

Skills

Python

Excel

SQL

APIs

AI

Written communication

Education

Master's degree in engineering or data-related field

Tools

Power BI

Microsoft 365/SharePoint

Job description

What you will do

Johnson Controls Sustainable Infrastructure Digital Enablement team is seeking a Program Data Analyst who is comfortable building structure out of messy, unstructured project data and turning it into something the business can act on. The ideal candidate moves easily between preparing large datasets, answering analytical questions under real deadlines, evaluating where AI can genuinely help, and building working prototypes that prove an idea before anyone commits budget to it.

The Program Data Analyst supports the Digital Enablement team by processing project data, performing analysis and research, evaluating and implementing AI use cases, and developing proofs of concept. This role works directly with project teams, engineering, sales, and functional leaders, consolidating information from multiple systems and sources into accurate, timely outputs that support delivery and decision-making. The successful candidate is a self-starter who can manage several concurrent requests, document a method well enough that someone else can repeat it, and say clearly when an approach will not work.

How you will do it

Project Data Processing Support

• Extract, clean, and normalize project data from documents, PDFs, scanned files, and spreadsheets.

• Collect, validate, and consolidate data from multiple business systems and reporting sources.

• Run quality checks, document assumptions and exclusions, and flag gaps before they reach a deliverable.

• Build repeatable processing routines and structured outputs that reduce manual rework.

• Maintain version control and file organization so the current source of truth is unambiguous.

Analysis and Research

• Analyze prepared datasets to answer defined questions, including comparisons, benchmarking, trend analysis, and estimates.

• Research external data sources, tools, and vendor capabilities, and summarize what is usable, what it costs, and where the limits are.

• Produce recurring and ad hoc reports and create visualizations that communicate findings clearly to leadership.

• Present findings and recommendations to project teams and cross-functional stakeholders.

AI Use Case Evaluation and Implementation

• Identify candidate AI use cases with business owners and assess feasibility, data readiness, and expected value before any build commitment.

• Implement approved use cases using approved AI services and tooling, working within company data handling and governance requirements.

• Validate output quality against a documented baseline and measure the effort saved against the manual process it replaces.

• Track accuracy and adoption after release, and rework or retire use cases that do not hold up in day-to-day use.

• Maintain a running view of the AI use case pipeline so the team can see what has been tried, what worked, and what was set aside.

Proof-of-Concept Development

• Build small working prototypes using scripting, cloud services, and API integrations to test a proposed automation or digital tool.

• Scope each proof of concept with the requesting stakeholder up front: the question it answers, the data it needs, and the success criteria.

• Demonstrate results and drive a documented go or no‑go decision, including the effort, cost, and risk of taking it further.

• Hand off validated prototypes to IT or a development partner with enough documentation to rebuild to production standards.

Cross-Functional Collaboration

• Work closely with project teams, engineering, sales, IT, and functional leaders to understand what each request actually needs to answer.

• Manage several concurrent requests against project deadlines and elevate early when one is at risk.

• Explain methods, assumptions, and limitations in plain language to audiences that are not analytical.

What we look for

Required

• Master's degree in engineering, data science, computer science, information systems, or a related technical field.

• Demonstrated ability to process large, inconsistent datasets end to end, including extraction from documents and reconciliation across sources.

• Proficiency in Python or an equivalent scripting language, advanced Excel, and SQL.

• Experience calling and integrating APIs and building small automations without waiting for a development team.

• Practical experience applying AI services to a real workflow, with sound judgment about where they do not fit.

• Clear written communication and the discipline to document a method so it can be repeated and defended.

Preferred

• Hands‑on experience with cloud services for document extraction, image processing, or data pipelines.

• Experience with Power BI or a comparable visualization platform.

• Familiarity with the Microsoft 365 and SharePoint environment used for program data and collaboration.

• Prior exposure to project delivery environments where analysis feeds customer-facing deliverables.

• Prototyping experience taking an idea from concept to a demonstrated result and a documented decision.

Who we are

Johnson Controls is an equal employment opportunity and affirmative action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, status as a qualified individual with a disability, or any other characteristic protected by law. For more information, please view EEO is the Law. If you are an individual with a disability and you require an accommodation during the application process, please visit www.johnsoncontrols.com/tomorrowneedsyou.

HIRING SALARY RANGE: $60,600 - $83,400 (Salary to be determined by the education, experience, knowledge, skills, and abilities of the applicant, internal equity, and alignment with market data.) This position includes a competitive benefits package. The posted salary range reflects the target compensation for this role. However, we recognize that exceptional candidates may bring unique skills and experiences that exceed the typical profile. If you believe your background warrants consideration beyond the stated range, we encourage you to apply. To support an efficient and fair hiring process, we may use technology assisted tools, including artificial intelligence (AI), to help identify and evaluate candidates. All hiring decisions are ultimately made by human reviewers. For details, please visit the About Us tab on the

Johnson Controls Careers site at https://jobs.johnsoncontrols.com/about-us