Financial Data Analyst

Job Summary

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.

• 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

• 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

• 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

• 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

• 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

• 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, , 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…