Data Analyst, Financial & Operations BI & Automation

Freeman Mathis & Gary, LLP; Atlanta (GA); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

HSA and FSA options

401(k) with 3% employer Safe Harbor

Generous PTO and work–life balance

Year-end bonuses and referral programs

Firm-paid life insurance and long-term

disability

Employee Assistance Program

Collaborative, respectful, team‑or‑or­

Job summary

Freeman Mathis & Gary, LLP is seeking an experienced Data Analyst for our Atlanta office to build, maintain, and automate firmwide reporting, analytics, and BI capabilities. You will transform manual processes into scalable solutions supporting Finance, Operations, and leadership.

The ideal candidate will be highly proficient in SQL, comfortable with large datasets, and able to communicate effectively with technical and non-technical stakeholders.

Qualifications

• Bachelor’s degree in data analytics, information systems, finance, or related field.
• 3–6+ years of data analysis, reporting, or business intelligence experience.
• Advanced SQL skills required and experience with Power BI.
• Proficiency in Excel with advanced formulas, pivots, and macros.
• Experience with financial or operational data preferred.
• Experience in a law firm or professional services is a plus.
• Exposure to systems like Aderant, Elite, or Litify is a plus.

Responsibilities

• Build and maintain SQL-based datasets and reporting structures to support firmwide financial and operational reporting
• Develop and maintain Power BI dashboards for leadership, Finance, and operational teams
• Replace manual Excel and ad hoc reporting processes with scalable, automated reporting solutions
• Work with Finance, IT, and other departments to gather requirements and translate business needs into reporting solutions
• Analyze and report on key firm performance metrics including revenue, billings, collections, WIP, AR, utilization, and profitability
• Reconcile reporting outputs to source systems and financial data to ensure accuracy and consistency
• Identify discrepancies in reporting and investigate root causes to improve data quality
• Build validation checks and controls into recurring reporting processes
• Document reporting logic, metric definitions, and data transformations
• Create and maintain reusable data assets to improve efficiency and reduce duplication across reporting efforts
• Communicate findings clearly and concisely to stakeholders, including senior leadership
• Work proactively to identify opportunities for process improvement and increased efficiency
• Build relationships across departments to ensure alignment and successful reporting outcomes
• Assist with special projects and additional duties as assigned

Skills

SQL

Power BI

Excel

Communication skills

Attention to detail

Stakeholder management

Project management

Education

Bachelor’s Degree in Data Analytics or related field

Experience: 3–6+ years in data analysis or BI

Tools

Aderant

Elite

Litify

Job description

Freeman Mathis & Gary, LLP is seeking an experienced Data Analyst for our Atlanta office to build, maintain, and automate firmwide reporting, analytics, and BI capabilities. You will transform manual processes into scalable solutions supporting Finance, Operations, and leadership.

The ideal candidate will be highly proficient in SQL, comfortable with large datasets, and able to communicate effectively with technical and non-technical stakeholders.