Power BI Developer & Data Analyst

Job Description

Job DescriptionDescription:

Power BI Developer & Data Analyst

McKonly & Asbury is a growing public accounting firm with four locations across Pennsylvania. We offer a people-first culture focused on work-life balance, professional development, and rewarding exceptional performance. Our philosophy, Helping Others Thrive, drives how we support our employees, serve our clients, and engage our communities. We are currently seeking a Power BI Developer & Data Analyst to join our Information Technology team.

Key Responsibilities

The Power BI Developer & Data Analyst will design, build, and maintain interactive dashboards and reports for both internal stakeholders and external clients. This individual will collaborate with department leaders understand business needs and develop reporting solutions that support informed decision-making.

Core responsibilities include:

• Design and build Power BI dashboards, reports, and scorecards for internal operations (HR, finance, utilization, and performance metrics) and client delivery
• Translate approved ideas from employees and leadership into clear, actionable visual reports
• Create and maintain Power BI datasets, data models, and DAX measures
• Manage Power BI Service (publishing, scheduled refreshes, permissions, and report lifecycle governance)
• Connect to and transform data from sources such as Excel, SQL databases, SharePoint, and accounting/ERP systems using Power Query (M language)
• Build clean, scalable, and reusable data models using star schema or other best-practice dimensional design
• Document data sources, transformations, and refresh schedules to ensure reports remain reliable and auditable
• Identify and flag data quality issues and partner with source system owners to resolve them

Qualifications

• Bachelor’s degree in Data Analytics, Business Intelligence, Accounting/Finance, Information Systems, Computer Science, or a related field
• Demonstrated Power BI experience (coursework, capstone, internship, or self-directed projects); candidates should be prepared to share work samples
• Working knowledge of DAX, including calculated columns, measures, and KPIs
• Experience connecting to and transforming data using Power Query (M language)
• Strong written and verbal communication skills, with the ability to present data insights to non-technical audiences

Why McKonly & Asbury?

McKonly & Asbury has been recognized as the #6 Midsized Firm to Work For in the country (2025), a “Best Place to Work in PA” for 20 consecutive years, a best “Firm for Young Accountants,” and a “Best Accounting Firm for Women.”

We are committed to developing our people through mentorship, training, and meaningful opportunities for growth. When you join McKonly & Asbury, you become part of a firm where your contributions matter and your career can thrive.

Requirements: