Data Analyst Intern

E2 Consulting Engineers, LP•San Diego, CA

About The Position

E2 Consulting Engineers, LP is seeking a Data Analyst Intern to partner with a client in designing, developing, and implementing scalable data analytics solutions. The intern will help turn raw data into actionable insights that support business decisions and contribute to the development and management of the client’s data systems, including data ingestion and warehousing, automation, modeling, machine learning, and business intelligence tools. The role is suited to someone with experience or interest in data mining, data transformation, data visualization, problem-solving, and communicating findings.

Requirements

Currently hold an associate degree and be pursuing a bachelor's degree in Data Science, Data Analytics, Statistics, Computer Science, Economics, Business Information Systems, or a related quantitative field.
Proficiency in SQL for querying relational databases.
Working knowledge of Python or R for data manipulation and analysis.
Experience with business intelligence and visualization tools such as Power BI, Tableau, Sigma, or Looker.
Advanced Microsoft Excel skills, including Pivot Tables, VLOOKUP/XLOOKUP, and data modeling.
Strong problem-solving abilities, attention to detail, and an interest in turning messy data into a coherent narrative.
Ability to explain technical findings clearly to non-technical stakeholders in spoken and written formats.

Responsibilities

Write and optimize SQL queries to extract, clean, and transform data from large databases, data marts, or cloud warehouses.
Design, build, and maintain interactive business intelligence dashboards and reports using tools such as Power BI, Tableau, or Mode.
Perform routine data checks to ensure accuracy, consistency, and integrity across metrics and reporting pipelines.
Investigate open-ended operational questions, analyze trends such as customer demand, process efficiency, or financial metrics, and present clear visual summaries to team leads.
Assist in automating manual reporting workflows and spreadsheets using Python, Excel features such as Power Query and Pivot Tables, or basic scripting.