Intern Automotive Data Analyst Jobs in Ohio (NOW HIRING)

TransTech Group

Internship – Business Data Analyst, AI & Fabric

Position Title: Internship – Business Data Analyst, AI & Fabric

Reports To: Manager of Business Analysis and Process

Location: Chagrin Falls, OH (Hybrid)

Hours: 32 hours/week

Compensation: Paid internship

Company Overview

TransTech is a leading provider of specialized infrastructure and custom-engineered equipment for diverse industries. Our expansive capacity and technical expertise enable large-scale production of complex, high-quality equipment while meeting rigorous quality and safety standards.

TransTech’s companies provide comprehensive solutions for gas and liquid processing, storage, transfer, and utilization, adhering to ASME, API, and TEMA standards to ensure reliability and precision in every project.

From individual services to full project solutions, TransTech’s teams deliver expert engineering, fabrication, construction, operations and maintenance, supporting projects nationally and internationally. We help customers achieve impactful, sustainable results with a commitment to safety, community, and environmental responsibility.

Job Summary

TransTech is seeking a Business Data Analyst Intern to support reporting, analytics, automation, and emerging AI initiatives in our Microsoft Fabric environment. With core business data now centralized in Fabric, this role will help turn that data into useful reporting, insights, and scalable business solutions.

The intern will work closely with the Manager of Business Analysis and Process and the Business Data Analyst, collaborating with both business and technical teams. You'll support Power BI reporting, help validate and organize data, assist with automation opportunities, and contribute to early AI-related projects — hands-on experience with modern enterprise analytics tools in a manufacturing and engineering environment.

What You'll Gain

• Hands-on experience working in a live Microsoft Fabric and Power BI environment
• Exposure to real business reporting and analytics across Finance, Operations, Supply Chain, and Project Management
• Direct experience supporting data quality, automation, and emerging AI initiatives
• The chance to contribute to meaningful business solutions in a manufacturing and engineering setting
• Practical, cross-functional experience as part of a broader digital transformation effort
• Mentorship from a Manager of Business Analysis and Process and a Business Data Analyst

Key Responsibilities

Reporting and Analytics Support

• Assist in developing, updating, and maintaining Power BI dashboards and reports for business users.
• Support reporting and analysis across Finance, Operations, Supply Chain, Project Management, and other functions.
• Help users validate report outputs and confirm that business requirements are met.
• Assist with recurring reporting, KPI tracking, and ad hoc analysis to support decision-making.

Microsoft Fabric Support

• Work with curated data already available in Microsoft Fabric to support reporting and analysis needs.
• Assist with organizing and maintaining Fabric assets such as semantic models, dataflows, reports, and related objects.
• Help validate data accuracy, consistency, and usability for business reporting.
• Support documentation of data definitions, report logic, and business rules used within the Fabric environment.

Data Quality and Business Support

• Help identify data issues, missing values, inconsistencies, and opportunities to improve reporting reliability.
• Assist in reconciling data across business processes and reports.
• Support meetings with business users to understand reporting needs and follow up with analysis.
• Help document metrics, requirements, and process improvements related to analytics initiatives.

Automation and AI Support

• Assist with business process improvement opportunities that use Power Automate, reporting workflows, or AI-enabled solutions.
• Support early AI use cases by helping organize source data, document needs, and participate in testing.
• Assist with document-based or workflow-based pilot efforts where AI may help improve efficiency or reduce manual effort.
• Work with internal teams and external partners to support implementation and testing of new analytics and AI solutions.

General Analytics Support

• Help answer business questions using Excel, SQL, Power BI, or Fabric-based datasets.
• Assist with special projects related to digital transformation, enterprise reporting, and operational analytics.
• Contribute to a growing data and AI program by supporting both day-to-day reporting needs and longer-term capability building.

Preferred Qualifications

• Familiarity with Excel, Power BI, SQL, Python, or other data analysis tools.
• Strong attention to detail and interest in business data, reporting, and process improvement.
• Exposure to Microsoft Fabric, Power Platform, SharePoint, or related Microsoft technologies is a plus.
• Curious, detail-oriented, and eager to learn about data systems in a real-world business setting.

Education / Experience

• Currently pursuing a Bachelor's degree in Data Analytics, Information Systems, Computer Science, Business, Finance, Engineering, or a related field.

This organization provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

#TTE