Job Summary
Applicants for this position must be located within a one-hour drive of Lancaster, PA at the time of internship to be considered.
Clark Associates is seeking a detail-oriented and motivated Data & Reporting Intern to support key reporting and business intelligence functions. This full-time internship is based in Lancaster, PA, for candidates within a one-hour driving radius.
As an intern, you’ll gain hands-on experience with tools like Excel and Power BI while supporting the team in creating reports, visualizations, and data models. You’ll assist in analyzing sales, profitability, and inventory trends, learning how data helps guide important business decisions. With guidance, you’ll help maintain reports, organize documentation, and contribute to special projects that improve how the business uses data.
Interns at Clark enjoy a high degree of collaboration and exposure to department leaders. You’ll also benefit from our robust training program, which includes: Campus and warehouse tours, Team shadowing and mentorship, Volunteer opportunities, Roundtable discussions and leadership presentations, Networking events, and Soft-skill and hard-skill development.
This is a great opportunity to build your technical and analytical skills in a fast-paced, data-driven environment while making meaningful contributions to our business. Click here to learn more about our internship program.
Job Location
2257 Old Philadelphia pike, Lancaster, PA 17602
We only accept W-2 candidates, H-1B sponsorship is not available.
Responsibilities
- Assist with creating and updating basic Power BI reports to support business decisions (such as sales, profitability, or inventory).
- Support the team in preparing reports that track vendor and product category performance.
- Learn how to write and edit queries to gather data from different sources.
- Help design simple and clear data visualizations that highlight trends and insights.
- Work with team members to set up and maintain data models in Power BI.
- Keep reports, queries, and documentation organized and up to date.
- Assist in testing and updating existing Power BI reports.
- Participate in other projects and assignments as needed.
Physical Requirements
- Work is performed while sitting/standing and interfacing with a personal computer.
- Requires the ability to communicate effectively using speech, vision, and hearing.
- Requires the regular use of hands for simple grasping and fine manipulations.
- Requires occasional bending, squatting, crawling, climbing, and reaching.
- Requires the ability to occasionally lift, carry, push, or pull medium weights, up to 50lbs.
Qualifications
Experience
- Basic knowledge of Microsoft Excel (formulas, pivot tables, and charts).
- Interest in growing Power BI data modeling & visualization skills
- Exposure to coding languages such as SQL and DAX.
- Strong interest in data reporting and analysis.
Education
This role does not require a degree. We value relevant skills and experience and alignment with our core values above all else.
Desired Traits & Skills
- Attention to detail and ability to work carefully, even when moving quickly.
- Clear and professional communication skills.
- Ability to stay organized and manage multiple tasks with guidance.
- Positive attitude, curiosity, and eagerness to learn new skills.
Hiring Process
Our hiring process is designed to be straightforward and supportive. We begin by reviewing your resume to understand your background and interests. If we need additional information, we’ll reach out by email. From there, selected candidates will be invited to a brief phone interview, followed by an in-person interview with our team for final consideration.
A rapidly growing, multi-divisional company headquartered in Lancaster, Pennsylvania with services supporting all of Clark’s distribution methods in the food service industry.
Job Posted: 09/12/2025