Business Analyst Intern

Who we are:

No call center and no offshore help desk. When clients call, one of us picks up. Every tech does a bit of everything, from printer jams to firewall rules. Our dress code is a company polo and clean jeans.

About the role:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. This role is fully remote within the US.

What you'll do:

Document metric definitions so everyone calculates churn and conversion the same way. Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query. Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery. Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables. Track marketing campaign results using Google Analytics 4 data. Analyse funnel drop-offs and summarise findings in a one-page note. Maintain the data dictionary and keep dashboard filters up to date.

What we're looking for:

Available 40 hours a week for the full internship. Currently enrolled in a bachelor's or master's program, graduating 2027 or 2028. Authorized to work in the US. CPT and OPT candidates are welcome to apply. Based in the US for the duration of the internship. Comfort with numbers and strong attention to detail. Available 20 to 40 hours a week, Monday to Friday. Laptop with Excel or Google Sheets and a stable internet connection.

Preferred:

Google Data Analytics or Microsoft PL-300 certification. Python with pandas for data cleaning.

Duration: 12 weeks

Start date: June 2027

Stipend: $28.50 - $29.50 per hour

Perks:

Flexible hours. Home office setup stipend. Learning and development stipend.

Interview process: a phone call, a meeting with the hiring manager, and a final conversation with the team.

Duration: 12 weeks. Start: June 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Gonzalez Tech Support.