Position Summary:

Constangy, Brooks, Smith & Prophete LLP has an opportunity for a Financial Systems Analyst to join the Finance Department in our Atlanta, GA office. The Financial Systems Analyst’s responsibilities include assisting with the day-to-day administration of the Firm’s financial systems, providing support to both administrative and legal personnel, and ensuring financial data integrity. This position reports to the Finance and Reporting Systems Manager. This position will be based in Atlanta, GA with a hybrid remote/in-office schedule.

Essential Duties

• Support our main accounting system Elite Enterprise (migrating to Aderant Sierra) along with other applications including but not limited to (EliteWebview (Time Entry System), ARCS 3G (Collections), Doc Studio, Iridium, Proforma Tracker (BillStream) etc.), and other integrated systems (Chrome River, eBillinghub (, DMS, Zola etc)
• Support of Firm wide Applications i.e. as Microsoft Office Suite, iManage and other Practice Group Apps
• Provide end user support, training, and documentation
• Identify issues, make corrections to processes or data as needed, open support tickets with various vendors and follow through to resolution
• Customize applications as needed
• Maintain security of applications
• Assist with implementing and upgrading various firm applications
• Provide data and reports to Finance and other members of the firm using various tools such as T-SQL, SQL Server Reporting Services (SSRS), and Iridium Cubes via Excel pivots
• Assist in the year end maintenance of all bill rates using SQL and other tools
• Work with the Finance and Reporting Systems Manager to strategize and implement appropriate standards and procedures to ensure the accuracy and integrity of financial reporting
• Assist with importing and exporting of data
• Assist with special projects as required
• Serve as backup for performing month end close duties including account balancing, proforma generation, and month end reporting
• Create, design, and document Standard Operating Procedures (SOP) also known as team policies, procedures, and guidelines
• Participate in on-call rotation to provide afterhours coverage

Skills & Qualifications

• Bachelor’s degree in Information Systems or Accounting/Finance from an accredited college or university strongly preferred, but BA or BS in relevant fields will be considered
• 3-5 years of Financial Systems/IT support experience required, any equivalent combination of training, education, and experience that demonstrates the ability to perform the duties of the position will be considered
• Proficiency in T-SQL
• Knowledge of Elite/Aderant database structure is a must, with previous Aderant Sierra software experience or migration experience a plus
• Understanding of accounting and financial transaction workflows
• Advanced Excel skills (vlookups, pivot tables, creating and maintaining external data sources etc.)

Qualities Ideal Candidates Will Have:

• Excellent oral and written communication skills, including the ability to interpret communications from a variety of sources and the ability to explain complex technical items to personnel in different capacities
• Ability to work independently and proactively to solve problems and accomplish goals.
• Ability to build, maintain, and deliver a high level of professional customer service
• Attention to detail and fostering strong positive working team relationships with all internal and external contacts
• Must maintain confidentiality of all matters
• Thorough understanding of firm and finance department policies and procedures, the ability to identify issues and enforce compliance
• Excellent organizational skills and the ability to prioritizing workload
• Works well under pressure and can balance multiple competing priorities
• Self-starter, able to identify and resolve incidents and problems without supervision, and see projects through to completion

• Benefits: Comprehensive HDHP health plan, dental plan, and vision plan; Teladoc coverage for remote medical care; HSA for medical, and dependent care FSA; Competitive paid time off (PTO) available and increasing with tenure at the firm; 4 hours PTO for medical appointments; 11 paid holidays, including the observation of Juneteenth; life and AD&D coverage through Unum; short-term and long-term disability insurance; identity theft protection; pet insurance; AFLAC and umbrella coverage available; Employee Assistance Program; 401(k) savings plan with matching and profit sharing contribution; paid parental leave; emergency travel assistance; student loan refinancing options and financial planning assistance; onsite parking and/or public transportation subsidies; monthly gym reimbursement.
• These benefits are subject to change

Constangy, Brooks, Smith & Prophete LLP requires all employees to be vaccinated against COVID-19 or to have received an approved accommodation based on medical condition or sincerely held religious belief or practice, or as otherwise required by applicable law.

Constangy, Brooks, Smith & Prophete LLP is an Equal Employment Opportunity employer committed to providing equal opportunity in all of our employment practices, including but not limited to selection, hiring, assignment, re-assignment, promotion, transfer, and compensation. Our Firm prohibits discrimination, harassment, or retaliation in employment based on race, color, religion, national origin, sex (including pregnancy), gender, gender expression or identity, change of sex or transgender status, sexual orientation, age, disability, genetic information, citizenship status, military or veteran status, or any other category protected by applicable federal, state, or local law.

This position is OPEN to receiving candidates from recruiters. Please contact Thomas Reddington-Kincaid, Legal Recruiting Specialist at treddington@constangy.com