Data Analyst Python Sql Jobs in Lancaster, PA (NOW HIRING)

Clark Associates is seeking a driven and detail-oriented Financial Data Analyst to join the Financial Systems & Data team. In this role, you will work directly with The Restaurant Store Accounting team as well as the broader Clark Associates Finance organization to deliver reporting, analysis, and insights that support strategic decision-making and operational efficiency.  

This role requires strong collaboration across Finance and Accounting teams, with an emphasis on understanding business context, improving reporting accuracy, and enabling decision-making through scalable data solutions. 

This role is a preferred hybrid role, if you are local to Lititz, PA, with one day in the office a week to ensure valuable face time with the team. 

Reporting & Data Storytelling 

• Translate financial and operational data into clear, accurate, and actionable insights  
• Build and maintain Power BI and Excel-based reporting solutions aligned to business needs  
• Anticipate stakeholder needs and structure analyses to answer key business questions  
• Ensure reporting is accurate, consistent, and aligned with defined data and metric standards  

Stakeholder Collaboration & Business Partnership 

• Partner with stakeholders to understand business goals, constraints, and reporting needs  
• Translate business problems into structured analytical questions and reporting solutions  
• Collaborate on KPI definitions, report design, and data requirements to ensure alignment  
• Set clear expectations around timelines, scope, and deliverables  

Business & Financial Acumen 

• Apply financial knowledge to contextualize reporting and analysis  
• Connect insights to broader business strategy, KPIs, and operational performance  
• Understand how financial and operational processes impact reported results  

Data Modeling & Reporting 

• Extract and combine data from multiple sources (Snowflake, SQL, Excel, semantic models, etc.)  
• Develop and interpret SQL queries and DAX measures to support analysis  
• Validate data accuracy, completeness, and consistency across reporting layers  
• Build, enhance, and maintain Power BI data models and reporting solutions  
• Ensure models are efficient, scalable, and aligned with best practices  

Process & Operational Support 

• Maintain recurring operational reporting for The Restaurant Store Accounting team  
• Identify opportunities to improve reporting consistency and automation  
• Stay current on BI, Snowflake, and data visualization best practices  

Project Ownership & Execution 

• Own projects end-to-end from intake through delivery  
• Manage multiple priorities and communicate tradeoffs when needed  
• Provide accurate timelines and structured project plans  
• Independently manage stakeholder relationships with appropriate support as needed  

• 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.

• Access to a reliable and secure high-speed internet connection. Cable or fiber internet connections (at least 75mbps download/10mbps upload) are preferred, as satellite connections often cannot support the technologies used to perform day-to-day tasks.
• Access to a home router and modem.
• A dedicated home office space that is noise- and distraction-free. The space should have strong wireless connection or a wired Ethernet connection (wired connection is preferred, if possible).
• A valid, physical address (apartment, suite, etc.). PO Boxes are not supported, as a physical address is required for you to receive your computer equipment.
• The desire and ability to work and communicate with other team members via chat, webcam, etc.
• Legal residents of one of the following states: (AK, AL, AR, AZ, CT, DE, FL, GA, IA, ID, IN, KS, KY, LA, MD, ME, MI, MN, MO, MS, MT, NC, ND, NE, NH, NM, NV, OH, OK, PA, SC, SD, TN, TX, UT, VA, VT, WI, WV, or WY). H-1B Visa Sponsorship Not Available, W2 only.

• 2–4 years of professional experience in data analytics, finance, or a related role
• Experience working with financial or operational datasets (strongly preferred)
• Knowledge of finance or accounting concepts
• Proficiency in Power BI or similar data visualization tools
• Strong SQL skills, including experience working in cloud data environments (Snowflake preferred)
• Advanced Excel skills required
• Proficiency in Python, Power Automate, and Excel VBA (nice to have)
• Experience leveraging AI tools (e.g., Claude, Copilot, or similar) to enhance analysis, reporting, modeling, and workflow efficiency

This role does not require a degree. We value relevant skills and experience and alignment with our core values above all else.

• Strong analytical and problem-solving skills
• Ability to work independently while managing multiple priorities
• Strong communication skills, with ability to clearly present findings to stakeholders
• Curiosity and initiative to explore data and identify opportunities without being prompted
• Ability to think critically about business problems, not just execute requests
• Interest in building scalable, sustainable reporting rather than one-off solutions

A rapidly growing, multi-divisional company headquartered in Lancaster, Pennsylvania with services supporting all of Clark’s distribution methods in the food service industry.

• Medical
• Vision
• Dental
• PTO
• Paid Maternity Leave
• Paid Parental Leave
• Life Insurance
• Disability
• Dependent Care FSA
• 401(k) matching
• Employee Assistance Program
• Wellness Incentives
• Company Discounts
• AT&T & Verizon Discount
• Bonus Opportunities
• Accident Insurance
• Critical Illness Insurance
• Adoption Assistance

• On-Site Fitness Centers
• Dog-friendly Offices