Note: The job is a remote job and is open to candidates in USA. Storm Ideas supercharges the digital presence of globally recognised US television and entertainment brands through creativity, technology, and automation. The AI-First Social Media Analyst will gather and analyse social media performance data, create client-facing reports and recommendations, and build AI-assisted workflows to automate reporting tasks. The role also requires rigorous verification of AI output and documentation of workflows for broader team use.
Responsibilities
- Contributing to a variety of client-facing insights reports
- Gathering and analysing performance data from social media networks, in accordance with our processes
- Developing a mastery of a variety of analytics tools, including Sprinklr, Sprout Social, Meta Business Suite and YouTube Studio
- Building AI-assisted workflows that take reporting tasks from hours to minutes — data cleaning, first-pass analysis, chart generation, draft narratives, QA checks
- Using LLMs (Claude, ChatGPT and similar) as an analytical partner — interrogating datasets, pressure-testing your own conclusions, generating and discarding hypotheses fast
- Rigorously verifying AI output before it reaches a client — checking numbers against source, catching confident-but-wrong claims, knowing where these tools are unreliable
- Creating visually appealing and consistently designed reports and presentations
- Generating content and strategy recommendations from data analysis of our clients' social accounts
- Compiling those recommendations into a written format to be shared with external stakeholders
- Turning what you build into something the whole team can use — documenting prompts, workflows and automations so they become team assets rather than personal shortcuts
- Continuously looking for areas of improvement and working with the team to improve the overall quality of our reports and provide more value to our clients
- Updating and maintaining documentation on our reporting processes
- Following client and competitor accounts on social media to better understand effective social media strategy
Skills
- Excellent numeracy skills and ability to analyse data quantitatively and qualitatively
- Genuine hands-on experience using AI tools in real work — not just awareness of them. Tell us what you've built, automated or sped up, and what didn't work
- Healthy scepticism — you can spot when a model is confidently wrong, and you check before you send
- Strong Excel and PowerPoint skills
- Excellent written and communication skills
- Unparalleled attention to detail
- Ability to prioritise workload and complete tasks to deadlines
- Experience in creating and executing on social media performance reports
- Experience with 3rd party social analytics tools, such as Sprout Social, Sprinklr, Social Insider
- Experience with the social networks' native analytics tools, such as Facebook Creator Studio, YouTube Studio, TikTok Analytics
- Light scripting ability (Python, SQL, Apps Script) — or the confidence to get there with AI assistance
- Experience with automation tooling (Zapier, Make, n8n) or agentic AI tools (Claude Code, Cursor, custom GPTs)
- A side project, script or workflow you built because something annoyed you
- Social media experience is a plus, but not a necessity if you're interested in learning about the industry
Benefits
- Fully remote working from anywhere in Egypt
- 33 Days Paid Leave and Benefits
- Work with modern hardware, social publishing tools, productivity systems, and AI-enabled workflows
- Latest hardware and software — Windows or Mac
- Paid access to frontier AI tools
- Freedom to experiment with new AI tools
- Flexible working arrangements with start times from 8am GMT and end times up to 7pm GMT
Company Overview