Manager of Financial Systems

Polsinelli•Edwardsville, IL

7d•Hybrid

About The Position

At Polsinelli, "What a Law Firm Should Be" is not just our tagline, it is what we live every day. We strive to create an environment where our team members are encouraged to bring their creativity and professional passions into the workplace so that they can thrive. Are you a people person who has a keen eye for detail, thrives in a professional environment and wants to be part of a dynamic team? We have the perfect role for an engaging professional like you! Polsinelli is seeking a Manager of Financial Systems. Reporting to the Senior Manager of Financial Analysis, this role can be hired as remote or hybrid, provided the candidate is in a state/jurisdiction wherein we practice. This position oversees a team focused on the delivery of data and metrics from our financial systems. The successful candidate will possess deep technical acumen, extraordinary attention to detail, ability to contribute as a working manager, and employ people-oriented leadership methodologies.

Requirements

3+ years of experience in the legal industry required

Nice To Haves

Extensive background in legal financial reporting and supporting financial applications
Previously held leadership roles within Legal Financial Systems and Financial Reporting operations
2+ years of management experience preferred

Responsibilities

Effectively lead and manage related staff, including assigning and monitoring workloads, arranging for coverage or assistance as needed, recommending training and development, and preparing performance evaluations.
Communicate with manager regarding status of projects and workloads.
Ability to translate financial metrics and KPIs into data queries for ingestion and delivery
Understand the SQL table structures of the various Finance & Accounting software systems needed to develop reporting and ad-hoc queries. Primary data source is 3E.
Study data sources by analyzing and identifying the relationship among data objects and provide proper documentation of the relationships.
Develop and modify SQL functions and stored procedures to extract, transform, and load data.
Manage the architect, analyze, design, test, implement, troubleshoot, and maintain new and existing financial applications utilizing PowerBI.
Collaborate with Finance and Accounting teams to develop reporting using PowerBI and SSRS.
Maintain balance and system coherency between Finance and Accounting applications and existing IT infrastructure.
Deliver data integration by integrating data shared across legacy, new development, and purchased package environments specialized for legal industry.
Demonstrate advanced understanding of SSAS and SSIS and train those in your reporting line.
Exercise appropriate discretion and sound judgment in the execution of the above duties.
Other duties as assigned.
Develop and maintain a positive and collaborative relationship with key internal stakeholders requiring Legal Financial systems and reporting solutions.
Act as owner/decision maker for Legal Financial Systems and Financial Reporting solutions.