Vacancy Name
Financial Systems Analyst

Vacancy No
VN764

Employee Type
Full-time

Location City
Summerville

Education Level
Bachelor's Degree

Experience Level
4 years

Position Description

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.

Apply at ATI.ORG; we only accept applications submitted through our applicant tracking system.

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.

Essential Functions

1. System Administration & Development

• 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.

2. Data Integration & Pipeline Management

• Automate ETL: Build and manage automated TurboIntegrator (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.

3. User Support, Security & Governance

• 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).

Additional Responsibilities

• Perform other duties as assigned.

Qualifications

• Required Technical Skills:
  • Minimum 3-5 years of hands-on experience building and administering IBM TM1 / Planning Analytics.
  • Advanced proficiency in writing TM1 TurboIntegrator (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 logic to non-technical finance professionals.
• Preferred Qualifications:
  • Experience working within a government contracting environment.
  • Familiarity with Costpoint indirect cost pools
  • Experience integrating IBM TM1 and PowerBI
• Must successfully pass a background and credit check to access sensitive information and automated systems.
• Employee must be a U.S. citizen by birth or naturalization, or a green card lawful U.S. permanent resident, or a political asylum in the U.S. Individual must meet the definition of "a U.S. person" upon hire due to the risk assessment of this position.
• This position is subject to a background check that includes a review of criminal records. In reviewing an applicant's criminal history, the company will consider prior criminal convictions that have a relationship to the job duties and responsibilities of the position. The company considers the nature of the crime, the time that has elapsed since the crime and the job duties for the position at issue in making an individualized determination. Individuals may be excluded when the company determines, based on the above factors, that hiring, transferring or promoting the applicant would pose an unreasonable risk to the business, its employees or its customers and vendors.
• If you are a qualified candidate, we encourage you to apply even if you have a prior criminal conviction(s). Convictions will not automatically disqualify the candidate, However, conviction(s) will be considered and balanced against the age of the candidate at the time of the offense, time elapsed since the offense, type of offense, potential impacts of such on the work environment, sensitivity of the position(s) available/sought, and similar independent factors relevant to the employment requirements at ATI.

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Regular physical activity to include walking, bending, stooping, reaching, standing and prolonged sitting.

Ability to speak, read, hear, and write, with or without reasonable accommodation.

Ability to use phone and computer systems, copier, fax, and other office equipment.

Must be able to occasionally move/lift up to 25 pounds with or without reasonable accommodation.

Work Environment

This position is located in an air-conditioned, environmentally controlled atmosphere. Noise level in the work environment is usually moderate and the distraction level in the work environment is often heavy.

Anticipated starting salary is in range commensurate with education and experience:
$80,000 - $90,000

Benefits
ATI has been named "Best Places to Work in SC" from 2017 - 2025.

This is a full-time opportunity with benefits
ATI provides Medical, Dental and Vision Plan options
Flexible Spending Accounts, including health and dependent care accounts
403B Retirement Savings plan with a very competitive company contribution
Personal time-off (pre-loaded & accrued) plus 12 paid holiday-days
Life Insurance paid by ATI
Paid Parental Leave
Short-Term & Long-Term Disability Coverage paid by ATI
Employee Assistance Program
Tuition Reimbursement Program
Flexible work schedules

ATI's standard business hours are Monday-Friday, between 8 AM - 5 PM.