Strategic Data Analyst — CEO Dashboard; Remote

ROLE

Do you love taking raw data, turning it into objective data and drawing business conclusions from it that actually affect the bottom line?

Do you like building reports, models, and analysis that support the day to day decisions of a company?

If so, you might be exactly who we are looking for.

This is a new position where you will work directly with the CEO & other executives in our advertising agency.

This individual in this unique position will learn about the inner workings of the Company and will become a provider of crucial information to help guide the company & its clients.
The ideal candidate will not simply be a “number cruncher” but one who both wants to gain operational exposure and can think strategically beyond the basic work that needs to get done.
Intellectual curiosity, analytical thinking, and a great attitude are keys to success in this role.

Here’s some of the departments you will be working with to provide quant based analysis:

• Finance
• Operations
• Sales
• Marketing
• Creative

This is a critical hire for the company, as this role will be accountable for helping to deliver on our company's revenue growth objectives.

This position will require someone who understands how to navigate a start-up environment, work with CEOs & founders, build relationships and maintain consistency across multiple departments.

• Collect, analyze, and interpret large datasets from multiple departments (Finance, Operations, Sales, Marketing, and Creative) to drive decision-making and strategic planning.
• Design reports to track financial metrics as well as operational metrics
• Create analyses using disparate data sources and large volumes of detailed data, often starting from scratch
• Translate the results of an analysis into easily understood presentation quality materials
• Provide input through business modeling and pro forma analysis to support strategic decision-making in day-to-day operations and new programs
• Proactively identify and evaluate strategic and operational opportunities and provide recommendations for potential solutions to CEO & other leadership members
• Provide regular reporting and analysis on key sales and marketing metrics, including Hub Spot analytics, trends, etc.
• Perform exploratory data analyses that helps the company better understand the customer and present findings to both technical and non-technical audiences
• Assist in forecasting revenue growth, financial planning, and resource allocation.
• Support client reporting with relevant KPIs, campaign results, and data-driven recommendations.
• Opportunity to influence strategic decisions and drive measurable improvements in company performance.

• Identify and propose at least 5 new data-driven optimization opportunities per quarter that contribute to revenue growth or operational efficiency.
• The data analyst should identify and propose at least 5 new data-driven optimization opportunities per quarter that contribute significantly to revenue growth or operational efficiency.
• This outcome underscores the analyst's strategic role in analyzing data beyond basic reporting to actively support initiatives that drive profitability and productivity improvements.
• Develop and maintain an automated 'CEO Dashboard' covering 95% of key business and departmental KPIs, updated daily, enabling a 15% reduction in time spent on manual report reviews monthly.
• Build and maintain an automated 'CEO Dashboard' that consolidates and displays major success KPIs for the entire business and each department.
• Ensure the dashboard is updated in real-time or on a daily basis and provides a comprehensive overview of company performance. The dashboard should cover at least 95% of all relevant KPIs, including revenue, client performance, operational efficiency, and key…