Business Intelligence Intern

About us

Since 1929, the agency has added data science, analytics and in-house production teams. Our clients include consumer packaged goods companies, health systems, automakers and retailers. Timesheets are due daily, broken out by client and task.

The internship

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Remote, open to candidates across Egypt. Normal working hours, Monday to Friday. A quiet workspace and good internet are required.

Responsibilities

Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery. Answer ad hoc data requests from sales and support within a day or two. Track marketing campaign results using Google Analytics 4 data. Check numbers across sources and flag mismatches before reports go out. Document metric definitions so everyone calculates churn and conversion the same way. Create charts and short slide decks for the monthly review call. Prepare the weekly MIS report and send it to the team lead every Monday. Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.

What we're looking for

Eligible to work in Egypt. Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028. Based in Egypt for the duration of the internship. Available for the full internship period. Comfort with numbers and strong attention to detail. Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2027 or 2028. Available 20 to 40 hours a week, Monday to Friday. Must be able to follow up on data requests without constant reminders. Good Excel skills: pivot tables, lookups, conditional formatting and basic charts. Clear written English for reports and status updates.

Bonus points

Familiarity with DAX in Power BI. Experience with Google Analytics 4 or Mixpanel. Prior project with real business data from a college club, family business or freelance client.

Duration: 6 months

Start date: Mar 2027

Stipend: EGP 7,200 to EGP 9,200 per month

Perks

Possibility of a full-time offer. Internet allowance. Mentorship.

Duration: 6 months. Start: Mar 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Abdelhamid Marketing LLC.