Senior Power BI Architect - Enterprise Analytics Leader

Moore & Van Allen PLLC; Charlotte (NC); On-site; USD 120,000 - 180,000; Full time

Job summary

Moore & Van Allen PLLC is seeking a Senior BI Developer to lead the design, development, and enhancement of enterprise BI solutions that deliver meaningful financial and operational insights across the firm.

You will partner with executive leadership and Finance, Accounting, Practice Management, Pricing, HR, and Marketing to develop scalable reporting, automate processes, and improve data-driven decision making. This role combines technical prowess with financial acumen in a law firm setting.

Qualifications

• 7+ years in Business Intelligence, Data Analytics, or Reporting.
• 5+ years hands-on Power BI development.
• Experience with FP&A teams.
• Strong understanding of financial and operational reporting.
• Proven ability to work with senior leaders.

Responsibilities

• Develop SQL transformation logic and governed datasets.
• Design, develop, and maintain enterprise Power BI dashboards and reports.
• Build semantic models, datasets, and reusable assets.
• Develop DAX measures, KPIs, and business metrics.
• Optimize Power BI performance through data modeling and query tuning.
• Automate reporting using Power Query and Dataflows.

Skills

Power BI development

SQL / T-SQL

DAX

Data analytics

Stakeholder collaboration

Advanced Excel

Education

Bachelor's degree in Information Systems / Computer Science / Finance / Accounting

Tools

Microsoft Power BI

Power Query (M)

SSRS

Power BI Service

Power BI Gateway

SQL Server

Excel

Data modeling

Job description

Moore & Van Allen PLLC is seeking a Senior BI Developer to lead the design, development, and enhancement of enterprise BI solutions that deliver meaningful financial and operational insights across the firm.

You will partner with executive leadership and Finance, Accounting, Practice Management, Pricing, HR, and Marketing to develop scalable reporting, automate processes, and improve data-driven decision making. This role combines technical prowess with financial acumen in a law firm setting.