[Hiring] Data Analyst Intern @E2 Consulting Engineers, LP

Role Description

E2 is seeking a Data Analyst Intern to join our team and partner with our client to design, develop, and implement highly functional and scalable data analytics solutions. The successful candidate will thrive on delivering actionable insights from raw data, helping drive key business decisions. The right person for this role has a strong background in data mining/data transformation/data visualization, loves problem-solving, and is a great communicator. This position will support the full-scale development and management of the client’s data systems including data ingestion/warehousing, automation, modeling, machine learning, and business intelligence tools.

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.

Qualifications

• Education:
  • Currently holds an Associates and is pursuing a Bachelor's in Data Science, Data Analytics, Statistics, Computer Science, Economics, Business Information Systems, or a related quantitative field.
• Technical Skills:
  • 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).
• Analytical Mindset:
  • Strong problem-solving abilities with a keen attention to detail and a passion for turning messy data into a coherent narrative.
• Communication Skills:
  • Ability to explain technical findings clearly to non-technical stakeholders in spoken and written formats.

Benefits

• E2 Consulting Engineers, LP offers a 401(k) with employer match and paid time off.