Financial Systems Analyst

Advanced Technology International; Summerville, Northern (SC, KY); Hybrid; USD 80,000 - 90,000; Full time

Benefits offered by this job

Medical, Dental and Vision options

Flexible Spending Accounts

403(b) Retirement Savings plan

Paid holidays and personal time off

Parental leave

Disability coverage

Employee Assistance Program

Tuition reimbursement

Flexible work schedules

Job summary

Advanced Technology International seeks a Financial Systems Analyst to design and manage our TM1-based budgeting and forecasting platform. You will bridge Corporate Finance and IT, building models, rules, and dashboards that automate data flows from Deltek Costpoint and ensure data accuracy across the system.

The role requires 3–5 years of TM1 experience, strong SQL knowledge, and experience with PAW/Pax. A hybrid in-office/remote schedule is offered, with residency near Charleston, SC preferred.

Qualifications

• 3–5 years of hands-on TM1/Planning Analytics experience.
• Proficient in TM1 TI scripts, MDX expressions, and TM1 Rules/Feeders.
• Strong knowledge of Deltek Costpoint core modules and its SQL structures.
• Expert with PAW, Pax, and Perspectives.

Responsibilities

• Architect TM1 models, cubes, dimensions, and dashboards to support budgeting and forecasting.
• Write TM1 rules and optimize performance with precise Feeders.
• Automate TI processes to load Costpoint data into TM1 and ensure data integrity.
• Administer security and governance for sensitive payroll and project data.
• Train and support internal finance users on TM1/PAW workflows.

Skills

TM1/Planning Analytics expertise

Finance knowledge

Analytical mindset

Communication skills

Education

Bachelor’s degree in Finance, Accounting, MIS, CS

Tools

IBM TM1 / Planning Analytics

TM1 TI scripts

MDX expressions

TM1 Rules/Feeders

Deltek Costpoint

SQL databases

PAW

Planning Analytics for Excel (Pax)

Perspectives

PowerBI

Job description

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.

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.

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.

ATI is an Equal Opportunity Employer of Minorities, Females, Protected Veterans, and Individual with Disabilities.

ATI complies with the Pay Transparency Nondiscrimination provision mandated by Executive Order 13665.

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

Anticipated starting salary is in range commensurate with education and experience:

$80,000 - $90,000

Benefits

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