Data and Analytics Analyst

We are looking for candidate with knowledge on Azure data Engneer, Data lake with Dynamics 365 F&O • Analyse and reconcile large data sets sourced from Dynamics 365 F&O and other finance and operational systems hosted in Azure Data Lake (Medallion architecture). • Develop and optimise SQL queries to support financial and asset reporting. • Deliver analysis on: o Stock provisioning and impairments o Asset WIP and capitalisation o Year-end cost allocations, missing stock, and Fixed Asset Register analytics o Reporting and reconciliation on the Fixed Asset Register (FAR) • Present findings in concise, executive-ready summaries, highlighting key insights and data-backed recommendations. • Collaborate with finance and asset teams to enhance data accuracy and streamline manual Excel-based processes. Deliverables: 1. Automated SQL-based data extracts for stock and asset reporting. 2. Reconciliation reports for stock provisioning, WIP, and FAR. 3. Year-end analytics pack (cost allocations, missing stock, impairments). 4. Documentation of key SQL queries and analytical logic for knowledge transfer. Executive summary report with recommendations for process automation or data improvements • Strong SQL and Excel capability; experience with Azure Data Lake tools. • Working knowledge of Dynamics 365 F&O data structures. • Proven ability to communicate analytical findings through concise, actionable executive summaries. • Experience in utilities, smart metering, or telecommunications preferred.