Financial Systems Database Developer
About The Position
This position involves maintaining and enhancing the Cloud-based TCA Information Management System (CTIMS), a Microsoft Access relational database used to manage the TCA and USSOUTHCOM Debit Card Programs. The role requires developing IT solutions that integrate CTIMS with various financial and logistical systems to ensure financial auditability and maintain 99% system availability. Responsibilities span from developing tools for capturing event information and managing concepts to building electronic workflows, user permissions, and financial reporting tools. The developer will integrate and reconcile data from multiple systems, maintain the Debit Card module, manage per diem tables, develop training materials, and ensure system operational availability. Data migration to SharePoint and maintenance of the TCA SharePoint site are also key aspects of the role.
Requirements
- Ten (10) years of in-depth experience using Microsoft Access, Visual Basic, and Structured Query Language (SQL).
- Knowledge of SQL Server.
- Five (5) years of in-depth knowledge of GFEBS financial systems and fiscal code, including GFEBS file compatibility and integrity checks prior to CTIMS integration.
- Experience with the Army Planning Programming Budget Execution System (APPBES) cycle and Program Objective Memorandum (POM) formulation and standard command budget cycle requirements.
- In-depth knowledge of the U.S. Debit Card Program and the Deployable Disbursing System (DDS).
- Experience designing and developing interoperability solutions for stand-alone systems.
- Ability to import/export HTML, MS Office, PDF, and XML formats (XML integration with TED/SOCIUM essential).
- Familiarity with CTIMS, GFEBS, DTS, TED, SOCIUM, C2IE, DDS, Meta Bank, and SharePoint.
- Security+ certification.
- IA/IT training certification and DoD 8570.01-M baseline certification (required at contract award per DFARS 252.239-7001 and AR 25-2).
- Microsoft Access certification.
Nice To Haves
- Bachelor's degree, preferred in a Science, Technology, Engineering, or Math (STEM) field.
Responsibilities
- Provide and modify CTIMS tools to capture TCA event information and manage 1,400 to 1,700 multi-year concepts.
- Build electronic staffing/workflow, user permissions, workload queues, and approval messaging in CTIMS.
- Develop financial reporting tools and reconciliations to comply with governmental accounting formats.
- Integrate GFEBS financial data into CTIMS and reconcile discrepancies daily; update WBS codes and the CTIMS-GFEBS interface each fiscal year.
- Integrate and update CTIMS data weekly with TED, SOCIUM, and C2IE, including XML import compatibility.
- Develop and maintain the Debit Card module, integrating GFEBS, DDS, and bank data into a single display.
- Pull and post DTMO per diem tables.
- Develop training materials, and train CTIMS users.
- Maintain CTIMS at 99% operational availability.
- Apply Microsoft Office and software updates, and adhere to SOUTHCOM SEI policy.
- Migrate prior-year CTIMS data to SharePoint and maintain the TCA SharePoint site.
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
Senior
