Full-Stack Sales Management & Data Analytics Web Application Development

We are seeking an experienced full-stack developer to build a comprehensive Sales Management and Data Analytics web application. The application will feature a modern, responsive user interface and robust backend logic, integrating with advanced data platforms for analytics and reporting.

Frontend Requirements:
Develop a modern, responsive user interface using html, css, and javascript. The UI must include interactive dashboards, dynamic charts, efficient search and filtering capabilities, user-friendly forms, and data tables for various records.

Backend Requirements:
Implement the application logic, routing, and REST APIs using Python and the Flask framework. The backend will handle secure user authentication, data validation, and standard CRUD (Create, Read, Update, Delete) operations for all data entities.

Database Management:
Design and implement a relational database using either MySQL or SQLite to manage core business data, including customers, products, orders, user accounts, and sales transactions.

Microsoft Fabric Integration:
Integrate a Fabric Lakehouse for centralized analytical data storage. The solution must utilize supported connectors and secure data access methods to efficiently retrieve and process sales data for analytical purposes. Data synchronization between the operational database and the Fabric Lakehouse should be established using suitable data pipelines.

Power BI Reporting:
Develop and integrate interactive Power BI reports directly into the web application. These reports should display key sales metrics such as total revenue, profit margins, units sold, monthly sales trends, regional performance analysis, and identification of top-selling products.

Power Apps Interface:
Provide an additional interface using Power Apps for viewing, searching, and managing sales records. This interface should leverage appropriate connectors, permissions, and licensing to ensure seamless operation.

Key Features to Implement:
1. Secure user registration and login functionality.
2. An intuitive dashboard featuring key performance indicator (KPI) cards and interactive charts.
3. Comprehensive management modules for products, customers, orders, and sales.
4. Full CRUD operations (Add, View, Edit, Delete) along with advanced search, sort, and filter functionalities for all records.
5. Capability to import and export data in CSV or Excel file formats.
6. Seamless integration of Power BI reports within the main web application.
7. Robust data pipelines for synchronizing operational database data with the Fabric Lakehouse.
8. Implementation of role-based access control, thorough data validation, and effective error handling mechanisms.
9. A fully responsive design ensuring optimal user experience across desktop, tablet, and mobile devices.
10. Provision of sample data, sql database schema, clear api endpoint documentation, and detailed deployment instructions.