Power BI Developer & Data Analyst at McKonly & Asbury LLP

Camp Hill, Pennsylvania, United States -

Full Time

Start Date

Immediate

Expiry Date

29 Sep, 26

Salary

0.0

Posted On

01 Jul, 26

Experience

0 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Power BI, DAX, Power Query, M Language, Data Modeling, Star Schema, SQL, Data Visualization, Data Analysis, Business Intelligence

Industry

Accounting

Description

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

Responsibilities

The role involves designing and maintaining interactive Power BI dashboards and reports for internal operations and external clients. Key tasks include creating data models, managing the Power BI Service, and transforming data from various sources using Power Query.