Financial Systems Analyst

ATI builds and manages collaborations that conducts research and development of new technologies to solve our nation's most pressing challenges. Our collaborations are custom-built teams of organizations from industry and academia that develop novel technologies for the federal government. Traditionally, these processes are complicated and burdensome. That's where ATI comes in. We simplify and streamline processes to make it all work.

When you work at ATI, you become a part of something larger than yourself. Our collective work - no matter what department or division you work in - ultimately enables the warfighter, saves lives, and diversifies the industrial base. At our core, ATI is a service organization. We are in service to others; it's what we do, and it's who we are.

The Financial Systems Analyst (FSA) serves as the primary architect, administrator, and technical owner of our financial technology stack. This role bridges the gap between Corporate Finance and Information Technology.

The ideal candidate possesses deep technical software development skills (TM1 Rules, Feeders, and TI Processes) combined with a solid understanding of corporate finance and government contracting accounting structures.

We offer a hybrid schedule (in-office & remote/work from home) or an onsite schedule and flexible hours. Candidates will need to reside near Charleston, SC to ensure work site flexibility.

• Architect Models:
  Design, build, test, and deploy TM1 cubes, dimensions, hierarchies, attributes, and subsets to support new budgeting and forecasting workflows.
• Write Code:
  Author and maintain advanced TM1 Rules (.rux) and optimize memory performance using precise Feeders to prevent server RAM inflation.
• Build Dashboards:
  Create intuitive, self-service entry templates, reports, and visualization dashboards natively inside IBM Planning Analytics Workspace (PAW) and Excel Pax.
• Manage Continuous Upgrades:
  Maintain a development backlog to continuously refactor legacy code, streamline calculations, and automate manual finance tasks.

• Automate ETL:
  Build and manage automated Turbo Integrator (TI) processes to extract, transform, and load actuals data from Deltek Costpoint into TM1.
• Maintain Master Data:
  Ensure data integrity by mapping and reconciling Costpoint account segments, project structures, and indirect cost pools cleanly to TM1 dimensions.
• Reconcile Systems:
  Build and monitor automated data validation scripts to guarantee that TM1 actuals match Costpoint General Ledger balances down to the penny.

• Administer Security:
  Provision user accounts, manage security groups, and enforce cell-level data security to protect sensitive payroll, project, and corporate data.
• Manage Forecasting Workflow:
  Oversee month-end and annual budget initialization, manage template access, track submission statuses, and lock cells post-submission.
• Train & Support Users:
  Act as the Tier 1 technical helpdesk for internal finance users, troubleshooting template issues and creating standard operating procedures (SOPs).

• Perform other duties as assigned.

• Required Technical
  
  Skills:
  • Minimum 3-5 years of hands‑on experience building and administering IBM TM1 / Planning Analytics.
  • Advanced proficiency in writing TM1 Turbo Integrator (TI) scripts, dynamic MDX expressions, and TM1 Rules/Feeders.
  • Strong working knowledge of Deltek Costpoint core modules (General Ledger, Project Setup, Labor) and its underlying SQL database/table structures.
  • Expert proficiency with IBM PAW, Planning Analytics for Excel (Pax), and legacy Perspectives.
• Required Professional
  
  Experience:
  • Bachelor's degree in Finance, Accounting, Management Information Systems (MIS), Computer Science, or a related field.
  • Clear understanding of core corporate finance concepts (P& L, Balance Sheet, Cash Flow, Variance Analysis).
  • Strong analytical mindset with the ability to translate complex business budgeting requirements into scalable technical architecture.
  • Excellent communication skills to explain technical systems…