2024 Spring/Summer Internship - Solution Engineering

Job Description
2024 Summer Internship (open to hiring during Spring semester based on student availability)
This position will work in the Ruan Center downtown Des Moines, IA.
Ruan is hiring for a Solution Engineering Intern! This internship will work with business partners from various functional areas to build, implement, and maintain reporting solutions and performance metrics that support the business needs of operations and corporate teams. Support enterprise adoption of common, consistent measurements and reporting tools to encourage data-driven decisions.
Responsibilities:

• Designs and builds enterprise-wide reporting and data analysis tools with general input and oversight from business users. Ensures reporting is in a useable format to determine trends, issues, or problem areas requiring root cause analysis.
• Works with project teams and functional leaders to determine business reporting needs and requirements, develop and maintain appropriate documentation, and conduct data analysis to identify opportunities for continuous improvement.
• Utilizes reporting tools and software such as Power BI, Excel, SSRS, and various data sources to develop reports that are easily understood by end-users. Provides training and coaching on these tools as necessary.
• Reviews and analyzes data from multiple internal and external sources. Identifies data errors, discrepancies, and reporting issues. Preforms data analysis and communicates results and recommendations to business partners and leaders from functional areas.
• Identifies opportunities to create common and consistent reporting across multiple functional areas.
• Updates, maintains, manipulates, and administers various reporting and database systems to ensure data accuracy and reporting continuity.
• Perform other job-related duties and special projects as required.

Desired Skills or Skills You Will Learn:

• Experience with database queries, report writing, and data analysis. Practical experience supporting transportation operations or process improvement initiatives a plus.
• Practical experience with business intelligence and analytic processes and methods.
• Able to analyze and document complex business processes, make effective decisions under pressure, think analytically, and be a problem-solver by gathering and interpreting relevant data and information.
• Ability to effectively organize and prioritize workload in a multi-task environment with little and remote supervision.

Requirements
Education: Progressing towards a Bachelor's degree or equivalent education.
Course(s) of Study: Data Analytics, Statistics, Computer Science, Engineering, Business, or related field of study.

• Prefer experience using Microsoft Excel, SQL, Power BI, or other reporting tools in addition to MS Office Suite.
• Strong verbal and written communication and the ability to effectively communicate with diverse groups of people.

#RuanCorp