Data Services Intern

Position Description:

As part of the Ryder IT team theDataServicesInternwill perform a variety of job functionsfor traditional on premise as well as cloud based environments including but not limited to operational and analytical database designworking with structured semi-structured and/or unstructured datadata profiling/analysisdatabasedata ingestionETL report and dashboarddevelopment testing documentation and production environments support including troubleshooting and break fixes. The position could be extendedpastthe summer internship period and may lead to a temporary position.

Requirements:

• Senior/Graduate Students pursuing a bachelors or masters degree in management information systems (MIS) computer science datascienceor computer engineeringpreferred

• Exposure to SQL databasemanagement systemsNO-SQL databasesETL tools like Informaticapreferred

• Exposure to cloud technologies and platformsdesired

• Exposure to machine learning and predictive modelingdesired

• Knowledgeto scripting languages like UNIX shell scripting Python Rpreferred

• Must be self-motivated results-orientedand accountable

• Excellent interpersonaland communicationskills

• Ability to work independently

• Passionate for learning

• Good organizational skills

• Ability to:

• Write SQL queries

• Learnnew technologiesand tools bringnew ideasto the team and be an effective team player

• Effectively communicate with management and co-workers and customers; strong customer focus

• Learn adapt growand be flexible

• Multitaskdemonstrategoodorganizationand time managementskills

• Work well under pressure successfully meet schedules work independentlyas neededto produce high quality work with minimal supervision

• Operate as part of a cross-functional project team that will organizeplanand execute varying scale projects from vision to implementation

• Knowledge of:

• Data Warehouse Dimensional model structures including facts and dimensionspreferred

• Information technologies

• Cloud platform like Microsoft Azuredesired

• 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 PowerBIetc. completed or in progressdesired

• Certificate in databasemanagement systemsor business intelligence completed or in progresspreferred

• Robotic Process Automation (RPA) knowledgedesired

• Windowsand UNIX operating systems

Responsibilities:

• Work with on premise andcloud basedsolutions 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

• Developand test data ingestion andETL processes

• Troubleshootdata ingestionETL and dataissues

• Design develop and support interactive visual dashboards and reports

• Ability to write SQL queries to profile data andvalidatesolutions 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 todeterminethe definitions of essential data elements

• Work with data architects to review and implementlogical and physical databasemodels

• Support the mapping of source system data totargetmodelsinto data warehouse and data lake

• Define and capture metadata and rules associated with the calculation of metrics

• Test automation

• Perform other duties as assigned