Data Analyst Intern

E2 Consulting Engineers, LP is seeking a Data Analyst Intern to partner with its client on designing, developing, and implementing scalable data analytics solutions. The role supports the client’s data systems, including data ingestion and warehousing, automation, modeling, machine learning, and business intelligence, to deliver actionable insights for business decisions.

Responsibilities:

• Data Extraction & Cleaning: Write and optimize SQL queries to pull, clean, and transform data from large databases, data marts, or cloud warehouses
• Dashboard & Reporting Development: Design, build, and maintain interactive business intelligence dashboards and reports using tools like Power BI, Tableau, or Mode
• Data Validation & Quality: Perform routine data checks to ensure accuracy, consistency, and integrity across metrics and reporting pipelines
• Ad-Hoc Analysis & Storytelling: Investigate open-ended operational questions, analyze trends (customer demand, process efficiency, or financial metrics), and present clear visual summaries to team leads
• Process Automation: Assist in automating manual reporting workflows and spreadsheets using Python, Excel (Power Query/Pivot Tables), or basic scripting

Requirements:

• the right person for this role has a strong background in data mining/data transformation/data visualization
• Currently holds a Associates and is pursuing a Bachelor's 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 BI and visualization tools (e.g., Power BI, Tableau, Sigma, or Looker)
• Advanced Microsoft Excel skills (Pivot Tables, VLOOKUP/XLOOKUP, data modeling)
• Strong problem-solving abilities with a keen attention to detail and a passion for turning messy data into a coherent narrative
• Ability to explain technical findings clearly to non-technical stakeholders in spoken and written formats