Job Summary
The Procurement Systems & Information team is responsible for working with all teams within the procurement department to provide reports, systems, and process improvements to improve decision making and efficiency. We are looking for an analytical, accurate, and inquisitive individual to play an important role in the expansion of this team. This Data and Reporting Analyst role is responsible for developing, optimizing, and maintaining Power BI reports and complex data models to support key business decisions related to sales, profitability, and inventory. The position involves collaborating with internal stakeholders, writing and troubleshooting queries, creating data visualizations, and optimizing data models and DAX measures. The analyst also supports report testing, documentation, and handles inquiries through the team inbox.
Job Location
2257 Old Philadelphia pike, Lancaster, PA 17602
We only accept W-2 candidates, H-1B sponsorship is not available.
Responsibilities
- Creates and maintains Power BI reports from the internal Data Warehouse that provide insights on key business decisions, including, but not limited to, sales growth, profitability, and inventory levels
- Works with internal stakeholders to provide reporting to track the health of the vendors and categories in terms of sales growth, profitability, etc.
- Write, update, and troubleshoot queries to pull data from multiple sources
- Create engaging data visualizations that highlight key insights and trends
- Build and maintain complex data models in Power BI desktop
- Optimize and document data models, queries, and DAX measures
- Monitor the team inbox and address relevant questions as needed
- Maintain a strong working knowledge of Power BI features and updates
- Troubleshoot, test, and update existing Power BI reports
- Other special projects as assigned
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
- 1-3 years of relevant experience
- Strong Microsoft Excel skills
- Experience working in Power BI and data modelling
- Coding skills in languages such as SQL and DAX required
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
- Excellent data reporting and analytical skills
- Ability to work accurately at a fast pace
- Clear and effective communication
- Strong prioritization and organization skills
- A positive attitude with a determination to learn and grow
Ideal Applicants for this position:
- Commute from within a 2-hour driving radius of our headquarters in Lancaster, PA
- Accepting W-2 candidates only. H-1B sponsorship not available
Who We Are
Clark Associates is the largest food service equipment and supplies dealer in the country and has been recognized as one of Central Pennsylvania’s fastest growing companies! We credit our success to hiring only the very best talent and keeping a strong focus on company culture, and employee engagement and development. People are at the core of everything we do. If you’re looking for a career, and not just a job, Clark Associates is the right fit for you. Click here to learn more.
What We Offer
- Nationally-recognized, growing company with strong core values and company culture
- Market-competitive compensation package and yearly performance bonus
- Great benefits package including health, dental & vision insurance, 401k with company match, generous PTO, paid maternity and parental leave and more
- Support for career growth and advancement including professional development and leadership courses, ongoing education and trainings, mentorships, company library and more
- Flexible hours and ability to work from home
- Work-life balance and wellness focused employer with on-site fitness Center and local gym discounts, free strength and yoga classes, standing desks and more
- Thoughtful community support through the Clark Associates Charitable Foundation that donates over $3M to the local community annually, time off for monthly volunteer opportunities, charitable gifts to organizations you care about
Hiring Process
Hiring Process
- Please submit your resume and a cover letter
- If your application matches the qualities we’re looking for in an employee, you will receive a request for an interview
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: 08/25/2025