Finance Data Analytics Analyst II

Panasonic Automotive North America; Farmington Hills (MI); On-site; USD 75,000 - 110,000; Full time

Benefits offered by this job

Great Medical/Dental Benefits

Company-Matched 401K Retirement

Annual Bonus Program

Educational Assistance

Relaxed Dress Code

PASATalks Speaker Summits

Leadership & Mentorship Programs

High5 Reward Recognition Program

Onsite Happy Hours

And many more benefits & perks found

Job summary

Panasonic Automotive North America in Farmington Hills, MI seeks a Financial Analyst to prepare and analyze financial data, support budgeting and decision making, and help improve processes. You will mine large data sets, generate reports, and advise management on cost controls and performance metrics.

The role requires a four-year accounting/finance degree, 3+ years of analytics experience, strong Excel and data tools skills, and experience with GAAP and manufacturing environments.

Qualifications

• Four-year college degree in accounting or with concentration in Accounting, Finance or Data Analytics required.
• Minimum of three (3) years of related Financial Analytics experience required.
• Working knowledge of data analysis and/or business intelligence software required.
• Knowledge of data analysis, statistics or data science required.
• Knowledge of Generally Accepted Accounting Principles (GAAP) required.
• Demonstrated proficiency of Microsoft Office Suite, intermediate proficiency in excel required.
• Demonstrated ability to mine big data required.
• Experience in manufacturing environment preferred.

Responsibilities

• Prepares the compilation, reporting, and analysis of the actual results, forecast and business plan regarding sales, purchase cost, material cost, and other related cost; to include data mining; investigating discrepancies, exceptions, and ad hoc analysis of large complex data set
• Recommends ways to identify areas of risk, improve analysis or simplify processes. Utilizes focus on lean process approach to improve speed, accuracy, and quality.
• Constructs and assembles financial data sets and accounts utilizing financial reports, financial data bases, big data and key financial information for budgeting and decision making, developing conclusions and presenting summary recommendations.
• Participates with management in making day-to-day operating decisions, developing solutions which may result in policy changes or new processes and offers advice on various aspects of company management and issue resolution.
• Assists other departments in the evaluation of their performance as it pertains to their specific area of focus.
• Assists in the monitoring and tracking of departmental KPIs and accountabilities and objectives for self. Makes recommendations for improved or newly introduced KPIs.
• Performs internal audits of systems and procedures and cooperates with internal/external auditors to support both audits and improve systems soundness and efficiency.
• Provides assistance on balance sheet account reconciliations.
• Understands, follows, and enforces Company policies, procedures, and regulations.
• Prepares reports, charts, graphs, presentations, and other statistical information as necessary.
• Supports assigned general ledger, journal entries as directed.
• Assists with the preparation of Sarbanes Oxley (SOX) documents and self-tests, as needed, for monthly quarterly, and yearly requirements.

Skills

Data analysis

Statistics

GAAP knowledge

Big data mining

Education

Bachelor's degree in Accounting or Finance

Tools

Microsoft Excel

BI / analytics software

Job description

Panasonic Automotive North America in Farmington Hills, MI seeks a Financial Analyst to prepare and analyze financial data, support budgeting and decision making, and help improve processes. You will mine large data sets, generate reports, and advise management on cost controls and performance metrics.

The role requires a four-year accounting/finance degree, 3+ years of analytics experience, strong Excel and data tools skills, and experience with GAAP and manufacturing environments.