Role & responsibilities
- Data Extraction & Architecture: Write, optimize, and maintain complex SQL queries, Common Table Expressions (CTEs), and window functions to extract and manipulate large datasets from corporate data warehouses.
- Analytics & Workflow Automation: Develop and deploy Python scripts to automate repetitive data extraction processes. Set up and manage cron jobs to schedule automated data pipeline runs and ensure daily Google Sheets and Excel reports are refreshed reliably.
- Power BI Reporting & Visualization: Design, develop, and maintain interactive Power BI dashboards and reports to translate complex financial and operational data into actionable insights for stakeholders.
- Insight Delivery & Presentations:
Translate intricate technical data findings into executive-ready dashboards, operational reports, and clear, compelling PowerPoint (PPT) slide decks to deliver actionable business recommendations to stakeholders.
- Advanced Modeling: Architect high-performance, agile financial and operational models in both Microsoft Excel and Google Sheets utilizing advanced logic, array formulas, and automated scripts.
- Ad-Hoc & Routine Operations: Manage daily data operations, fulfill ad-hoc data requests, and execute other routine operational works to support cross-functional teams in their day-to-day decision-making.