Business Intelligence Analyst – East Petersburg, PA

Warfel Construction Company is looking for a Business Intelligence Analyst to join our fast-paced, team-oriented organization based out of our East Petersburg, PA office. The Business Intelligence Analyst will help Warfel build and scale a modern, trusted data environment by translating data into reliable insights that drive better decisions across finance, project management, and leadership.

Job responsibilities include, but are not limited to, the following:

Responsibilities:

• Design and develop Power BI dashboards and reports for project managers, regional general managers, and executive leadership.
• Partner with business stakeholders to understand reporting needs and translate them into accurate, user-friendly reporting solutions.
• Communicate complex data insights clearly to non-technical stakeholders across all levels of the organization.
• Manage the Work-in-Progress (WIP) reporting process from start to finish, ensuring leadership has access to clean, reliable, and fully functional Power BI reports.
• Maintain and enhance reports and dashboards as business needs evolve.
• Document report development, data definitions, and reporting processes to ensure consistency and transparency.
• Establish and maintain reporting standards, naming conventions, and system-of-record designations across the reporting environment.
• Create documentation that supports long-term knowledge transfer and the sustainability of reporting processes.
• Support Warfel’s partnership with third-party data vendors by reviewing deliverables and ensuring reporting outputs align with business requirements.
• Collaborate with vendors and internal teams to identify gaps and ensure project scope and deliverables are executed effectively.
• Work closely with IT on system access, integrations, and platform configuration.
• Develop an understanding of how data flows from source systems into Microsoft Fabric.
• Support data pipeline validation by identifying refresh failures, inconsistencies, or reporting issues as they arise.

Qualifications

• Understanding of data warehouse and lakehouse concepts — familiarity with how data is structured, stored, and made available for reporting
• Power BI development experience – you have built dashboards that real users rely on
• Experience working with data from multiple source systems and translating it into reliable reporting outputs
• Strong communication skills — you can explain what the data means to someone who does not live in spreadsheets, validate that the numbers are correct, and give stakeholders confidence in what they’re looking at
• DAX proficiency – writing calculated measures and columns, not just using defaults
• Familiarity with Microsoft Fabric or Azure-based data platforms

Physical Requirements

• Must be able to sit for long periods of time, with significant use of a computer and other office equipment (i.e. calculator, telephone, copy machine, or printer).
• Frequently communicates with internal, and sometimes external clients to exchange correct and accurate information.

• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k, IRA)
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off (Vacation & Public Holidays)
• Parental Leave
• Employer Paid Short Term Disability

Warfel is an equal opportunity employer. Warfel Construction Company provides reasonable accommodations to qualified individuals with disabilities during the application and hiring process. Employment with Warfel Construction Company is at-will and may be terminated at any time, with or without cause or notice.