Job Description

King & Spalding is a leading global law firm with a commitment to excellence, innovation, and the seamless delivery of legal services. We harness innovative technology and exceptional talent to meet the complex needs of our clients in a fast-paced and dynamic legal landscape.

The Senior Financial Systems Analyst will work within a project team to analyze, document, and communicate the user requirements enabled by the Finance technology solutions. This position provides support for end-users, on-going maintenance, and functional know-how. The role will be key in project work to provide technical and functional design, coding, testing, and implementation of new reports/software, along with modifications to existing reports/software. The Senior Financial Systems Analyst will provide application integration solutions to improve staff’s ability to efficiently use the financial systems. They will implement best practices for data access, report development, design, and support.

KEY RESPONSIBILITIES:

Project/ Business Analysis:

• Design and develop PowerBI dashboards, reports, and semantic models for the Firm’s Finance reporting
• Partner with Finance, IT, and Firm leadership to gather requirements and translate business needs into scalable BI solutions.
• Build optimized data models using SQL, Power Query, and DAX
• Ensure data accuracy, consistency, governance, and security in all reporting solutions
• Optimize performance and dataset scalability
• Document needs and the proposed solution(s)
• Lead project and designated development person(s) to design and implement the solution
• Work with members of other teams, primarily within the IT organization, to resolve technical problems that may arise
• Handle multiple projects and priorities simultaneously
• Gather input and implement solutions across the organization
• Develop process flow documentation
• Design improved business processes and supporting systems to advance Finance’s goals and objectives
• Develop test plans and lead user acceptance testing sessions

Custom Report Development and Maintenance:

• Work with various groups and levels in the organization to define their financial reporting requirements in an effort to advance the Firm’s reporting strategy
• Create detailed specifications for custom dashboards/reports, inquiries and system modifications
• Document requirements and design of custom dashboards/reports, inquiries and forms for financial systems. Manage the creation and testing of said reports, forms and inquiries.
• Develop custom dashboards/reports and inquiries

End User Support:

• Provide support for users of the finance applications within the firm

Financial System Maintenance:

• Communicate Finance department needs with the IT department to ensure Finance department hardware and software requirements are met efficiently and effectively
• Play a support role in financial system security set-up and maintenance (both front-office and back-office)

QUALIFICATIONS:

• Bachelor’s degree
• 5 – 8 years’ experience in a law firm or corporate environment preferred
• Minimum three years’ experience with relational databases, data validation, and report writing - SQL, Power BI or similar strongly preferred
• Proficient in Microsoft Office Suite
• Minimum two years’ experience in accounting or finance
• Experience with large ERP (Aderant ERP system is a plus)
• Ability to work independently with limited supervision
• Strong relationship management and listening skills
• Ability to handle stressful situations and mitigate/resolve conflict
• Strong problem solving and analytic skills to research and provide solutions
• Must be a strong team builder, an effective motivator and aware of the importance of attention to detail
• Strong time management skills
• Must possess a sound understanding of project management principles and methodologies including project scope, problem/change management, project estimating, project leadership, project management tools, project scheduling, project quality assurance, project reporting, project risk management and meeting management
• Appropriate skills in working with relational databases, data validation and report writing software

The firm offers a generous total compensation package with bonuses and raises awarded in recognition of individual merit-based performance. All full-time Business Services employees may participate in King & Spalding’s comprehensive benefit program including health and wellness plan, life and disability insurance, flexible spending accounts and a health savings account, a 401(k) plan, profit sharing plan, and a substantial Paid Time Off (PTO) program.

King & Spalding LLP (K&S) is committed to providing equal employment opportunity to all applicants and employees in full compliance with all state, federal, and local laws prohibiting discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, genetic information, age, disability or any other status protected by applicable law.

We are proud of our remarkably cohesive culture, which now encompasses more than 2,500 lawyers and business professionals worldwide. We seek to attract and develop the very best talent to work with us.