AI-Driven Data Analytics Intern (Power BI & SQL)

ITT Inc. - English US; Irvine (CA); On-site; USD 39,000 - 45,000; Full time

Benefits offered by this job

Health insurance

Job summary

ITT Inc. in Irvine, CA is offering a Data Analytics / AI Intern position for Summer 2027. The role focuses on building BI solutions, gathering requirements, and turning data into actionable insights. The intern will work with IT, engineering, and operations to improve reporting and data quality.

The ideal candidate is pursuing CS/IT/Analytics, with beginner Power BI/Tableau and Power Automate skills, plus some SQL knowledge and ERP exposure. This is a 40-hour/week summer internship.

Qualifications

• Currently enrolled in Computer Science, Information Technology, Information Systems, Analytics in good standing.
• Knowledge of basic Power BI (or Tableau) and Power Automate.
• Foundational knowledge of SQL preferred but not mandatory.
• Previous ERP knowledge and navigational ability a plus.

Responsibilities

• Support the development, enhancement, and maintenance of Power BI dashboards and recurring analytics reports.
• Gather and document business requirements by collaborating with IT, engineering, operations, and business stakeholders.
• Analyze and interpret data from various enterprise data sources to identify trends and generate actionable insights.
• Validate report logic, data accuracy, and dashboard functionality with business users.
• Review existing reporting processes in legacy Excel / MS Access and identify opportunities to improve efficiency, data quality, and automation.
• Assist with transforming manual reports and ad hoc data requests into standardized, repeatable dashboards and reporting solutions.
• Ability to understand data architectures for relational databases in different systems, primarily ERPs.
• Ability to leverage AI solutions to develop, maintain, or complement dashboard creation or functional specification creation.
• Support the development of AI-assisted prototypes and practical automation solutions for knowledge search, service analytics, and operational reporting.
• Document data sources, business requirements, reporting processes, governance considerations, and recommended next steps.
• Maintain a prioritized backlog of analytics and AI opportunities based on business value and data readiness.
• Present project outcomes, key findings, and recommendations to IT and business stakeholders at the conclusion of the internship.

Skills

Power BI

Power Automate

SQL

Education

Currently enrolled in Computer Science or IT/Analytics

Tools

ERP systems

Job description

ITT Inc. in Irvine, CA is offering a Data Analytics / AI Intern position for Summer 2027. The role focuses on building BI solutions, gathering requirements, and turning data into actionable insights. The intern will work with IT, engineering, and operations to improve reporting and data quality.

The ideal candidate is pursuing CS/IT/Analytics, with beginner Power BI/Tableau and Power Automate skills, plus some SQL knowledge and ERP exposure. This is a 40-hour/week summer internship.