Lead Financial Systems Developer

Shook, Hardy & Bacon L.L.P.; United States; Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Disability insurance

Life insurance

Retirement plan

Paid time off

Job summary

A leading law firm is seeking an experienced professional to provide research and development of financial systems in a hybrid role. The applicant should have robust SQL expertise and experience with tools like Power BI and SSRS. The position involves collaboration with financial analysts and requires discretion in executing duties, while also offering a comprehensive salary and benefits package.

Qualifications

• Experience with financial systems and integrations for finance and accounting functions.
• Strong SQL skills, including writing functions and stored procedures.
• Experience with data reporting tools such as Power BI and SSRS.
• Ability to work in a hybrid environment and collaborate with cross-functional teams.

Responsibilities

• Architect, analyze, design, test, implement and maintain financial applications.
• Collaborate to develop reports using Power BI and SSRS.
• Deliver data integration across various environments.
• Collaborate with Financial and Pricing Analysts to develop reports using Power BI and SSRS.
• Deliver data integration by integrating data across legacy, new development, and purchased package environments specialized for the legal industry.
• Study data sources by analyzing relationships among data objects.
• Develop and modify SQL functions and stored procedures to extract, transform, and load data.
• Demonstrate advanced understanding of SSAS and SSIS and train others in your reporting line.
• Exercise discretion and sound judgment in the execution of duties.

Skills

SQL skills

Power BI

SSRS

SSAS

SSIS

Tools

3E

SSAS

SSIS

Job description

Overview

This position is hybrid based out of our Kansas City, MO office. Provides research, design, development, implementation and integration of financial systems to support the finance and accounting functions of the firm. Architect, analyze, design, test, implement, troubleshoot and maintain new and existing financial applications. Maintain balance and system coherency between Finance and Accounting applications and existing IT infrastructure. Collaborate with Financial and Pricing Analysts to develop reports using Power BI and SSRS. Deliver data integration by integrating data across legacy, new development, and purchased package environments specialized for the legal industry. Studies data sources by analyzing relationships among data objects. Develop and modify SQL functions and stored procedures to extract, transform, and load data. Demonstrate advanced understanding of SSAS and SSIS and train others in your reporting line. Exercise discretion and sound judgement in execution of duties.

Responsibilities

• Architect, analyze, design, test, implement, troubleshoot and maintain new and existing financial applications.
• Maintain balance and system coherency between Finance and Accounting applications and existing IT infrastructure.
• Understand SQL table structures of the various Finance & Accounting software systems to develop reporting and ad-hoc queries. Primary data source is 3E.
• Collaborate with Financial and Pricing Analysts to develop reports using Power BI and SSRS.
• Deliver data integration by integrating data across legacy, new development, and purchased package environments specialized for the legal industry.
• Study data sources by analyzing relationships among data objects.
• Develop and modify SQL functions and stored procedures to extract, transform, and load data.
• Demonstrate advanced understanding of SSAS and SSIS and train others in your reporting line.
• Exercise discretion and sound judgment in the execution of duties.

Qualifications

• Experience with financial systems and integrations for finance and accounting functions.
• Strong SQL skills, including writing functions and stored procedures; familiarity with SQL tables in Finance/Accounting software; knowledge of 3E as a primary data source.
• Experience with data reporting tools such as Power BI and SSRS; familiarity with SSAS and SSIS; ability to train others.
• Ability to work in a hybrid environment and collaborate with cross-functional teams.

Benefits

Shook, Hardy & Bacon provides a competitive salary and comprehensive salary and benefits package for professional staff which includes medical, dental, vision, disability and life insurance, retirement plan with a generous contribution plan, and paid time off.