TM1 & Finance Analytics Architect – Hybrid

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

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.