Power BI Developer & Data Analyst

Overview

McKonly & Asbury is a growing public accounting firm with four offices across Pennsylvania. The firm promotes a people-centered environment built around work-life balance, professional growth, and recognition for strong performance. Guided by the philosophy of Helping Others Thrive, the organization focuses on supporting employees, serving clients, and contributing to the community. It is hiring a Power BI Developer & Data Analyst for its Information Technology team in Camp Hill, PA.

Role Summary

This role is responsible for creating and supporting interactive dashboards and reports for internal teams and external clients. The selected candidate will work closely with department leaders to understand business needs and turn them into reporting solutions that help drive better decisions.

What You Will Do

• Develop Power BI dashboards, scorecards, and reports for internal functions such as HR, finance, utilization, and performance tracking, as well as client-facing reporting
• Turn approved ideas from employees and leadership into practical visual reporting outputs
• Build and maintain Power BI datasets, data models, and DAX calculations
• Administer Power BI Service tasks such as publishing, scheduled refresh setup, permission control, and report lifecycle oversight
• Connect to data sources including Excel, SQL databases, SharePoint, and accounting/ERP platforms, then transform the data with Power Query (M language)
• Create organized, efficient, and reusable data models using star schema or other dimensional modeling approaches
• Record data sources, transformation steps, and refresh schedules so reports remain dependable and auditable
• Spot data quality problems and work with source system owners to correct them

Qualifications

• Bachelor’s degree in Data Analytics, Business Intelligence, Accounting/Finance, Information Systems, Computer Science, or a similar field
• Proven exposure to Power BI through coursework, capstone work, internships, or independent projects, with readiness to share examples of work
• Practical understanding of DAX, including measures, calculated columns, and KPIs
• Hands-on experience using Power Query (M language) to connect to and reshape data
• Strong written and verbal communication skills, especially when explaining insights to non-technical audiences

Why This Role Stands Out

The firm highlights several recognitions, including being named the #6 Midsized Firm to Work For in the country in 2025, a Best Place to Work in PA for 20 straight years, a best Firm for Young Accountants, and a Best Accounting Firm for Women. It also emphasizes mentorship, training, and real opportunities to grow professionally.

Additional Information

The organization states that it values employee contributions and offers a workplace where careers can develop and thrive. No salary, bonus, vacancy count, or application deadline was provided in the source.