Cozen O’Connor is seeking an experienced and forward-thinking Senior Financial Systems Engineer to join our Financial Systems team. This role will serve as a senior technical resource responsible for the design, development, implementation, support, and continuous improvement of integrations, reporting solutions, and automated processes supporting the firm's Finance organization, with a primary focus on Aderant Expert. This position reports to the Manager of Financial Systems.
Responsibilities
- Provide technical leadership and expertise related in the design, development, implementation, and support of integrations between financial systems and enterprise applications, collaborating across Finance and IS teams.
- Lead the technical aspects of financial systems projects, including requirements gathering, solutions design, testing, implementation, and continuous process improvement.
- Partner with Finance and IS stakeholders to evaluate business requirements, recommended solutions and enhancements, and identify opportunities to improve existing systems, processes, and reporting.
- Design, develop, maintain, and troubleshoot integrations between Aderant Expert and other financial, business, and enterprise applications using Microsoft technologies, including SQL Server Integration Services (SSIS).
- Design, develop, optimize, and support SQL Server database solutions, including complex T-SQL queries, stored procedures, views, functions, and other database objects that support financial applications, reporting, integrations, and automation.
- Design, develop, and maintain reporting solutions utilizing SQL Server Reporting Services (SSRS) and other reporting tools to deliver operational, financial, and ad hoc reporting capabilities.
- Create and maintain comprehensive technical documentation for financial applications, integrations, automated processes, and reporting solutions.
Qualifications
- Bachelor’s degree in finance or IS related field, or equivalent.
- 7-10 years of experience supporting financial systems, business applications, and SQL Server databases.
- Experience with Aderant Expert, including database structures, APIs, and integration technologies, or a comparable enterprise financial management platform.
- Strong experience with Microsoft SQL Server and T-SQL, including database development, query optimization, performance tuning, data analysis, data validation, and troubleshooting complex relational data issues.
- Experience designing, developing, and supporting SQL Server Integration Services (SSIS) packages and related integration solutions.
- Experience developing reports using SQL Server Reporting Services (SSRS) and other reporting tools.
- Experience working with Microsoft Visual Studio and related development tools; Power BI experience preferred.
- Experience working with AI and machine learning technologies preferred.
- Demonstrated ability to independently own and drive technical initiatives from requirements gathering through design, development, implementation, and ongoing support with minimal supervision.
- Proven ability to effectively prioritize and manage multiple concurrent projects, production support responsibilities, and competing business demands while consistently meeting deadlines.
- Strong sense of ownership, accountability, and urgency, with the ability to quickly assess issues, determine appropriate solutions, and execute effectively in a fast-paced environment.
- Strong written and verbal communication skills, including the ability to translate complex technical concepts into business terms for different audiences and build comprehensive technical documentation.
- Detail-oriented with excellent organizational, analytical, problem-solving, decision-making, and customer service skills.
- Ability to work effectively both independently and collaboratively across Finance, IS, vendors, and other business stakeholders.
- Experience working with highly sensitive or confidential financial and client information.
The salary range for this role is $135,000 - $170,000 and represents the Firm’s good faith and reasonable estimate of the range of possible compensation at the time of posting. Actual compensation will be dependent upon a number of factors, including but not limited to, the candidate’s relevant experience, qualifications and location.
Company
Cozen O’Connor is committed to fostering greater inclusion in the legal profession. We understand the organizational effectiveness that comes from welcoming and valuing differences within the firm, and we know that assembling a team with a breadth of perspectives and experience is necessary to provide the highest quality legal service. We encourage candidates to apply and join us in this effort.
Bachelor's degree in finance or IS; 7-10 years supporting financial systems and SQL Server; experience with Aderant Expert, T-SQL, SSIS, SSRS, Visual Studio; ability to work independently and handle confidential data.
Key Responsibilities
- designing integrations
- developing reports
- supporting databases
Skills & Tools
Aderant Expert, Microsoft SQL Server, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Visual Studio, Power BI
Job Details
- Category: Information Technology
- Seniority: Senior Level
- Commitment: Full Time
- Workplace: Remote — United States
- Salary: USD 135,000 – 170,000 / year
- Languages: English
About Cozen O'Connor
A law firm providing litigation, business law, and government relations services. — Industry: Finance