Enterprise Data Specialist

Are you passionate about data and eager to make an impact in a global organization? Johnson Controls is seeking an **Enterprise Data Specialist**to join our dynamic team. In this role, you will play a critical part in driving the success of our digital transformation initiatives by supporting **data migration projects** from legacy ERP systems to **SAP S4 HANA** and **Oracle Fusion**, as well as conducting **data audits** to ensure the accuracy and quality of existing data from prior implementations.

This is an exciting opportunity to work on cutting-edge ERP solutions, collaborate with cross-functional teams, and leverage your expertise in data analysis to enhance operational efficiency.

In this role, you will:

- ** Data Migration**: Collaborate with teams to migrate large datasets from legacy ERP systems to **SAP S4 HANA** and **Oracle Fusion**, ensuring data accuracy and completeness.
- ** Conduct data audits** to ensure the accuracy and quality of existing data from previous implementations.
- Utilize **Microsoft Excel** and **Power BI** for data analysis and reporting.
- ** Automate** or **optimize** data workflows using **Python** or **SQL** (a strong plus).
- Collaborate with cross-functional teams to **identify gaps**, **document process improvements**, and **enhance decision-making** capabilities through reliable data.

**Key Responsibilities**

**Data Migration**:

- Coordinate and execute the transfer of large datasets from legacy ERP systems to SAP S4 HANA and Oracle Fusion.
- Ensure data quality, consistency, and completeness throughout the migration process.

**Data Auditing**
- Perform in-depth audits of existing data to identify discrepancies, errors, or outdated information.
- Validate and correct data, ensuring compliance with business requirements and data governance standards.

**Data Analysis & Reporting**
- Use Microsoft Excel, Power BI, and other analytical tools to create dashboards, trend charts, and presentations.
- Provide actionable insights to stakeholders, highlighting trends, anomalies, or improvement areas.

**Collaboration & Issue Resolution**
- Organize and lead meetings with IT specialists, OTC process owners, and functional leads to resolve data issues.
- Document findings, assign responsibilities, and follow up on due dates to ensure timely closure of open items.

**Tool & Process Improvement**
- When applicable, leverage Python or SQL to handle big data challenges, automate workflows, and optimize data processes.
- Identify opportunities to enhance ERP data structures, governance strategies, and reporting capabilities.

**Knowledge Transfer & Change Management**
- Document key learnings to support training content for end users.
- Collaborate with the change management team to ensure proper communication and adoption of new data processes.

**Skills and Qualifications**
- ** Bachelor’s degree** in Data Science, Computer Science, Information Systems, Actuarial Science or a related field (or equivalent work experience).
- ** Proficiency in English** (both written and spoken) is required to effectively communicate with global technical and non-technical audiences.
- ** Proficiency in Microsoft Excel** (pivot tables, VLOOKUP, XLOOKUP, macros, etc.) and solid experience with **Power BI** (data modeling, dashboards, DAX).
- Experience working on **ERP implementation** or **migration projects** at scale.
- Hands-on experience with **ETL** processes or data governance frameworks.
- ** Strong analytical skills** with a proven track record of handling and interpreting large datasets.
- ** Familiarity with Python or SQL** for data transformation and automation is highly advantageous.
- Experience or exposure to **SAP S4 HANA**, **Oracle Fusion**, or other major ERP systems—particularly in the Order-to-Cash domain—is a significant plus.
- ** Problem-solving mindset** with the ability to troubleshoot data-related issues in a fast-paced environment.