About the position Midtronics is seeking a Data & AI Engineer Intern to join their Data Analytics & AI team. This role involves building AI-powered tools, managing enterprise data, designing dashboards, and collaborating with business stakeholders. The intern will work on real projects, not just prototypes, and will have the opportunity to ship impactful solutions. The position requires a blend of technical and creative skills to translate ambiguous business problems into working solutions.

Responsibilities

• Design, develop, and deploy AI-powered tools and agents using LLM APIs (Anthropic Claude, OpenAI) with structured tool-use patterns.
• Build retrieval-augmented generation (RAG) pipelines, prompt engineering workflows, and evaluation frameworks.
• Integrate AI capabilities into existing business processes such as sales forecasting, trip reporting, and document generation.
• Stay current on AI tooling and bring new ideas to the team about where AI can create real leverage.
• Build and maintain data pipelines connecting enterprise systems (Smartsheet, Epicor ERP, SharePoint, JIRA, GitHub) into unified, queryable data sets.
• Perform exploratory and diagnostic analysis on sales, operations, and product data to surface actionable insights.
• Own data quality: identify gaps, reconcile conflicting sources, and build automated validation checks.
• Work with SQL, Python (pandas, NumPy), and APIs to extract, transform, and load data at scale.
• Build and maintain interactive Power BI dashboards for sales performance, pipeline health, and operational KPIs.
• Design data visualizations that tell a clear story and drive decisions, not just display numbers.
• Create self-service reporting tools that empower stakeholders to explore data without hand-holding.
• Develop HTML-based interactive dashboards and artifacts when Power BI isn't the right fit.
• Partner directly with Sales, Marketing, Engineering, and leadership to understand their real problems (not just their data requests).
• Translate vague asks like 'we need better visibility into the pipeline' into concrete, scoped deliverables.
• Present findings and recommendations to non-technical stakeholders in a way that's clear, concise, and actionable.
• Bring a creative, 80/20 mindset: find the fastest path to a useful answer before over-engineering.

Requirements

• Proficiency in Python or Node.js for scripting, automation, and building tools.
• Hands-on experience with Power BI (DAX, data modeling, report design) or equivalent BI tools.
• Strong SQL skills and experience working with relational databases or structured data sources.
• Demonstrated ability to work with APIs and integrate data across multiple systems.
• Clear, effective communication skills with both technical and non-technical audiences.
• A portfolio, GitHub, or track record of things you've built that you're proud of.

Nice-to-haves

• Experience building applications or automations using LLM APIs (Claude, OpenAI, etc.).
• Familiarity with cloud platforms (Azure preferred), CI/CD, and version control (Git).
• Experience with Smartsheet, Epicor, or other enterprise SaaS/ERP platforms.
• Background in manufacturing, automotive, or B2B enterprise environments.
• An eye for design and UX, whether that's a dashboard layout, a slide deck, or a data visualization.
• Comfort with ambiguity and a bias toward action over perfection.

Benefits

• Hybrid environment that values output over hours