Financial Systems Data Developer

Position Summary:

As a member of the firms Pricing team the Financial Systems Data Developer develops maintains and troubleshoots code and reports in support of the Pricing function. This position requires advanced technical expertise to design and deploy complex SQL queries SSRS reports and dashboards as well as an in-depth understanding of law firm financial systems.

Key Responsibilities:

• Designs advanced SQL queries to support financial reporting and matter budgeting

• Develops and maintains advanced SSRS report layouts shared datasets and report deployments

• Implements and manages SSRS data-driven subscriptions including generating subscription data via SQL stored procedures and formatting subscription comments with HTML

• Translates written requirements from the Pricing team into fields and/or calculations necessary to satisfy reporting needs

• Collaborates with team members to ensure financial systems meet firm and client objectives

• Develops maintains and enhances a variety of financial reports to support budgeting forecasting billing profitability analysis and client reporting including:

• Monthly and quarterly financial statements

• Revenue and expense tracking by matter client or practice group

• Budget vs. actual performance analysis

• Client-specific pricing and profitability dashboards

• Trend analysis and forecasting reports

• Ad hoc analysis to support strategic decision-making and pricing negotiations

• Integration of financial data sources for comparative and benchmarking purposes

• Leverages AI tools to automate report generation perform predictive analytics identify data anomalies and improve data accuracy and insight for financial reporting

• Demonstrates intermediate to advanced familiarity with Aderant or Elite databases and user interfaces

• Assists with overflow work and other projects as needed and performs additional duties and responsibilities as assigned

Qualifications

Skills & Competencies

• Significant experience with legal financial applications (Aderant preferred; Elite acceptable)

• Experience working in a fast-paced law firm environment with diverse needs

• Advanced proficiency with SQL Server Reporting Services (SSRS); .NET development experience a plus

• Experience with PowerBI; familiarity with SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS)

• High degree of familiarity with financial system database structures

• In-depth understanding of and experience supporting financial applications and databases

• Strong commitment to deadlines and willingness to meet the needs of a 24x7 environment

• Excellent analytical problem-solving and organizational skills

• Experience utilizing AI-powered analytics tools to improve reporting efficiency accuracy and predictive capabilities

• Some experience developing web applications to support pricing functions allowing for enhanced data entry workflow automation and improved accessibility of pricing and financial analysis tools

Education & Prior Experience

• Bachelors Degree preferred; equivalent experience considered

• Minimum two years experience in developing supporting and customizing financial reporting systems

Technology

• Proficiency in SQL SQL Server Reporting Services (SSRS) and PowerBI

• Familiarity with Aderant or Elite financial systems

• Experience with SQL Server Integration Services (SSIS) SQL Server Analysis Services (SSAS) development a plus

• Ability to leverage AI tools for analytics and reporting

• Exceptional computer skills with the ability to learn new software applications quickly

GT is an EEO employer with an inclusive workplace committed to merit-based consideration and review without regard to an individuals race sex or other protected characteristics and to the principles of non-discrimination on any protected basis.