OTC Data Analyst

**Job Details**

**Overall Description**:
The Reports Specialist has the knowledge and skills to develop and create reports, trend charts and dashboards that turn raw data into information and insight, which can be used to make business decisions. He/she will analyze reports in legacy ERP systems in Global Products PBUs to understand data sources and how the report was developed and configured. With that understanding, the Reports Specialist will work with stakeholders to determine if enhancements can improve analytics, root cause analysis, decision making and operational performance. Enhancement opportunities will be documented and communicated. In addition, the Reports Specialist will gain access to data tables and the data lake to develop and deliver new reports. An additional responsibility will be to study and learn corresponding reports and reporting capabilities in S4 HANA ERP. This includes a working understanding of how data tables are organized, accessed, and configured in S4 HANA and how reports enhance decision making in the future state end-to-end business process. Working with SAP Data Domain, data lake and Power BI experts, develop and implement report bundles and dashboards for all end user personas/roles. The Reports Specialist will document key learnings and pass these learnings to the change management lead so appropriate training content can be created and delivered to end users.

**Responsibilities**
- Use automated tools to extract data from primary and secondary sources
- Remove inaccurate data or other sources of corruption
- Develop and maintain report bundles, Fiori apps and personal/role dashboards
- Perform analysis to assess quality and meaning of data
- Filter data by reviewing reports and performance indicators to identify and correct code problems
- Use statistical tools to identify, analyze, and interpret patterns and trends in complex data sets that could be helpful for diagnosis, prediction, and remediation
- Prepare reports for management stating trends, patterns, and error rates
- Work with SAP Data Domain experts, SAP Reports experts, site data leads, PBU/Functional data leads and site data object owners to identify process improvement opportunities, propose system modifications and devise data governance strategies
- Identify and catalog lessons learned for future SAP ERP site deployments
- Supports data extraction from source systems
- Follow the pre-deployment data readiness guidelines as provided by the GP MDM team
- Understand MDM data dictionaries and target data models

**Skills and abilities**
- Technical proficiency regarding data base design development, data models, techniques for data mining, and segmentation
- Effective communication skills, both oral and written with both technical and non-technical team members
- Ability to communicate in English (both oral and written) with the global teams
- Proven ability to respond within short time to constraints and meet deadlines, while maintaining accuracy
- Demonstrated collaborative, problem solving, prioritization, and analytical skills
- Strong mathematical skills to help collect, measure, organize and analyze data
- Adept at queries, writing reports and making presentations.

**Qualifications**
- **SAP experience**:

- **Has a passion for data, analytics, process improvement and driving excellence in operations**
- Creativity
- Ability for critical thinking
- Has a systemic and logical approach to problem-solving
- Team working and collaboration

**Education**
- Bachelor's degree or equivalent work experience; Master's Degree is a plus
- Lean Six Sigma is a plus

**Travel**
- **Up to 30% domestic/global**

**Computer Literacy**
- Johnson Controls does not request pregnancy or HIV testing as a requirement for admission, permanence or promotion. _

LI-JC1