AI Intern

Role Overview

• Work with on premise and cloud-based solutions and platforms
• Assist in the development and implementation of AI models and algorithms to solve real-world logistics and transportation challenges
• Collaborate with cross-functional teams to integrate generative AI and LLM capabilities into existing systems and workflows
• Analyze and document data requirements including facilitation of sessions with business
• Data analysis and profiling
• Collaborate with the technical team, in any given product development cycle, on data and AI requirements
• ETL source to target documentation including business matrix and functional requirements
• Develop and test data ingestion and integration processes
• Troubleshoot data ingestion, ETL and data issues
• Design and develop machine learning models, interactive visual dashboards, and reports
• Ability to write SQL queries to profile data and validate solutions delivered against data sources
• SQL troubleshooting
• Develop and test scripts to support ETL jobs execution
• Understand that the end user is the primary reason for the technology and therefore strive for full customer satisfaction
• Partner with key members of various departments to determine the definitions of essential data elements
• Work with data architects to review and implement logical and physical database models
• Support the mapping of source system data to target models into data warehouse and data lake
• Define and capture metadata and rules associated with the calculation of metrics
• Test automation
• Perform other duties as assigned

Requirements

• Senior/Graduate Students pursuing a bachelor's or master’s degree in management information systems (MIS), computer science, data science or computer engineering preferred
• Exposure to SQL, database management systems, NO-SQL databases, data integration tools like Informatica or Azure Data Factory preferred
• Exposure to cloud technologies and platforms desired
• Exposure to machine learning, predictive modeling and use of large language models desired
• Knowledge to scripting languages like UNIX shell scripting, Python, R preferred
• Must be self-motivated, results-oriented and accountable
• Excellent interpersonal and communication skills
• Ability to work independently
• Passionate for learning
• Good organizational skills

Tech Stack

• Azure
• Cloud
• ETL
• Informatica
• Python
• Shell Scripting
• SQL
• Unix

Benefits

• Comprehensive health and welfare benefits, to include medical, prescription, dental, vision, life insurance and disability insurance options
• Paid time off for vacation, illness, bereavement, family and parental leave
• Tax-advantaged 401(k) retirement savings plan