Looking for advanced excel dashboard developer on a freelance capacity for a current projects starting in the coming weeks.

CORE COMPETENCY:

Advanced Excel with a strong focus on Data Modeling and Dashboard Design.

KEY SKILLS:

Data normalization, weighted ranking formulas, advanced lookups (XLOOKUP, INDEX/MATCH), nested logic (IF/AND/OR), agile PivotTables, and interactive dashboard creation using slicers.

TASKS:

- Data Architecture: Knowing how to structure raw site and investigator data so it can scale without breaking.
- Relational Logic: Using complex lookups (XLOOKUP or INDEX/MATCH) to link different data tables (e.g., combining site activation dates, enrollment numbers, and data entry compliance).
- Weighted Scoring Models: Building formulas that calculate multi-point activity ranks based on custom weights (e.g., enrollment speed counts for 40%, data quality for 30%).
- Dashboard Design: Translating raw site metrics into clean, interactive pivot tables and executive-level summaries.

📌 FREELANCE: Excel Data Analyst / Dashboard Developer (Australia)
🏢 Hummingbird Insight
📍 Australia