Sr. Associate, Business Intelligence Analyst/Developer

About Rocket Clicks

Mission

Accelerate growth for innovative businesses through CMO-level revenue strategies.

Vision

Legacy & Impact

• 1,000 Revenue Barriers Surpassed
  
  

Culture & Team

• 1,000 PPF Goals Achieved
  
  

Financial Outcome

• $35MM in Revenue at 20% EBITDA
  
  

Values

Belief

• Proactive - We create change rather than reacting to it. We anticipate future opportunities and act to address them in advance.
• Disciplined - We stay committed to our tasks and goals, not straying despite difficulties or temptations.
  
  

Operational Effectiveness

• Candid - We communicate directly and transparently, without being overly concerned with diplomacy or avoiding offense.
• Empathetic - We strive to understand and share the feelings of others, with their perspectives as the lens for our interaction.
  
  

Leadership

• Accountable - We hold ourselves responsible for the outcomes of our decisions and accept the consequences of our actions.
• Results-Oriented - We start with the end in mind. We prioritize efforts that lead to measurable outcomes, emphasizing productivity rather than busyness.
  
  

The Ideal Candidate

We are seeking a highly analytical and detail-oriented Business Intelligence (BI) Analyst to join our dynamic digital marketing agency. This role is ideal for someone passionate about using data to drive decision-making in the fast-paced digital marketing world, offering the opportunity to collaborate on high-impact marketing initiatives for a wide range of clients.

Position Summary

The Sr. Associate Business Intelligence (BI) Analyst is responsible for transforming complex data into actionable insights to guide our clients' marketing strategies and improve overall campaign performance. In this role, you will work closely with various teams, to analyze data from multiple sources, including Google Analytics, Google Ads, social media platforms, and CRM systems. You will develop intuitive dashboards, automate reporting processes, and create compelling visualizations that highlight key performance indicators (KPIs), helping stakeholders make data-driven decisions.

Objectives

• Develop and maintain interactive dashboards, ensuring stakeholders have real-time insights.
• Collect, analyze, and interpret data from digital marketing platforms (e.g., Google Analytics, Google Ads, Facebook Insights) to track campaign performance.
• Automate reporting processes to streamline data collection and distribution across multiple departments.
• Collaborate with marketing and client services teams to define KPIs and provide insights that optimize campaign strategies.
• Ensure data quality and integrity by validating and cleaning data before analysis.
• Conduct ad-hoc analysis to uncover trends, opportunities, and insights that drive marketing effectiveness.
  
  

Competencies

• Knack for “figuring it out” when taking on new tasks or processes
• Strong desire to grow and learn more, highly coachable
• Technically savvy, able to understand how systems work and interact quickly
• Proficiency in SQL, Google Analytics, Google Tag Manager, Excel/Sheets, and BI tools.
• Strong understanding of digital marketing metrics and performance tracking.
• Excellent problem-solving skills and the ability to communicate complex data insights.
• Reporting against defined performance KPI standards
• Setting up conversion tracking for digital analytics and ad pixels
• Experience with Paid Search platforms (Google Ads, Microsoft Ads)
• Experience with Paid Social platforms (Meta Ads, LinkedIn Ads, TikTok Ads)
• Experience with Python or R is a plus.
  
  

Education & Experience

• 4-year college degree or equivalent experiential knowledge
• Prior experience working in a professional services organization
• 0-3 years professional experience in digital marketing
  
  

Physical Requirements

• Prolonged periods sitting at a desk and working
  
  

Benefits

• 10 Paid Vacation Days, 5 Paid Sick Days
• 10 Paid Company Holidays
• Maternity, Paternity, Bereavement Leave
• Performance Bonus Plan