Database analyst Jobs in Oakville, ON

Job Description

HOW YOU WILL MAKE AN IMPACT

SG10

Participates in the maintenance of accounting records in accordance with International Financial Reporting Standards (IFRS) and ensures the accurate compilation, analysis and reporting of financial data. Maintains one or more accounting systems: Journal entries, General Ledger, Accounts Receivables, Accounts Payable, etc. Reviews and interprets financial reporting requirements, rules and regulations. Balances books and prepares profit and loss, cash flow, income and balance sheet statements. Monitors and develops monthly reports of revenues and expenditures for projects. Provides record of assets, liabilities and other financial transactions. May prepare federal, provincial and local reports. May assist in the setup of processes and procedures that properly capture, track and report revenue, in accordance with the company revenue recognition policy. May generate revenue reports for internal and/or external use. May interpret reports and records for managers/stakeholders. Review and analysis on specific accounts e.g. Sales, AR, Inventory etc. for reasonability. Participates in annual audits, special projects e.g. new accounting or reporting systems.

Participate in Month-end Close Activity:

Month-end closing Journal Entries: Payroll, cross charges from other divisions, accruals, WBS element classification, reclass entries as per FiRe requirements. Posting US marketing charges, review, update and post FX internal entries in SAP. -Equalization - Posting journal entry based on information received from Germany. Month end analysis: Review of FX evaluation entries; ensure all FX related entries from previous month are reversed; review and analyze FX revaluation report. Prepare analysis with comments identifying main drivers of FX loss/gain; Reconcile Intercompany accounts ensuring there are no large unreconciled balances between trading partners. Month end closing cycles: Creation of month end closing cycles for actual and forecast. Run assessments to allocate changes made to PE cost centers. Roll forward PE forecasts.

Financial Statements: Inventory: Futbal table updates based on % split of product type currently in inventory (including goods in transit); LCM and reserves. Maintain Futbal tables as per accounting group direction. Resolve all validation errors

Participate in Month-end Reporting:

Balance Sheet – review month-to-month changes and provide comments and explanations to Controller and Finance Director. PnL – review month-to-month changes and provide comments and explanations to Controller and Finance Director. Prepare Quarterly Financial package including Balance Sheet, Working Capital, KPI – review, analyze and provide comments to Controller and Finance Director. Update Headcount, Fluctuation and Absentee Reporting monthly. Enter Capex Reporting (Investment - Approval & Spending). Upload Treasury Information (Bonds/Financing) to reporting system (FiRe). Inventory Info to reporting system (FiRe). Upload PnL to reporting system (FiRe). Upload Balance Sheet to FIRE for Actual and Forecast. Upload Balance Sheet to reporting system (FiRe). GR/IR - Financial reporting into FiRe. Payroll benefits - Financial reporting into FiRe. DSO/AR reporting and Actual & FC in FiRe. Bad Debt - Financial reporting into FiRe. Equalization - Financial reporting into FiRe. ICO reporting and reconciliations in Fire. BAF reporting/NCP (cash pool with ICO) reporting in FiRe. BaF (Bonds and Finance)- update all BaF deals such as calendar dates, current CAD value as per Treasury documentation"

Customer Rebate Maintenance/Reconciliation/Issuing Credits:

Creation and Maintenance of customer rebate accruals in SAP. Review, update accrual agreements as needed (based on contracts and tracking). issue credits on customer accounts based on Rebate attainment. Monthly reconcile the Customer Rebate accruals vs Actual customer attainment"

Reconciliation:

- Inventory - review, investigation and responding to inquiries. Acct. Payable. Monthly process payment run (either Cheque or EDI) to suppliers"

Adhoc Controlling and reporting support as need

The expected annual salary for this role is $77,000 - $90,000. Salaries are based upon candidate skills, experience, and qualifications, as well as market and business considerations.

Qualifications

WHAT YOU BRING TO THE ROLE

• Relevant Bachelors degree or Equivalent plus 2+ years related professional experience OR 5+ years related professional experience if no relevant Bachelors Degree
• Data Retrieval: Ability to perform basic application of knowledge in an autonomous way, demonstrated by real work examples.
• Data Analysis: Basic internal customers' needs identification. Modifying reporting as needed for internal customers. Improved reports based on customer needs.
• Microsoft programs and inhouse specialized systems: Advanced Excel. Ability to perform some tasks in an autonomous way (creates charts and uses effectively formulas and various format functions).
• Functional Knowledge: Medium understanding level of all products, relevant processes and tools within target function.
• Analytical & problem solving skills. Strong organization skills and attention to detail. Works well independently
• Valid drivers license and passport required. Some/limited travel will be required.
• Continental is not able to pay relocation expenses for this opportunity
• Legally Authorized to work in Canada is required. We will not sponsor individuals for employment visas now or in the future for this job opening.

ADDITIONAL WAYS TO STAND OUT

• 2+ years of Accounting/Finance or related internal Continental experience
• Fluent in French language
• SAP
• Power BI
• CPA designation or in progress

Additional Information

THE PERKS

• Competitive wages and bonus
• Comprehensive benefit package for self and family
• RSP contribution
• Flexible work environment

Ready to drive with Continental? Take the first step and fill in the online application.