- Reporting & Dashboard Development: Develop dashboards that present KPIs for procurement, finance, and other areas of the business (e.g: Power BI)
- Data Modeling for reporting: Ability to design data models that are optimized for reporting, including knowledge of star and snowflake schema design. Power BI (data modeling within Power Query), or SQL-based modeling in Databricks or Azure Synapse (if used).
- Data Lake and Delta Lake: Familiarity with querying and working with Delta Lake tables, including performance considerations.
- Power BI service for scheduled refreshes, Azure Data Factory for orchestrating data refreshes.
- In-depth knowledge of D365 F&O modules relevant to procurement and finance.