Lead Financial Systems Developer
About The Position
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.
Requirements
- Bachelor's degree (B.A.) from a four-year college or university in Information Systems or related discipline
- 3+ years of experience with the following: SQL Server, SSIS, SSAS, SSRS, Visual Studio, Power Platform, Azure Cloud, and .NET Framework
- Proficiency in Microsoft Office Suite including creating and utilizing spreadsheets as well as accounting system applications
- Must have advanced Excel spreadsheet experience
Nice To Haves
- Knowledge of standard accounting policies and procedures and/or law firm operations is a plus.
Responsibilities
- Research, design, development, implementation and integration of financial systems
- 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
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
