Senior BI Developer: Enterprise Analytics & Strategy

Moore & Van Allen; Charlotte (NC); On-site; USD 110,000 - 170,000; Full time

Job summary

Moore & Van Allen seeks a Senior BI Developer to lead enterprise BI initiatives, shaping data-driven insights for Finance, Practice Management, HR, and Marketing. You will design dashboards, semantic models, and governance standards to enable scalable reporting across the firm.

The ideal candidate will have 7+ years in BI/Analytics, strong Power BI development experience, and a proven track record partnering with senior leaders on FP&A and profitability reporting.

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Finance, Accounting, or related field.
• 7+ years of professional experience in Business Intelligence, Data Analytics, or Reporting.
• 5+ years of hands-on Power BI development experience.
• Experience supporting or working closely with FP&A teams.
• Strong understanding of financial and operational reporting concepts.
• Proven ability to work directly with senior business leaders and executive stakeholders.

Responsibilities

• Develop SQL transformation logic and governance-ready datasets.
• Design, develop, and maintain enterprise Power BI dashboards, scorecards, and reporting solutions.
• Build and maintain semantic models, datasets, and reusable reporting assets.
• Develop complex DAX measures, calculated columns, KPIs, and metrics.
• Optimize Power BI performance via data modeling and query tuning.
• Automate reporting processes using Power Query and Dataflows.
• Design star-schema data models with conformed dimensions.
• Implement row-level security and governance standards for a single semantic model.
• Maintain change tracking and reporting governance controls.
• Document reporting solutions, standards, and data lineage.
• Maintain a dictionary of firm metric definitions.
• Perform data quality controls at the reporting layer and reconcile figures with financial results.
• Collaborate with leadership to develop reporting across matter and client profitability, timekeeper productivity, billing and forecast analytics.
• Elicit requirements from partners and translate needs into reporting solutions.
• Scope deliverables into releasable increments and maintain a prioritized roadmap.
• Collaborate with BI/Data Engineering to integrate data from ERP, CRM, HRIS, and other systems.
• Train end users and promote Power BI best practices.

Skills

Power BI development

DAX

Power Query

SQL Server / T-SQL

SSRS

Advanced Excel

Data profiling

Data governance

Business analytics

Stakeholder communication

Education

Bachelor's degree in Information Systems, Computer Science, Finance, Accounting, or related field

Tools

Microsoft Power BI

Power BI Service

Power BI Gateway

SQL Server / T-SQL

SSRS

Excel

Microsoft Fabric

Azure DevOps

Aderant

Elite 3E

Job description

Moore & Van Allen seeks a Senior BI Developer to lead enterprise BI initiatives, shaping data-driven insights for Finance, Practice Management, HR, and Marketing. You will design dashboards, semantic models, and governance standards to enable scalable reporting across the firm.

The ideal candidate will have 7+ years in BI/Analytics, strong Power BI development experience, and a proven track record partnering with senior leaders on FP&A and profitability reporting.