Customer Service Operations Analyst

The future is being built today and Johnson Controls is making that future more productive, more secure and more sustainable. We are harnessing the power of cloud, AI/ML and Data analytics, the Internet of Things (IoT), and user design thinking to deliver on the promise of intelligent buildings and smart cities that connect communities in ways that make people’s lives and the world better.

Note, this role in an inhouse role, and the candidate can sit in either Marinette, WI or Lubbock TX.

The Continuous Improvement & Analytics team at Johnson Controls believes in the power of data to shape and steer business decisions within the customer service department. A data enabled business needs analysts to wrangle, organize, and use powerful visualization tools to derive actionable insights and patterns from the data and provide clear, concise answers to our customers. And that is where you come in.

As a COE Data Specialist for the Customer Service Department, you will be in the office 5 days per week supporting the US, Canada, and Latin America and your hours may vary dependent on the need. There will also be a 5% travel rate to visit similar factories for improvement. You will execute all administrative tasks relating to the Johnson Controls Fire Suppression parts and product and positively interact with customers both verbally and written.

• Using a combination of data mining, statistical and exploratory data analysis, develop an understanding of the data requirements required to answer business questions
• Based on business requirements, develop manual and automated scorecards and dashboards using internal and external data marts
• Understand and recommend data standardization to ensure repeatability and reusability of data products
• Design visualizations apt for answering the business question in consideration, and publish quality analytics to include weekly, monthly, or yearly dashboards with KPIs used by the business owners to improve their processes and operations
• Develop an AI integration platform/tool within customer service
• Develop department improvements for easier reporting and consistency

Required

• BS in business or related field / 4 + years total experience in CI/data analytics
• 3+ years of experience in Database, Data Model and Data Warehouse
• Experience in Kaizen facilitation and CI techniques
• Experience in languages such as Python, SQL.
• Knowledge in Dimensional Modelling, Datamart and different Data Modelling Techniques.
• Good Experience in Power
  
  BI, DAX Queries, Snowflake, Postgre
  
  SQL, Tableau.
• Strong spoken and written communication skills
• Salesforce experience

Preferred

• 2+ years of leading/facilitating process improvements
• Experience in building reports, KPI scorecards, and dashboards using Power BI desktop.
• Good understanding of Power
  
  BI Workspace and Administration.
• Knowledge in creating Dataset, Transformation, Dataflow, Measure Calculation on the dataset using Power
  
  BI.
• Experience in transforming data through SQL queries.
• A passion for all things Data - including Analytics, translating data into informative reports and visuals.
• SAP/JDE experience preferred

$76,000-$95,000 (Salary to be determined by the education, experience, knowledge, skills, and abilities of the applicant, internal equity, location and alignment with market data.) This position includes a competitive benefits package. For details, please visit the About Us tab on the Johnson Controls Careers site at

LI-#Onsite