Functional BSA/ Data Analyst
Location Toronto ON/Hybrid
Contract
Description:
-
Finance Sales & operations Data Analysis SAP
-
Gather and document business requirements for Finance and Operations reporting ensuring clarity on KPIs metrics and key data elements.
-
Build requirement documents and transformation logic to guide development teams with a focus on data accuracy and lineage.
-
Create mock-ups and sample reports to validate reporting needs with stakeholders before implementation.
-
Collaborate with Finance Operations and technical teams to translate requirements into actionable reporting solutions.
-
Support user acceptance testing and maintain KPI definitions/documentation for long-term governance and consistency.
-
Data analyst should go into the data by him/herself and understand data patterns (KPI metrics etc.) Able to do data analysis using SQL/excel identify the joins logics etc. for the development team to work upon. Create data mapping documents source to target (source table. Column)
-
Understand BI tool such as Power BI and able to define KPIs understand what is expected by the developer and accordingly provide them the data source they need in the requirement/mapping document.
-
Validate the report by jumping into various data sources run SQL understand whats mentioned in the DAX expression and verify the logic.
-
SAP knowledge or in past worked on SAP projects (good to have BW/BO knowledge)