Ryder System, Inc.→
Data Services Intern at Ryder System, Inc. in USA - Miami FL 33178
InternshipOn-siteFull-timeUSA - Miami FL 33178$37k–$42k/yr
Skills
sqldatabase management systemsnosql databasesetl toolscloud technologiesmachine learningpredictive modelingunix shell scriptingpythonrdata warehouse dimensional modelingcloud platformsbi toolsrobotic process automation (rpa)windows operating systemunix operating systemresults orientation
Job Description
Summary: Ryder System, Inc. is a logistics company seeking a Data Services Intern to join their IT team. The intern will work on various tasks related to database design, data analysis, ETL processes, and report development in both on-premise and cloud 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 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
Required Qualifications:
- Senior/Graduate Students pursuing a bachelor's or master's degree in management information systems (MIS), computer science, data science or computer engineering
- 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
- Bachelor's degree required Currently enrolled toward a degree
- Strong PC skills (Windows, MS Office, MS Project, MS Excel) intermediate required
Preferred Qualifications:
- Exposure to SQL, database management systems, NO-SQL databases, ETL tools like Informatica
- Knowledge of Data Warehouse Dimensional model structures, including facts and dimensions
- Certificate in database management systems or business intelligence completed or in progress
Required Skills: SQL, Database management systems, NoSQL databases, ETL tools, Cloud technologies, Machine learning, Predictive modeling, UNIX shell scripting, Python, R, Data warehouse dimensional modeling, Cloud platforms, BI tools, Robotic Process Automation (RPA), Windows operating system, UNIX operating system, Results orientation
Benefits: Comprehensive health and welfare benefits, Medical, Prescription, Dental, Vision, Life insurance, Disability insurance options, Paid time off for vacation, Illness, Bereavement, Family and parental leave, Tax-advantaged 401(k) retirement savings plan
Benefits
Comprehensive health and welfare benefits
Medical
Prescription
Dental
Vision
Life insurance
Disability insurance options
Paid time off for vacation
Illness
Bereavement
Family and parental leave
Tax-advantaged 401(k) retirement savings plan