Financial System Analyst

Modern Technology Solutions Inc•Dayton, OH

13d•Onsite

About The Position

MTSI is currently seeking to hire a Financial System Analyst to join our Finance team. This role can be located in Huntsville, Alabama or Dayton, Ohio. We are seeking an accomplished technology leader with deep expertise in Deltek Costpoint, enterprise system integrations (including SAP/HR, ADP and Workday Adaptive), and advanced SQL/PL-SQL development. This senior-level role is responsible for defining technical architecture, integration strategy, and data governance framework supporting mission-critical financial, HR, and business operational processes. The Financial System Analyst will drive long-term modernization initiatives, ensure data integrity across the enterprise ecosystem, and provide strategic guidance to technical teams and business stakeholders. The ideal candidate excels at translating business requirements into efficient, scalable technical solutions while maintaining system stability, data accuracy, and process automation.

Requirements

Bachelors degree with 10 years related experience.
Must have an active Secret clearance; US Citizenship required.
Extensive hands-on experience with Deltek Costpoint, including configuration, data structures, workflows, integrations, and reporting.
Expert-level SQL and PL/SQL skills, including query optimization, performance tuning, complex troubleshooting, and advanced reporting techniques.
Strong experience architecting integrations using APIs, web services, middleware platforms, or cloud-based integration technologies.
Working knowledge of database platforms such as Oracle and SQL Server.
Deep understanding of enterprise finance, and procurement workflows in Costpoint
Proven ability to design and lead implementations, upgrades, and modernization initiatives.
Strong analytical skills with the ability to diagnose and resolve complex technical issues.
Excellent communication skills, capable of presenting technical strategies to technical and non-technical audiences.

Nice To Haves

Experience with Deltek Time & Expense, Costpoint BI tools, Enterprise reporting/analytics platforms, ADP, SAP/HR, Workday Adaptive, Excel, ODBC connections.
Familiarity with HR systems, financial forecasting tools, data management platforms, and evolving enterprise architecture patterns.
Background in government contracting or other highly regulated industries.
Experience mentoring analysts, developers, and integration engineers.

Responsibilities

Lead the architectural design, roadmap planning, and governance for Costpoint and its integrations with enterprise systems.
Serve as the highest-level technical authority for Costpoint configurations, data models, security design, workflows, and custom solutions.
Design, build, and maintain integrations between Costpoint and internal/external systems (HRIS, financial systems, procurement tools, data warehouses, etc.). Architect scalable, secure integration frameworks using APIs, middleware, ETL pipelines, and event-driven processes.
Develop SQL and PL/SQL scripts to support reporting, data validation, performance tuning, and system automation.
Serve as the primary liaison with Deltek Support to engineer resolutions, manage escalations, and investigate complex issues.
Troubleshoot integration failures, data discrepancies, and system performance challenges, ensuring effective and timely resolution.
Collaborate with cross-functional teams (Finance, Payroll, HR, IT, Procurement, Program Control) to gather requirements and deliver scalable, reliable technical solutions aligned with strategic business objectives.
Support system upgrades, patches, enhancements, and related data interface updates.
Maintain strong data integrity across systems through robust testing, documentation, quality controls, and monitoring practices.
Provide technical leadership and best practices for Costpoint integrations, database optimization, system architecture, and change management processes.