Data Analyst

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 a nationally recognized Am Law 200 law firm with over 500 attorneys servicing clients in 40 offices and 22 states seeking an experienced Data Analyst to join our Atlanta office. The Data Analyst is responsible for building, maintaining, and improving firmwide reporting, analytics, and business intelligence capabilities. This role focuses on transforming manual and fragmented reporting processes into accurate, scalable, and automated reporting solutions that support Finance, Operations, and firm leadership.

The Data Analyst will work across departments to gather requirements, build structured datasets, and deliver dashboards and analysis that provide clear visibility into firm performance. The legal environment is fast-paced and deadline driven, so strong organization, accuracy, and the ability to manage multiple priorities is essential.

Ideal candidates are highly proficient in SQL, comfortable working with large and complex datasets, and able to communicate effectively with both technical and non-technical stakeholders. This role requires strong attention to detail, a systems mindset, and the ability to identify and implement process improvements.

The following set of success factors describe the characteristics of those who are successful in our Firm:

• Unpretentious, Approachable, Respectful, Team Oriented
• Organized, Timely, Confidential, Responsive, (within 24 hours)
• Accountable, Takes Ownership, Corrects Mistakes
• Adept and Creative Problem Solver

Job Responsibilities and Essential Duties

• Build and maintain SQL-based datasets and reporting structures to support firmwide financial and operational reporting
• Replace manual Excel and ad hoc reporting processes with scalable, automated reporting solutions
• Develop and maintain Power BI dashboards for leadership, Finance, and operational teams
• 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

Requirements

• Strong attention to detail and commitment to accuracy, with an understanding of how reporting impacts firm performance and decision-making
• Ability to manage multiple priorities and meet deadlines in a fast-paced environment
• Advanced SQL skills, including joins, aggregations, working with large datasets, and best practices
• Advanced Excel skills, including advanced formulas, pivot tables, macros
• Experience building and maintaining reporting datasets and dashboards using Power BI
• Strong problem-solving and critical thinking skills
• Ability to identify inefficiencies and implement process improvements
• Strong written and verbal communication skills
• Ability to work independently and as part of a team
• Comfortable working with sensitive and confidential information
• Ability to learn new systems and processes quickly

Education and Experience

• Bachelor’s Degree required; degrees in Data Analytics, Information Systems, Business, Finance, or related fields preferred
• 3–6+ years of experience in data analysis, reporting, or business intelligence
• Strong experience with SQL required
• Proficiency with Power BI or similar BI tools required
• Advanced Excel experience required
• Experience working with financial or operational data preferred
• Experience in a law firm, professional services, or similar environment preferred
• Experience with systems such as Aderant, Elite, Litify, or similar is a plus
• Exposure to Python, forecasting, or scenario modeling is a plus

Growth & Development

This role is primarily focused on SQL-based reporting, reporting automation, data accuracy, stakeholder support, and process improvement, with responsibility for translating business reporting needs into reliable dashboards, reusable datasets, and actionable insights.

As reporting processes become more efficient and scalable, we would like the individual in this role to have opportunities to gain exposure to broader analytical work, based on business needs, team priorities, individual performance, and demonstrated capability.

This may include exposure to financial analysis, revenue performance insights, process improvement initiatives, and cross-functional collaboration.

Over time, the role may also provide exposure to:

• Support and contribute to the development of predictive analytics, statistical modeling, forecasting models, and scenario analysis to improve visibility into revenue, collections, and firm performance
• Use Python or similar tools approved by leadership, where appropriate, for data analysis, automation, or modeling tasks

At FMG, people are our greatest asset. We invest in your success and well-being through:

• Competitive compensation
• Medical, dental, and vision coverage
• HSA and FSA options
• 401(k) with 3% employer Safe Harbor contribution
• Generous PTO and work–life balance
• Year-end bonuses and referral programs
• Firm-paid life insurance and long-term disability
• Employee Assistance Program
• A collaborative, respectful, and team-oriented culture

EEO Statement

Freeman Mathis & Gary, LLP (FMG) is committed to providing equal employment opportunities to all applicants and employees by maintaining a workplace free of discrimination based on race, color, religion, sex, national origin, age, disability, genetic information, or any other protected status as provided by law. FMG complies with all applicable federal, state, and local laws. This position is subject to our drug‑free workplace policy, which includes the ability to pass a pre‑employment drug screen. Employees may be subject to reasonable‑suspicion drug testing in accordance with Firm policies outlined in the Employee Handbook.