Dynamic Role-Based Dashboard

I need an end-to-end solution that lets our users open a React-based dashboard each morning and instantly see fresh, role-specific metrics.

Here is the flow I have in mind: every night a batch job connects to our SQL databases and a couple of internal APIs, pulls the required product data, and writes a clean, report-ready snapshot into a staging table (or tables) that you design. As soon as a user loads the dashboard, individual widgets fire the SQL you attach to them, read from that snapshot, then hand the results to a rendering layer that turns the numbers into the appropriate visual—bar graph, doughnut, pie chart, line graph, or whatever makes the most sense for that data point.

Each widget also checks the visitor’s role and shows or hides itself accordingly, so our sales team, ops team, and executives all see only what they should.

Frontend code already lives in React JS; you can either extend the current setup or scaffold a small demo app if that’s faster. I’m open on the charting library: Chart.js, D3.js, Plotly, or any other modern tool is fine as long as it stays lightweight, responsive, and easy to theme. Feel free to recommend what you think will scale best.

What I expect from you
• A nightly ETL script or workflow (Node, Python, or SQL Agent—your call) that runs reliably and logs failures.
• Database schema/tables aimed at fast widget reads.
• Secure API or direct queries powering each widget.
• React components for the widgets, wired to the chosen visualization library.
• Simple role-based access control hooked into our existing auth (or mocked for demo).
• Clear hand-off docs so my team can maintain the pipeline and add new widgets later.

If that sounds straightforward, tell me which stack you’d lean on for the ETL and charts, how you’d structure the role logic, and a ballpark timeline to get a working MVP in place.