Senior Financial Systems Engineer

Cozen O'Connor; Philadelphia (Philadelphia County); In loco; USD 135.000 - 170.000; Tempo pieno

Descrizione del lavoro

Cozen O'Connor is seeking a Senior Financial Systems Engineer to own the design, development, and support of integrations and reporting for the Finance organization, with a focus on Aderant Expert. You will lead projects, gather requirements, and deliver scalable solutions across Finance and IS teams.

Expect to design and optimize SQL Server databases, develop SSIS/SSRS packages, and produce operational and ad hoc reports. Strong communication and documentation skills are essential for success.

Competenze

• 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 SSIS packages and related integration solutions.
• Experience developing reports using SSRS and other reporting tools.
• Experience with Microsoft Visual Studio and related development tools; Power BI experience preferred.
• Ability to independently own and drive technical initiatives from requirements gathering through design, development, implementation, and ongoing support with minimal supervision.
• Proven ability to prioritize and manage multiple concurrent projects and production support while meeting deadlines.

Mansioni

• Provide technical leadership in design, development, and support of integrations between financial systems and enterprise apps.
• Lead technical aspects of financial systems projects from requirements to implementation and improvement.
• Partner with Finance and IS stakeholders to evaluate requirements and identify improvements.
• Design, develop, and maintain integrations between Aderant Expert and other apps using SSIS.
• Design, develop, and maintain SQL Server databases and complex T-SQL objects to support reporting and automation.
• Design and maintain SSRS reporting solutions for operational and financial reporting.
• Create and maintain comprehensive technical documentation for applications, integrations, and reporting.

Conoscenze

Aderant Expert

SQL Server

SSIS

SSRS

Power BI

AI/ML concepts

Technical leadership

Formazione

Bachelor's degree in finance or IS-related field

Strumenti

Aderant Expert

SQL Server

SSIS

SSRS

Power BI

Descrizione del lavoro

Job Description 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.

About Us

Known for its commitment to action and tangible results, Cozen O'Connor has rapidly grown to become one of North America's fastest-growing law firms. Offering full-service expertise in litigation, business law, and government relations, the firm serves a diverse clientele, including global Fortune 500 companies, growing middle-market firms, startups, and high-profile individuals. Established in 1970, Cozen O'Connor has more than 1,000 attorneys who help clients manage risk and make better business decisions. The firm counsels clients on their most sophisticated legal matters in all areas of the law, including litigation, corporate, and regulatory law. Representing a broad array of leading global corporations and middle market companies, Cozen O'Connor services its clients' needs through 35 offices across two continents. The firm is consistently ranked among the top 100 law firms in America and has received recognition from prestigious legal and business organizations such as Chambers & Partners, The American Lawyer, The Legal 500, and Best Lawyers. Cozen O'Connor is dedicated to excellence and strives to achieve the right results for its clients, no matter how complex or critical the legal challenges.

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. Cozen O'Connor actively welcomes applicants who have previously left the workforce and are looking to return to their careers. Gaps in experience are not penalized. Cozen O'Connor is an Equal Opportunity Employer, including disabled and veterans.