Business Intelligence Analyst

Chaffin Luhana LLP; Pittsburgh (Allegheny County); Remote; USD 62,000 - 90,000; Part time

Job summary

Chaffin Luhana LLP is seeking a part-time Business Intelligence Analyst to turn financial and operational data into actionable insights. You will develop dashboards using Power BI and Microsoft Fabric, and report on KPIs across departments, practice areas, and campaigns.

Remote, 10–20 hours per week, with collaboration across CFO, Director of Finance, and departmental leaders to improve data visibility and profitability analysis.

Qualifications

• Bachelor's degree in finance, accounting, business, or related field; MBA/CPA desirable.
• Minimum 8 years of experience in senior financial managerial positions.
• Strong BI and analytics experience in a professional services setting.
• Excellent communication, presentation, and confidentiality.
• Ability to work 10–20 hours per week remotely.

Responsibilities

• Develop, maintain, and enhance dashboards and reporting using Microsoft Fabric and Power BI.
• Define, calculate, and report meaningful financial and operational KPIs with leaders.
• Analyze profitability across practice areas and departments.
• Develop reporting to evaluate profitability by case type and characteristics.
• Analyze attorney production, staffing costs, productivity, and other metrics.
• Partner with Marketing to evaluate acquisition costs and ROI.
• Develop departmental scorecards and analysis for firm leaders.
• Support targeted financial and operational analysis requested by leadership.

Skills

BI analytics

KPIs & reporting

Data interpretation

Problem solving

Communication skills

Confidentiality

Interpersonal skills

Time management

Education

Bachelor's degree in finance, accounting, business, or related field

MBA or CPA desirable

Tools

Power BI

Microsoft Fabric

Data visualization tools

Databases

Financial and operational reporting systems

Job description

About:

The Business Intelligence Analyst will play a key role in transforming the firm’s financial and operational data into meaningful insights that support informed decision-making across the firm. This position will focus on developing and maintaining business intelligence dashboards, analyzing key performance indicators (KPIs), and evaluating profitability and operational performance across practice areas and departments. Working closely with the Chief Financial Officer (CFO), Director of Finance, Comptroller, and departmental leaders, the Business Intelligence Analyst will help improve data visibility, identify trends and opportunities, and provide actionable insights that support the firm's strategic and operational objectives.

Responsibilities:

• Develop, maintain, and enhance management dashboards and reporting using Microsoft Fabric and Power BI.

• Work with the equity partners, Fractional COO, Fractional CFO, Director of Finance, Comptroller, and department leaders to define, calculate, and report meaningful financial and operational KPIs.

• Analyze profitability across the firm’s practice areas, and departments, including revenue, direct expenses, allocated costs, and contribution margins.

• Develop reporting to evaluate profitability by case type, matter, and other relevant case characteristics.

• Analyze attorney production, staffing costs, productivity, and other measures of attorney-level financial performance.

• Partner with Marketing to evaluate acquisition costs, conversion rates, marketing ROI, and profitability by marketing channel or campaign.

• Develop departmental scorecards and analysis to help firm leaders understand their financial and operational performance.

• Support targeted financial and operational analysis requested by leadership.

Qualifications:

• Bachelor's degree in finance, accounting, business, or a related field. An MBA, CPA, or similar qualification is highly desirable.

• A minimum of 8 years' experience in senior financial managerial positions, preferably in the legal sector.

• Strong understanding of business intelligence, financial and operational analytics, key performance indicators (KPIs), and performance reporting, preferably within a law firm or professional services environment.

• Strong analytical and problem-solving skills, with the ability to interpret complex data, identify trends, and translate findings into meaningful insights and actionable recommendations.

• Proficiency in Microsoft Power BI, Microsoft Fabric, data visualization tools, databases, and financial and operational reporting systems, with experience integrating data from multiple sources.

• Excellent communication and presentation skills.

• Strong knowledge of data analysis and risk management.

• High ethical standards and professionalism, with a commitment to confidentiality

• Exemplifies Chaffin Luhana LLP’s Core Values of Doing Good by Doing Right ™: Results Driven, Excellence Without Paralysis, Compassionate and Authentic, In It Together, and Innovative Growth.

• Adheres to all government and industry regulations, including the protection of regulated sensitive data.

• Exceptional communication and interpersonal skills, with the ability to collaborate effectively with diverse stakeholders.

• Problem-solving mindset, with the ability to identify process improvements and implement solutions.

• Maintain confidentiality of all Confidential Information of clients and of the company.

• Excellent analytical skills, with a keen eye for detail and a commitment to accuracy.

• Excellent interpersonal skills, organizational skills, and time management skills.

• Ability to handle frequent pressures, time deadlines, and multi-task. Available for 10-20 hours per week.

Note:

This job description is not an exclusive or exhaustive list of all job functions an employee in this position may be asked to perform. Duties, responsibilities, and requirements can be added, changed, or reduced by management to meet the business needs of the company.

Chaffin Luhana LLP does not discriminate based on race, color, sex, religion, national origin, disability, or any other reason prohibited by law in provision of employment opportunities.

Location:

Remote

Salary Range

$45-$65 per hour