Business Intelligence Analyst - FSP Global Quality

Johnson Controls; Marinette (WI); On-site; USD 85,000 - 128,000; Full time

Job summary

Johnson Controls is seeking a data analytics/BI specialist to build reports, dashboards, and digital solutions that transform complex data into clear quality insights. You will partner with global stakeholders to align metrics and data definitions, while driving process improvements across multiple data sources and systems.

The role requires strong SQL, Power BI, and MS 365 skills, plus experience with SharePoint and Power Automate. Expected travel is 10%—primarily within Wisconsin and Texas.

Qualifications

• English language proficiency (reading, writing, speaking)
• BS in Computer Data Science/Applications, Mathematics/Statistics, or demonstrated technical abilities in similar areas
• 3+ years experience in Data Analytics or Business Intelligence
• Exceptional MS 365 skills (Excel, PowerPoint, CoPilot)
• Experience with multiple data sources including databases, Excel files, SharePoint Lists, and other business systems
• Experience using SQL, Power Query, and data transformation to blend data from multiple sources
• Experience building reports, scorecards, and dashboards using PowerBI
• Experience using Microsoft apps such as SharePoint, Power Automate, Power Apps, Lists, etc.
• Ability to communicate complex data insights through clear visualizations and business-focused recommendations
• Excellent analytical and problem-solving skills and ability to drive improvements
• Self-motivated, results-oriented with strong time management and organization
• Customer-focused with ability to manage priorities across a high-matrix organization

Responsibilities

• Build, maintain, automate, and publish reports, scorecards, and dashboards
• Design and develop digital solutions transforming data into insights on quality metrics
• Collaborate with technical teams to identify data tables and schemas for analysis
• Drive process improvements with digital solutions (PowerApps, Power Automate, PowerBI, SharePoint)
• Utilize BI tools and visualization to identify trends and support problem solving
• Manage data projects with plans, progress tracking, and stakeholder updates
• Support data governance by ensuring data quality and reporting accuracy
• Coordinate with global stakeholders to align reporting definitions and adoption
• Partner with corporate data teams to share best practices

Skills

English proficiency

Data analytics

Business intelligence

MS 365 skills

SQL

Power Query

Power BI

Data visualization

Root cause analysis

Cross-functional collaboration

Education

BS in Computer Data Science/Applications, Mathematics/Statistics

MS in Computer/Data Science (preferred)

Tools

SharePoint

Power Automate

Power Apps

Power BI (data modeling)

Job description

Johnson Controls, a global leader in thermal management, mission-critical building systems, energy efficiency, and decarbonization, helps customers use energy more productively, reduce carbon emissions, and operate with the precision and resilience required in rapidly expanding industries such as data centers, healthcare, pharmaceuticals, advanced manufacturing, and higher education.

For more than 140 years, Johnson Controls has delivered performance where it really matters. Backed by advanced technology, lifecycle services and an industry-leading field organization, we elevate customer performance, turn goals into real-world results and help move society forward.

This position leverages a combination of ad hoc and systems data, as well as, creating new data across large, fragmented global sources to support quality management system improvements, metric reporting / analysis, and must enjoy turning data patterns into actionable intelligence for Quality teams to use. You will be responsible for building tools to consolidate, analyze, and drive strategic decision making across the business unit. You will work with many stakeholders to understand the data, identify appropriate solutions, and execute systemic improvements.

How You Will Do It

• Build, maintain, automate, and/or publish reports, scorecards, and dashboards that align with tactical and strategic priorities to support business and quality objectives.
• Design and develop digital solutions that transform complex data in to clear insights into major quality metrics such as Cost of Poor Quality (CoPQ), internal/external parts per million defective (PPM), complaint or audit corrective action responsiveness.
• Communicate with technical teams to identify data tables and schemas needed for analysis. An understanding of ERPs and electronic Quality Management Systems (eQMS) is necessary to determine how to prepare and blend data from different systems.
• Assess current state reporting and identify and drive process improvement opportunities with digital solutions (PowerApps, Power Automate, PowerBI, Sharepoint, etc.) to increase operational efficiency and responsiveness.
• Utilize business intelligence tools, including Microsoft CoPilot, and visualization techniques to identify complex trends or patterns, communicate findings, and accelerate support solution identification for continuous improvement for global quality leaders.
• Manage data projects by creating project plans, tracking progress, and communicating project updates to stakeholders and senior leadership.
• Support data governance initiatives by helping maintain metric consistency, data quality, and reporting accuracy. Identify and elevate data integrity issues and recommend improvements.
• Partner with global stakeholders to support alignment of reporting definitions, metrics, and adoption of standardized reporting processes.
• Work with Corporate data teams to improve overall systems and share best practices.

Required

What we look for…

• English language proficiency (reading, writing, speaking)
• BS in Computer Data Science/Applications, Mathematics/Statistics, or has a degree and demonstrated technical abilities in similar areas
• 3+ years experience in Data Analytics or Business Intelligence
• Exceptional MS 0365 skills (Excel, PowerPoint, CoPilot)
• Experience working with multiple data sources including databases, Excel files, SharePoint Lists, and other business systems.
• Experience using SQL, Power Query, and data transformation techniques to extract, prepare, and blend data from multiple sources to support problem solving.
• Experience building reports, scorecards, and dashboards using Visualization software (PowerBI)
• Experience using Microsoft applications such as SharePoint, Power Automate, Power Apps, Lists, etc.
• Ability to communicate complex data insights through clear visualizations, presentations, and business-focused recommendations.
• Excellent analytical and problem-solving skills, including the ability to disaggregate issues, identify root causes, and recommend solutions.
• Self-motivated, results-oriented, and possess a strong sense of urgency.
• Strong time management and organization skills to work effectively in a high matrix organization.
• Highly customer-focused and able to manage conflicting priorities.

Preferred

• Master’s degree or advanced courses (Computer/Data Science, Data Analysis)
• Advanced Power BI experience including data modeling, DAX, Power Query, dashboard development, and report deployment. Knowledge and use of Python, R, or other analytical scripting languages.
• Experience in Quality demonstrating knowledge of QMS, CAPA, audits, complaints, nonconformance, and quality performance metrics.
• Certified Quality Improvement Associate (CQIA) or Certified Quality Process Analyst (CQPA)
• Six Sigma Certification Green (SSGB)

Travel Expectation

• 10% - mainly WI or TX to understand processes and data sources

Salary Range

Total Base Pay Range $85,200.00 - 127,800.00 USD (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