Junior Data and Analytics Specialist (Remote)

Verified Job On Employer Career Site Job Summary: Media Cause is an award-winning, mission-driven marketing and creative agency that helps nonprofits grow and accelerate their impact. They are seeking a Data & Analytics Specialist to manage daily data operations, including performance dashboards and data integrity, while supporting the agency's transformation through automation and AI. This foundational role will contribute to the development of new tools and workflows that will shape the future of nonprofit marketing. Responsibilities: • Own the end-to-end management of internal and client-facing dashboards (e.g. Looker Studio, Google Sheets), ensuring they are accurate, timely, and actionable. • Pull and clean performance data from key platforms (e.g. Google Analytics 4, Google Ads, Meta Ads, HubSpot, Salesforce, GoFundMePRO, GiveLively, Fundraise Up). • Maintain and evolve our internal data infrastructure - including documentation, shared schema references, and data QA practices. • Assist with campaign reporting, URL/UTM builders, and audience/engagement analysis for our paid media, email, and fundraising teams. • Serve as the main support for data updates related to client deliverables, including recurring reports and dashboards. • Partner closely with the Director of Data Strategy to explore and implement automation, data pipeline, and AI-driven reporting solutions. • Learn and test AI tools that can improve agency workflows - particularly for data cleaning, analysis, and visualization. • Assist in the development and documentation of standardized processes to streamline and scale our agency’s data offerings. • Bring a strong learning mindset - this role is expected to evolve as the agency’s AI and data strategy matures. Qualifications: Required: • 1–3 years of hands-on experience with data analysis, marketing analytics, or reporting (agency or nonprofit experience a plus). • Proficiency with Google Sheets or Excel (advanced formulas, query statements, conditional logic, vlookup/index-match). • Experience with GA4, Looker Studio, and pulling data from marketing platforms (manual exports and connectors). • Familiarity with AI tools (e.g. ChatGPT, Google Gemini, Zapier) and how they can support workflows, analysis, or automations. • Attention to detail and a strong sense of data accuracy and QA. • Clear communicator - able to explain data trends and inconsistencies in human terms. • Interest in data storytelling and turning insights into impact. Preferred: • Familiarity with or interest in data warehouses (e.g., BigQuery), Coefficient, or Supermetrics. • Exposure to Google Tag Manager or Google Ads tracking. • Some familiarity with SQL or data transformation scripting. Company: Digital marketing meets social good Founded in 2010, the company is headquartered in San Francisco, California, USA, with a team of 51-200 employees. The company is currently Growth Stage.

#J-18808-Ljbffr