Manager of Financial Systems

Description Polsinelli does not accept unsolicited resumes from search firms or agencies. Please, no phone calls or emails. 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. POSITION OVERVIEW 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. CORE 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. Employees approved for flexible work arrangements are expected to be available and maintain a practice of reliable, consistent attendance at all times during the employees scheduled work shift including, but not limited to, Zoom/messaging, email and voicemail, and by phone. PREFERRED COMPETENCIES Extensive background in legal financial reporting and supporting financial applications Previously held leadership roles within Legal Financial Systems and Financial Reporting operations TECHNICAL REQUIREMENTS 3+ years of experience in the legal industry required 2+ years of management experience preferred IMMEDIATE POSITION GOALS Develop and maintain a positive and collaborative relationship with key internal stakeholders requiring Legal Financial systems and reporting solutions. 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. Manage the architecture, analyze, design, test, implement, troubleshoot, and maintain new and existing financial systems and reporting solutions utilizing Elite 3E, PowerBI, Intellistat, Data Insights and SSRS as appropriate. Act as owner/decision maker for Legal Financial Systems and Financial Reporting solutions. The budgeted salary range for this position is $185,000 - $200,000. As part of full-time employment associated with this position, Polsinelli PC offers the following benefits: Paid time off, sick time off, a referral program, medical insurance and benefits, dental insurance, vision insurance, life insurance, AD&D insurance, ID Theft insurance, long-term disability benefits, short-term disability benefits, Parking/Transit reimbursement (varies depending on location), 401(k) benefits, and employee assistance benefits. Polsinelli PC is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, or any other characteristic protected by law. Qualifications Skills Behaviors Preferred Team Player : Works well as a member of a group Loyal : Shows firm and constant support to a cause Detail Oriented : Capable of carrying out a given task with all details necessary to get the task done well Dedicated : Devoted to a task or purpose with loyalty or integrity : Motivations Preferred Self-Starter : Inspired to perform without outside help Flexibility : Inspired to perform well when granted the ability to set your own schedule and goals Ability to Make an Impact : Inspired to perform well by the ability to contribute to the success of a project or the organization : Education Required Bachelor's or better. Experience Required 3 years: Experience working in the legal industry. Preferred 2 years: Management experience.