What are the responsibilities and job description for the Lead Financial Systems Developer position at Shook, Hardy and Bacon?
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 application.
Maintain balance and system coherency between Finance and Accounting applications and existing IT infrastructure.
Understand the SQL table structures of the various Finance & Accounting software systems needed to develop reporting and ad-hoc queries. Primary data source is 3E.
Collaborate with Financial and Pricing Analysts to develop report using Power BI and SSRS.
Deliver data integration by integrating data shared across legacy, new development, and purchased package environments specialized for legal industry.
Studies data sources by analyzing and identifying the relationship 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 those in your reporting line.
Exercise appropriate discretion and sound judgment in the execution of the above duties.
#LI-SH1
#LI-HYBRID
Qualifications:
Bachelor's degree (B.A.) from a four-year college or university in Information Systems or related discipline; and 3 years of experience with the following: SQL Server, SSIS, SSAS, SSRS, Visual Studio, Power Platform, Azure Cloud, and .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.