Data Analyst
5+ years
Atlanta, GA
Full-time
Onsite
1 month ago
About the role
Freeman Mathis and Gary, LLP is a rapidly growing, national specialty litigation firm 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:
Job Responsibilities and Essential Duties
Requirements
Education and Experience
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:
At FMG, people are our greatest asset. We invest in your success and well-being through:
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.
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:
- Helpful, Congenial, Personable, Positive
- 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.
Skills
Law Practice