(1) Vendor needs to provide microsoft fabric implementation consulting service.– Provide consulting and mentoring services to assist in the design, setup, and implementation of a microsoft fabric–based data warehouse and lake environment. – Environment setup assist with the design and configuration of a Microsoft fabric environment aligned with agency data governance, security, and performance standards. – Co–develop a metadata–driven extract, transform, and load (ETL) framework for ingesting on–premises and application programming interface (API) based data sources into fabric that is scalable to other sources. – Integration demonstration provide a working demonstration of API –based data ingestion and integration with fabric components within our medallion architecture.