BI Developer / Analytics Engineer

Creative and marketing teams request a real-time, unified view of social platform campaign performance across global offices. Solution should be genuinely appreciable to an audience predominately made up of creatives. The final asset will be partly an educational tool, partly interactive, self-serve dashboard. 

To support consistent decision-making across national offices, the corporation requires a centralized reporting platform that serves as a single source of truth. The solution provides flexible segmentation by region, line of business, and date range, and dynamically narrates tailored action steps for management and agents based on their selections. 

Leadership and financial stakeholders need a clear, trusted view of gross revenue performance by fund, date, and team/department. The solution should allow the ability to investigate the underlying transactions and reduce reliance on analysts.

Foundation requires a high-level, 6-year historical perspective on revenue performance to support long-range planning. The solution will reduce analyst bottlenecking by giving stakeholders direct, self-service access to historical performance metrics organization-wide or segmented by team.

The Monthly Donor program needs a predictable view of performance, donor lifetime value, and retention rates. Stakeholders can identify churn patterns and track long-term growth targets without external calculations or spreadsheets.