Data Services Intern

Summary

Ryder System, Inc. is a logistics and transportation company, and they are seeking a Data Services Intern to join their IT team. The intern will perform various functions related to database design, data analysis, ETL processes, and support for cloud-based environments.

Responsibilities

• Work with on premise and cloud based solutions and platforms
• 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 requirements
• ETL source to target documentation including business matrix and functional requirements
• Develop and test data ingestion and ETL processes
• Troubleshoot data ingestion, ETL and data issues
• Design, develop, and support interactive visual dashboards and reports
• Ability to write SQL queries to profile data and validatesolutions 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

Skills

• Bachelor's degree required Currently enrolled toward a degree
• Must be self-motivated, results-oriented and accountable
• Excellent interpersonal and communication skills
• Ability to work independently
• Passionate for learning
• Good organizational skills
• Ability to: Write SQL queries
• Learn new technologies and tools, bring new ideas to the team and be an effective team player
• Effectively communicate with management and co-workers and customers; strong customer focus
• Learn, adapt, grow, and be flexible
• Multitask, demonstrate good organization and time management skills
• Work well under pressure, successfully meet schedules, work independently as needed to produce high quality work with minimal supervision
• Operate as part of a cross-functional project team that will organize, plan and execute varying scale projects from vision to implementation
• Strong PC skills (Windows, MS Office, MS Project, MS Excel) intermediate required
• 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, ETL tools like Informatica preferred
• Knowledgeto scripting languages like UNIX shell scripting, Python, R preferred
• Knowledge of: Data Warehouse Dimensional model structures, including facts and dimensions preferred
• Certificate in database management systems or business intelligence completed or in progress preferred
• Exposure to cloud technologies and platforms desired
• Exposure to machine learning and predictive modeling desired
• Cloud platform like Microsoft Azure desired
• BI tools (e.g. MicroStrategy, Power BI, Tableau, Cognos, etc.)
• Certificate in Cloud based data ingestion, storage and analytics tools like Azure Data Factory, BLOB Storage, PowerBI etc. completed or in progress desired
• Robotic Process Automation (RPA) knowledge desired
• Windows and UNIX operating systems

Qualifications

Must Haves

• Bachelor's degree required Currently enrolled toward a degree
• Must be self-motivated, results-oriented and accountable
• Excellent interpersonal and communication skills
• Ability to work independently
• Passionate for learning
• Good organizational skills
• Ability to: Write SQL queries
• Learn new technologies and tools, bring new ideas to the team and be an effective team player
• Effectively communicate with management and co-workers and customers; strong customer focus
• Learn, adapt, grow, and be flexible
• Multitask, demonstrate good organization and time management skills
• Work well under pressure, successfully meet schedules, work independently as needed to produce high quality work with minimal supervision
• Operate as part of a cross-functional project team that will organize, plan and execute varying scale projects from vision to implementation
• Strong PC skills (Windows, MS Office, MS Project, MS Excel) intermediate required

Nice to Haves

• 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, ETL tools like Informatica preferred
• Knowledgeto scripting languages like UNIX shell scripting, Python, R preferred
• Knowledge of: Data Warehouse Dimensional model structures, including facts and dimensions preferred
• Certificate in database management systems or business intelligence completed or in progress preferred
• Exposure to cloud technologies and platforms desired
• Exposure to machine learning and predictive modeling desired
• Cloud platform like Microsoft Azure desired
• BI tools (e.g. MicroStrategy, Power BI, Tableau, Cognos, etc.)
• Certificate in Cloud based data ingestion, storage and analytics tools like Azure Data Factory, BLOB Storage, PowerBI etc. completed or in progress desired
• Robotic Process Automation (RPA) knowledge desired
• Windows and UNIX operating systems

Benefits

• Ryder offers comprehensive health and welfare benefits, to include medical, prescription, dental, vision, life insurance and disability insurance options, as well as paid time off for vacation, illness, bereavement, family and parental leave, and a tax-advantaged 401(k) retirement savings plan.
• The position may also be eligible to receive an annual bonus, commission, and/or long-term incentive plan based on the level and/or type.