Senior Financial Systems Developer

TI Group Automotive Systems LLC
Auburn Hills, MI, United States
2 months ago
Apply on indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Artificial Intelligence Backup Devices C Sharp (Programming Language) Information Systems Data Integration Data Integrity Relational Databases Disaster Recovery Monitoring of Systems Metadata Visual Basic .NET (Programming Language)
+9 more
Pivot Tables OneStream Software Engineering SQL Databases Systems Integration Software Security Powerquery Information Technology Vba Programming Language

Job description

The Sr Financial System DeveloperAdministrator 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., 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 DevelopmentConfiguration -

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

GovernanceControls -

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

Requirements

Do you have experience in User training (technical support)?, Do you have a Bachelor’s degree?, * 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, * 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, * 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

Benefits & 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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:47 min

Comparing Egeria to alternative open metadata solutions

Ferd Scheepers · World Congress 2022

1:06 min

Developer experience and project variety at scale

Alexandra Petri · World Congress 2023

2:08 min

Creating standard APIs via the Egeria open metadata project

Ferd Scheepers · World Congress 2022

1:45 min

Building IT systems for global finance markets

Anastasia Troitskaya Anastasia Troitskaya · World Congress 2024

4:49 min

Discovering technical chart requirements via client use cases

Chris Heilmann +3 · LIVE

2:51 min

Applying flower auction logistics to data metadata

Ferd Scheepers · World Congress 2022

Videos

See all

Related articles

See all