Lead Financial Systems Developer

Hybrid remote Lead Financial Systems Developer role in Kansas City, MO with Shook, Hardy and Bacon, focused on designing, building, implementing, and integrating financial systems to support the firm’s finance and accounting operations.

Responsibilities

• Lead research, design, development, implementation, and integration of financial systems that support the firm’s finance and accounting functions.
• Architect, analyze, design, test, implement, troubleshoot, and maintain new and existing financial applications.
• Maintain balance and coherence between Finance and Accounting applications and the existing IT infrastructure.
• Understand SQL table structures across Finance and Accounting software 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 consolidating data across legacy, new development, and purchased package environments tailored for the legal industry.
• Study data sources by analyzing and identifying relationships among data objects.
• Develop and modify SQL functions and stored procedures to extract, transform, and load data.
• Demonstrate advanced knowledge of SSAS and SSIS and train peers in reporting.
• Exercise discretion and sound judgment in the execution of duties.

Requirements

• Bachelor's degree in Information Systems or related discipline from a four-year college or university.
• 3+ years of experience with SQL Server.
• 3+ years of experience with SSIS.
• 3+ years of experience with SSAS.
• 3+ years of experience with SSRS.
• 3+ years of experience with Visual Studio.
• 3+ years of experience with Power Platform.
• 3+ years of experience with Azure Cloud.
• 3+ years of experience with .NET Framework.
• Or equivalent combination of education and experience.
• Knowledge of standard accounting policies and procedures and/or law firm operations is a plus.
• Proficiency in Microsoft Office Suite including creating and utilizing spreadsheets as well as accounting system applications.
• Must have advanced Excel spreadsheet experience.

Technologies

• SQL Server
• SSIS
• SSAS
• SSRS
• Visual Studio
• Power Platform
• Azure Cloud
• .NET Framework
• Power BI
• 3E
• Microsoft Office Suite