JM Family is looking to provide college students with meaningful work experiences that tie to their programs of study, allowing them to contribute to team success, learn about the company's culture, and gain new skills.
Requirements
- Knowledge of SQL and DBMS like SQL Server, or similar data structures.
- Working knowledge in Excel; VBA knowledge is a plus.
- Experience with Microsoft suite of products (Office 365, Outlook, Teams, SharePoint, etc.).
Responsibilities
- Build data pipelines to Extract, Transform, and Load (ETL) data from various sources (primary and secondary) into data warehouses or data lakes in support of advanced analytics, self-service reporting, and strategic data initiatives.
- Develop, test, and execute standard or custom queries to evaluate data and develop solutions as required for increased performance and scalability needs.
- Perform necessary data profiling, data cleansing, aggregations, and normalization to deliver data products that are available for end-user consumption.
- Participate in data product design reviews with team members as business requirements are translated to solutions.
- Learn about key business applications and data to respond to ad-hoc questions and/or requests for information.
- Collaborate with data engineers, BI engineers, data analysts, business analysts, product owner, and IT team members as a member of a data enablement product team in the development data pipelines and scripts.
- Engage in data quality and data validation activities in support of data initiatives as needed.
Other
- The ideal candidate will be available to work full-time during the Summer Internship Program (May 26th, 2026-July 31st, 2026).
- The ideal candidate will be actively enrolled in a bachelor’s, master’s, or other degree-seeking program at an accredited college or university, with a focus in Computer Science, Management Information Systems, Data Analytics, or a related field. Must have completed at least one semester of coursework.
- Strong analytical, critical thinking, and problem-solving abilities.
- Excellent verbal and written communication skills and presentation skills.
- Team player with ability to collaborate within data teams across the enterprise.
