Data Analytics Intern

About ACS Consulting Group:

Our practices cover strategy, operations, technology implementation, risk and human capital. We work with Fortune 500 companies, federal agencies and large health systems.

The internship:

ACS Consulting Group needs a data analytics intern to build reports and dashboards for the Revenue Operations team. Our team is spread across 9 countries. Headquarters is in New York City. The internship is fully remote. Interns join our New York City team on daily calls and get a named mentor. You will need at least 4 hours of overlap with US Eastern time.

Responsibilities:

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Maintain the data dictionary and keep dashboard filters up to date.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Create charts and short slide decks for the monthly review call.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.

Who can apply:

• Final-year students or fresh graduates of BSCS, BSSE, BBA or a related program.
• Available for at least 30 hours a week, work from home.
• Based anywhere in Pakistan.
• Clear written English for reports and status updates.
• Available 20 to 40 hours a week, Monday to Friday.
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2026, 2027 or 2028.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• A sample dashboard or analysis project you can share.

Preferred:

• Python with pandas for data cleaning.

What you get out of it:

• Writing SQL against a real production warehouse.
• Certificate, letter of recommendation and flexible hours.
• You will build at least one dashboard that managers use every week.

Duration: 3 months

Start date: Within 2 weeks

Stipend: $250-$350 monthly

Perks:

• Informal dress code.
• Letter of recommendation.
• Pre-placement offer (PPO) for strong performers.
• Laptop provided for the internship.
• Internet allowance.

We look at every application, usually within a week.

Duration: 3 months. Start: Within 2 weeks.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at ACS Consulting Group Inc..