Data Analyst Intern

About the Organization E2 Consulting Engineers, LP (E2) is a professional services firm established in 1988 specializing in a full spectrum of engineering services including, project engineering and design, federal base operations and infrastructure support services, gas pipeline construction and inspection services, environmental consulting and remediation, and information technology services. At E2, we value safety, innovation and collaboration, and we are dedicated to excellence. Overview 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 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. 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. Work Environment/Physical Demands Work Environment This job operates in a professional office environment and uses standard office equipment such as computers and phones. Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Ability to sit/ stand for up to 8 hours per day. Ability to move freely for up to 8 hours per day. Local Candidates only No Drug Free Workplace E2 Consulting Engineers, LP is a Drug Free Workplace. After accepting an offer of employment, applicants may be required to undergo background checks, drug testing, and/or fit-for-duty physical examination. Drug screens will include, but not be limited to, Amphetamines, Cocaine Metabolites, Marijuana Metabolites (THC), Opiates, and Phencyclidine (PCP). As a federal contractor, E2 cannot permit employees in certain positions to use medical marijuana, even if prescribed by an authorized physician. Solicitation Please no solicitation of any kind from agencies, staffing, or recruiting firms. EEO Statement All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.