Senior Financial Systems Developer

ABC Technologies Holdings Inc

Auburn Hills, MI

JOB DETAILS
SKILLS
Accounting, Accounting Close, Administrative Skills, Analysis Skills, Applications Security, Artificial Intelligence (AI), Automation, Budgeting, Business Performance Management, Business Transformation, Capacity Management, Change Management, Communication Skills, Computer Science, Content Management Systems (CMS), Continuous Improvement, Customer Relations, Data Management, Data Quality, Data Recovery, Disaster Recovery, Document Change Management, Establish Priorities, Exchange Rates, Finance, Finance Software, Financial Planning and Analysis (FP&A), Financial Reporting, Financial Systems, Forecasting, Foreign Exchange (FX), Generally Accepted Accounting Principles (GAAP), Global Financial Markets, Help Desk, Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), International Financial Reporting Standards (IFRS), Leadership, Legal, Management Reporting, Metadata, Microsoft C# (C Sharp), Microsoft Excel, Microsoft Exchange Server, Microsoft Visual Basic for Applications (VBA), Microsoft Visual Basic.NET, Organizational Skills, People Management, Performance Analysis, Problem Solving Skills, Process Improvement, Production Systems, Quality Assurance Methodology, Reconciliation, Relational Databases (RDBMS), Reporting Dashboards, SQL (Structured Query Language), Security Monitoring, Software Administration, Software Development, Software Patches, Software Upgrades, System Integration (SI), System Migration, Systems Administration/Management, Team Player, Technical Support, Test Plan/Schedule, Testing, Time Management, Training/Teaching, Treasury, Usability Engineering, User Interface/Experience (UI/UX)
LOCATION
Auburn Hills, MI
POSTED
2 days ago

Position Summary:

The Sr Financial System Developer & Administrator is responsible for the day-to-day administration, maintenance, optimization and development of the OneStream Corporate Performance Management (CPM) platform. This role partners closely with Accounting, Finance, FP&A and IT to support GAAP-based financial reporting, and to ensure system stability, data integrity, security, timely resolution of application issues and continuous improvement. In addition to systems administration, this role provides leadership for OneStream development, is the technical owner of the OneStream platform and reports to the Director of Financial Systems.

The ideal candidate combines finance process expertise with OneStream technical administration. They understand how Accounting and FP&A use the platform while also possessing the technical skills to configure, maintain, secure, and optimize the application.

Primary Responsibilities:

Financial Systems Support -

  • Support monthly, quarterly, and annual financial close processes
  • Provide end user support to global finance teams utilizing the OneStream platform for consolidation, forecasting, budgeting, lease accounting and account reconciliation processes.
  • Ensure successful data loads, consolidations, currency translations, and reporting.
  • Troubleshoot consolidation and calculation issues.
  • Support statutory, management, and external financial reporting requirements
  • Manage monthly data load processes for corporate functions (Treasury foreign exchange rates, HR headcount-related data)
  • Provide guidance for OneStream support resource

System Administration -

  • Administer and support OneStream applications, including dimensions, hierarchies, metadata, and security
  • Configure and manage application security, user roles, and workflow access.
  • Support chart of accounts, legal entity structures, and reporting rollups used for external and management reporting
  • Manage OneStream Development, Test, and Production environments, including application migrations, capacity planning, and change management.
  • Coordinate migrations using application build and deployment processes.
  • Monitor system performance, troubleshoot application issues. Serve as primary liaison with OneStream Support and escalate as needed.
  • Coordinate software upgrades, patches, and platform releases.
  • Maintain application documentation covering admin processes, troubleshooting and user training

Application Development & Configuration -

  • Work with Finance team and systems integration partners to lead/support application development that enhances existing functionality and extends the use of the system.
  • Build and maintain OneStream artifacts (Cube Views, Dashboards, Reports, Forms, Workflows, Transformation Rules, Business Rules, etc) to enhance and extend the system.
  • Lead testing process of periodic system upgrades.
  • Develop automation to improve financial processes.
  • Support implementation of OneStream Solution Exchange solutions.

Data Integration -

  • Manage integrations between OneStream and source systems such as BPCS, CMS, Kinetics and Flat files.
  • Validate data loads and troubleshoot integration issues.
  • Build, maintain, and support transformation rules, including mappings, logic, and validations.

Governance & Controls -

  • Maintain application security and segregation of duties.
  • Support SOX compliance, Internal Controls compliance and audit requests.
  • Follow appropriate change management processes, and documentation requirements
  • Maintain disaster recovery and backup procedures in coordination with OneStream Support policy.

Continuous Improvement -

  • Recommend system enhancements to improve user experience, usability and performance.
  • Evaluate new OneStream functionality and Solution Exchange solutions, including AI capabilities.
  • Partner with Finance leadership on roadmap planning.
  • Support or lead implementation projects and future system expansions.

Key Skills:

  • Strong analytical and troubleshooting skills
  • Strong technical aptitude including SQL, Excel, VBA and relational databases
  • Excellent communication skills
  • Customer-focused mindset
  • Ability to prioritize multiple requests
  • Strong organizational skills
  • Continuous improvement mentality
  • Ability to translate finance requirements into technical solutions
  • Ability to communicate technical concepts to Finance users
  • Ability to operate in a close-driven, deadline-oriented environment
  • Self-directed

Required Qualifications:

  • Bachelor's degree in Accounting, Finance, Information Systems, Computer Science or related field
  • 5+ years of hands-on OneStream experience in an administrator, analyst or support role.
  • Strong understanding of:
  • GAAP or IFRS
  • Financial close processes
  • Chart of Accounts
  • Intercompany accounting
  • Foreign currency translation
  • Advanced Microsoft Excel skills (PivotTables, Power Query, VBA preferred)
  • Experience supporting enterprise financial applications.
  • Experience with data integrations, transformation rules, and reconciliation processes
  • Experience delivering training to end users

Preferred Qualifications:

  • OneStream Certified Professional or Administrator certification.
  • SQL and VB.NET or Business Rule (C#) development experience.
  • Experience developing Dashboard Extenders, Connector Rules, and automation solutions.
  • Experience implementing OneStream Consolidations and Forecasting/Budgeting.
  • Experience with OneStream solutions for Account Reconciliations, Journal Entry Manager (JEM) and Task Manager
  • Experience supporting global, multi-currency organizations.
  • Project leadership

Working Conditions:

  • Office environment: work in an office setting within the company's headquarters. The office environment may be fast-paced and dynamic, especially during peak periods such as month-end or quarter-end close, budgeting cycles, or financial reporting periods.
  • 4 days onsite, 1 day remote each week

About the Company

A

ABC Technologies Holdings Inc