Progress Rail
Albertville or Independence
AI Data Science Intern
Skip the busywork
ApplyBolt rewrites your resume for this exact role and hits submit. You just pick the jobs.
Resume tailored to this roleApplied in secondsTrack every application
Download the appAbout this role
Job Purpose
The AI & Data Science Intern will support the design and development of an AI enabled solution to profile, cleanse, standardize, and model enterprise data into a Snowflake cloud data platform. This role provides hands-on experience working with real enterprise datasets, modern data engineering pipelines, and applied machine learning techniques to improve data quality, governance, and analytical readiness. The intern will collaborate closely with Data Engineers, Data Architects, and Analytics teams to help accelerate the organization’s journey toward an AI ready, governed enterprise data ecosystem.
Job Location: Albertville, AL or Independence, KS
Job Location: Albertville, AL or Independence, KS
Company Description
Progress Rail, a Caterpillar company, is an integrated rolling stock and infrastructure provider, delivering a full range of products and services to domestic and international railroad customers. Our customers enjoy one-stop shopping and comprehensive cradle-to-grave railway solutions - whether it rolls on the rail or is the rail itself. From locomotives, transit, freight cars and engines, to tracks, signals and advanced technology, we ensure customers can count on us to meet all their rail needs. Forging the bridge between ideas and success, our talented and innovative team members work together to address the challenges of the rail industry today, ensuring success for the future. As part of a vibrant, global network of business operations, each and every member of our team is important to our success. With headquarters in Albertville, Ala., more than 7,000 dedicated employees serve customers through a network of close to 150 locations around the world. For more information, visit www.progressrail.com and follow @Progress_Rail on Twitter and YouTube.
Education / Training
• Currently pursuing a Bachelor’s or Master’s degree in Data Science, Computer Science, Engineering, Statistics, or a related field.
• Coursework or hands on experience in Python and SQL.
• Foundational understanding of data structures, statistics, and analytics concepts.
• Strong analytical thinking and problem solving skills.
• Ability to learn quickly and work with complex, real world datasets.
• Coursework or hands on experience in Python and SQL.
• Foundational understanding of data structures, statistics, and analytics concepts.
• Strong analytical thinking and problem solving skills.
• Ability to learn quickly and work with complex, real world datasets.
Job Title
AI Data Science Intern
City
Albertville
Key Job Elements
• Data Profiling & Quality
-Analyze structured enterprise datasets to identify data quality issues such as missing values, inconsistencies, duplicates, and schema anomalies.
-Develop automated data profiling and data quality checks using Python and SQL.
-Assist in defining data quality metrics, rules, and scorecards for enterprise reporting.
• Data Cleansing & Transformation
-Design and implement data cleansing and standardization logic to improve accuracy and usability of enterprise data.
-Support ELT workflows that transform raw source data into curated datasets within Snowflake.
-Document data transformations and assumptions to support governance and auditability.
• Data Modeling & Snowflake Integration
-Assist with logical and physical data modeling (e.g., dimensional, data vault, or domain oriented models) in Snowflake.
-Support loading curated datasets into Snowflake schemas optimized for analytics and AI use cases.
-Write and optimize SQL queries for validation, analytics, and downstream consumption.
• Applied AI / Machine Learning
-Explore and prototype machine learning techniques to detect anomalies, automate mappings, or classify data attributes.
-Assist in evaluating AI driven approaches for data quality improvement and metadata enrichment.
-Collaborate with senior team members on proof of concept AI use cases aligned to enterprise data strategy.
• Collaboration & Documentation
-Work closely with cross functional teams including Data Engineering, Analytics, and Governance.
-Create clear technical documentation, data dictionaries, and solution summaries.
-Present findings, models, and recommendations to technical and non technical stakeholders.
-Analyze structured enterprise datasets to identify data quality issues such as missing values, inconsistencies, duplicates, and schema anomalies.
-Develop automated data profiling and data quality checks using Python and SQL.
-Assist in defining data quality metrics, rules, and scorecards for enterprise reporting.
• Data Cleansing & Transformation
-Design and implement data cleansing and standardization logic to improve accuracy and usability of enterprise data.
-Support ELT workflows that transform raw source data into curated datasets within Snowflake.
-Document data transformations and assumptions to support governance and auditability.
• Data Modeling & Snowflake Integration
-Assist with logical and physical data modeling (e.g., dimensional, data vault, or domain oriented models) in Snowflake.
-Support loading curated datasets into Snowflake schemas optimized for analytics and AI use cases.
-Write and optimize SQL queries for validation, analytics, and downstream consumption.
• Applied AI / Machine Learning
-Explore and prototype machine learning techniques to detect anomalies, automate mappings, or classify data attributes.
-Assist in evaluating AI driven approaches for data quality improvement and metadata enrichment.
-Collaborate with senior team members on proof of concept AI use cases aligned to enterprise data strategy.
• Collaboration & Documentation
-Work closely with cross functional teams including Data Engineering, Analytics, and Governance.
-Create clear technical documentation, data dictionaries, and solution summaries.
-Present findings, models, and recommendations to technical and non technical stakeholders.
Qualifications and Experience
• Exposure to Snowflake, cloud data platforms, or data warehousing concepts.
• Familiarity with pandas, NumPy, scikit learn, or similar Python libraries.
• Basic understanding of ETL / ELT pipelines and data modeling techniques.
• Interest in AI, machine learning, and data governance within enterprise environments.
• Experience with Power BI, data visualization, or metadata tools is a plus.
Essential and Physical Activities Functions;
• Strength-Must be able to lift 40lbs.
• Motion-The position is primarily in an office setting requiring behind a desk the majority of they day utilizing a variety of office equipment such as computers, scanners, copies, etc.
• Vision/Hearing Requirements-May spend long periods of time in front of computer screen. Will need to be able to read detailed billing statements and be detailed oriented.
• Work Environment-Will spend the majority of time in office environment, although exposed occasionally to plant exposure to hot and cold environments along with noise exposure.
• Emotional Demands-Must have good communication skills. Be capable to multi-task and work independently. Ability to adapt to frequent changes in tasks and workload.
• Safety-The position will require the adherence to all safety practices and use of PPE while in a facility manufacturing facility to include eye, face, hand and hearing protection, steel toed boots, no jewelry and hard hats. This not a safety sensitive position.
Transportation: Public transportation and ride share services are limited in some of our locations. Interns are responsible for securing their own transportation to and from work each day and must have a reliable plan for transportation to be eligible for a position. Regular in-person attendance is required.
Visa Sponsorship: Visa Sponsorship is not available for this position.
• Familiarity with pandas, NumPy, scikit learn, or similar Python libraries.
• Basic understanding of ETL / ELT pipelines and data modeling techniques.
• Interest in AI, machine learning, and data governance within enterprise environments.
• Experience with Power BI, data visualization, or metadata tools is a plus.
Essential and Physical Activities Functions;
• Strength-Must be able to lift 40lbs.
• Motion-The position is primarily in an office setting requiring behind a desk the majority of they day utilizing a variety of office equipment such as computers, scanners, copies, etc.
• Vision/Hearing Requirements-May spend long periods of time in front of computer screen. Will need to be able to read detailed billing statements and be detailed oriented.
• Work Environment-Will spend the majority of time in office environment, although exposed occasionally to plant exposure to hot and cold environments along with noise exposure.
• Emotional Demands-Must have good communication skills. Be capable to multi-task and work independently. Ability to adapt to frequent changes in tasks and workload.
• Safety-The position will require the adherence to all safety practices and use of PPE while in a facility manufacturing facility to include eye, face, hand and hearing protection, steel toed boots, no jewelry and hard hats. This not a safety sensitive position.
Transportation: Public transportation and ride share services are limited in some of our locations. Interns are responsible for securing their own transportation to and from work each day and must have a reliable plan for transportation to be eligible for a position. Regular in-person attendance is required.
Visa Sponsorship: Visa Sponsorship is not available for this position.
EEO
Equal Opportunity Employer – Race/Color/Sex/Religion/National Origin/Sexual Orientation/Gender Identity/Vets/Disabilities
Benefits
Compensation and benefits offered may vary depending on multiple individualized factors, job level, market location, job-related knowledge, skills, individual performance, and experience. Please note that salary is only one component of total compensation at Progress Rail.*
- Competitive Salary
- 401(k) plan with up to 6% company match (no waiting period with immediate vesting)
- Medical/Dental/Vision/Life/Disability Insurance
- Group Accident, Critical Care, and Hospital Insurance available along with an HDHP and HSA with employee and employer contributions
- Flexible Spending Accounts
- Paid Vacation
- Paid Holidays
- Paid Time-Off (PTO)
- Employee Assistance Plan
- Education Assistance Program
- Employee Recognition Programs
- Incentive Bonus Plan
- Site Specific Relocation Programs
*Subject to position, eligibility, and plan guidelines.
Job Category
Administrative / Support / Communications
State:
Alabama