Internship Excel Vba Developer Jobs in Ontario (NOW HIRING)

TI Automotive supplies safety and performance critical products and highly engineered components to the global automotive industry. We have more than 100 years' experience of solving customers' safety, efficiency and environmental challenges. Our exceptional team, powertrain agnostic product portfolio, vertical integration, global footprint and customer proximity make us a trusted partner to all the world's leading OEMs.Position Summary:The Sr. Financial System 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 processesProvide 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 requirementsManage monthly data load processes for corporate functions (Treasury foreign exchange rates, HR headcount-related data)Provide guidance for OneStream support resourceSystem Administration -Administer and support OneStream applications, including dimensions, hierarchies, metadata, and securityConfigure and manage application security, user roles, and workflow access.Support chart of accounts, legal entity structures, and reporting rollups used for external and management reportingManage 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 trainingApplication 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 requirementsMaintain 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 skillsStrong technical aptitude including SQL, Excel, VBA and relational databasesExcellent communication skillsCustomer-focused mindsetAbility to prioritize multiple requestsStrong organizational skillsContinuous improvement mentalityAbility to translate finance requirements into technical solutionsAbility to communicate technical concepts to Finance usersAbility to operate in a close-driven, deadline-oriented environmentSelf-directedRequired Qualifications:Bachelor's degree in Accounting, Finance, Information Systems, Computer Science or related field5+ years of hands-on OneStream experience in an administrator, analyst or support role.Strong understanding of:GAAP or IFRSFinancial close processesChart of AccountsIntercompany accountingForeign currency translationAdvanced Microsoft Excel skills (PivotTables, Power Query, VBA preferred)Experience supporting enterprise financial applications.Experience with data integrations, transformation rules, and reconciliation processesExperience delivering training to end usersPreferred 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 ManagerExperience supporting global, multi-currency organizations.Project leadershipWorking Conditions:Office environment: 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 weekBackground screening protocol is required for this position.