Senior IT ERP Business Systems Analyst

Requisition ID:  86659 

Florida Power & Light Company is the largest electric utility in the U.S., delivering clean, affordable, and reliable electricity to approximately 12 million Floridians. With one of the nation’s cleanest power generation fleets and top-tier reliability, we are setting new standards in the energy industry. Ready to make an impact? Join our exceptional team today and help shape the future of energy!

Position Specific Description

As an SAP Supply Chain Data Analyst with Enterprise Systems, you will be responsible for the process of transforming raw data into a usable format for analysis. This role involves cleaning, organizing, and structuring data from various sources to ensure its accuracy and quality. 
You will work closely with data scientists, analysts, and other stakeholders to prepare data that supports our business objectives and analytical projects.  

You will work in various SAP environments to be used for analysis, reporting, and integration with other non-SAP enterprise systems.

Key Responsibilities:

• Data Collection: Gather raw data from multiple data sources, including databases, APIs, and external sources.
• Extract data from various SAP modules such as SAP HANA, SAP BW, SAP ECC, and SAP S/4HANA.
• Utilize tools like SAP Data Services, SAP HANA Smart Data Integration, or custom ABAP programs for data extraction.
• Data Cleaning: Identify and rectify errors, inconsistencies, and missing data to ensure data quality.
• Handle missing, duplicate, and inconsistent data arising from different SAP modules.
• Use SAP Data Services or custom scripts to automate the data cleaning process and ensure data accuracy.
• Data Structuring: Convert raw data into structured formats suitable for analysis, such as tables, databases, or dataframes.
• Data Enrichment: Integrate additional relevant information to enhance datasets and provide more context.
• Data Validation: Conduct rigorous checks to verify the accuracy and integrity of the data.
• Use Data Validation tools within SAP Data Services or custom validation scripts to verify the quality of the transformed data.
• Data Transformation: Normalize, aggregate, and transform data to meet analysis requirements, creating new variables or features as necessary.
• Handle missing, duplicate, and inconsistent data arising from different SAP modules.
• Use SAP Data Services or custom scripts to automate the data cleaning process and ensure data accuracy.
• Data Integration: Integrate SAP data with non-SAP external systems or data sources (e.g., combining SAP transactional data with CRM data).
• Leverage SAP HANA and SAP Data Services to facilitate smooth data integration across multiple platforms.
• Load prepared data into target systems such as SAP BW for reporting, data lakes for big data analysis, or BI tools like SAP BusinessObjects and SAP Analytics Cloud.
• Collaboration: Work closely with data scientists, analysts, and other team members to understand data needs and ensure data availability for analytical projects.
• Documentation: Maintain clear documentation of data wrangling procedures and transformations to ensure reproducibility and transparency.
• Continuous Improvement: Stay updated with data wrangling techniques and tools, and continuously improve data processes.

Qualifications:

• Bachelor’s degree in Data Science, Statistics, Computer Science, or a related field.
• Proven experience in data wrangling, data cleaning, and data transformation.
• Preferred experience in SAP Solutions including:
  • SAP Data Services
  • SAP HANA
  • SAP BW/4HANA
  • SAP BusinessObjects
  • SAP Cloud Platform Integration
• Proficiency in programming languages commonly used for data wrangling, such as Python or R.
• Strong knowledge of SQL for database querying and manipulation.
• Familiarity with data visualization tools (e.g., Tableau, Power BI) is a plus.
• Excellent problem-solving skills and attention to detail.
• Ability to work both independently and collaboratively in a team environment.
• Strong communication and documentation skills.