Financial Coordinator/Reporting Analyst - Plano, United States - Yoh, A Day & Zimmermann Company

    Yoh, A Day & Zimmermann Company
    Yoh, A Day & Zimmermann Company Plano, United States

    2 weeks ago

    Yoh, A Day & Zimmermann Company background
    Description

    Financial Coordinator & Reporting Analyst

    12+ month contract

    Plano, TX (Remote)

    Looking for an F&A Analyst with Ariba, SAP/BPC, and Excel skills.

    This person will be responsible for supporting the budgets for Chief Product Owners and handle the consolidated reporting for each group.

    This person will also be responsible for any reporting required by those individual CPOs.

    Requirements:

    Must have high integrity with ability to preserve confidentiality

    Strong focus on quality and detail

    Exceptional ability with Excel, including pivot tables, lookups, nested formulas, and spreadsheet forecasting

    Understanding of accounting concepts, including accruals and budgeting

    Familiarity with contracts to obtain relevant data, such as amounts and due dates

    Strong written and verbal communication skills, including a collaborative mentality

    Ability to track and meet deadlines

    Ability to multitask and work in a fast-paced environment

    Bachelor's in Business Administration with a focus in Accounting or Finance or similar degree

    SAP and BPC (for data retrieval) and Ariba

    MS Office, Excel

    Reporting to the Group Manager - Support to multiple teams, CPOs, and GM with responsibilities including:

    Cost of Sale (COS) (40%)

    If Cost of Sales (COS) purchase orders are assigned, invoices are validated against billing team RDR reports in SharePoint (specific vendors only as not all have RDR reports)

    Process follows same as invoice review in Ariba above

    Budget/Forecast/Accounting: 35%


    • Prepare and update Annual Budget and Quarterly Forecasts using Excel template o Quarterly forecasts (June, September, December)

    o Annual Budgets (January – February)


    • Track monthly vendor scheduled payments monthly (including approvals for deliverable or time/materials)


    • Submit appropriate monthly and annual accruals, approved by Manager and/or CPO


    • Review Invoices for payment in Ariba, track against approved P.O.s to monitor sufficient balances


    • Monitor and explain monthly variance against Budget/Forecasts


    • Research expenses


    • Prepare JVs (journal entries) and submit to Accounting/Budget team


    • Communicate expected financial impact to CT Managers / CPOs and Accounting/Budget team for changes between forecasts including monthly, roll-up, and ad-hoc reporting


    • Provide cost estimates for long-range forecasts to Strategic Planning team


    • Forecast and track Capital Expenditures


    • Ad-hoc financial reporting as requested

    SOWs / Vendor payments: 20%


    • Review contracts to understand impact to budget


    • Assist CPO with contract extensions and termination notifications


    • Verify SOW fee tables for accuracy and prepare SOW scheduled payment worksheets to accompany purchase requisitions


    • Submit requisitions for Purchase Orders


    • Communicate with Accounting/Budget and Contracts teams


    • Communicate with vendor representatives


    • Reconciliations


    • P-card purchases

    JRN tracking: 5%


    • Monitor expenses for JRN related Purchase Orders


    • Prepare and submit monthly JRN reporting to include hours and dollars submitted from CPOs


    • Confirm Job Completion reports for each JRN