Senior Financial Systems Analyst/Power BI Developer

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)

OTHER:

• Must be an effective verbal and written communicator
• Must be a self-starter, organized, creative, goal oriented and willing to take ownership of responsibilities and requests
• Must be able to work independently with limited supervision
• Must posse strong relationship management and listening skills
• Must be able to handle stressful situations and mitigate/resolve conflict
• Must have 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
• Must have strong time management skills
• Assist junior analyst where needed
• 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.

Pay Transparency Range:

New York: full-time annualized salary range $103,000 - $145,0000.

DC: full-time annualized salary range $103,000 - $145,0000.

The salary offer will be contingent upon various factors, including but not limited to, relevant experience, internal equity, market data, job location, and other job-related factors permitted by law.

The salary offer will be contingent upon various factors, including but not limited to, relevant experience, internal equity, market data, job location, and other job-related factors permitted by law.

Qualified candidates with arrest or conviction records will be considered for employment in accordance with the following laws if applicable: City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, San Francisco Fair Chance Ordinance, the California Fair Chance Act.

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.