Senior Payroll Analyst - Data Analytics

Panasonic • Newark, NJ

5h • $80,000 - $90,000

About The Position

Every moment of every day, people all over the world turn to Panasonic to make their lives simpler, more enjoyable, more productive and more secure. Since our founding almost a century ago, we’ve been committed to improving peoples’ lives and making the world a better place–one customer, one business, one innovative leap at a time. Come join our journey!

https://www.youtube.com/watch?v=0tMgKm_71qs
(by clicking this link you are being referred to an external site that is not part of Panasonic)
Meet the Recruiter: Amber Smallwood
What You'll Get To Do:
Provides support to the Payroll Accounting Department in Data Analytics and Analysis on various financial and payroll data using Business Intelligence BI tools such as Power BI, Alteryx, Azure, and Tableau. This position also encompasses automation/streamlining of datasets, and analytics computations using programming languages such as Python, SQL, and PowerShell.
Conduct basic and statistical analysis on financial and payroll data
Supporting automation project using Power BI, Azure for payroll
Conducts complex assignments involving accounting payroll projects
Prepare wage analysis and other ad-hoc requests.
Identify relevant Payroll data sources and gain access to them following company policies and procedures
Provides training and guidance to less experienced staff
Conduct explanatory data analysis to assess the integrity of the data, as well as to attain the basic understanding of the dataset
Preparation of datasets for analysis, which includes data cleansing, standardization, validation, etc.
Engineer unstructured datasets into structured ones using custom scripts or programs
Communicate results through standardized reporting & visualizations using tools such as Tableau, Alteryx or Power BI
Design and create data pipelines for standard datasets from enterprise databases, such as SAP and Workday.
Collaborate with other data science teams to drive data initiatives
Daily and Monthly Payroll Accounting Department responsibilities
Scope:
Collaborate with various members of the PAD team by providing Data Analytics support
Reports to Payroll Accounting Manager

Requirements

• BS or BA Degree in Business, Finance, Data Science & Analytics, Computer Science, or related degree.
• Minimum 3 to 5 years working experience as data analyst or similar role.
• Experience in business intelligence tools such as Tableau, Alteryx, Azure, Power BI, AI Excel Microsoft 365 Copilot
• Experience of statistical concepts, working in data processing and analysis
• Experience in programming or scripting languages, such as Tableau, and Alteryx.
• Knowledge of ERPs such as SAP and Workday, especially on standard reports and tables
• Strong analytical and critical thinking skills
• Ability to work with large datasets
• Assertive and proactive, able to manage your own workload and take ownership of a project
• Strong communication and interpersonal skills to ensure effective collaboration with the Payroll Accounting team as well as other departments.
• Confidence, organization, advanced preparation, and good listening skills to make presentations to small groups are essential.
• Must have passion for understanding processes, strong attention to detail with unquestionable integrity to maintain independence and objectivity.

Nice To Haves

• Workday knowledge a plus

Responsibilities

• Provides support to the Payroll Accounting Department in Data Analytics and Analysis on various financial and payroll data using Business Intelligence BI tools such as Power BI, Alteryx, Azure, and Tableau.
• This position also encompasses automation/streamlining of datasets, and analytics computations using programming languages such as Python, SQL, and PowerShell.
• Conduct basic and statistical analysis on financial and payroll data
• Supporting automation project using Power BI, Azure for payroll
• Conducts complex assignments involving accounting payroll projects
• Prepare wage analysis and other ad-hoc requests.
• Identify relevant Payroll data sources and gain access to them following company policies and procedures
• Provides training and guidance to less experienced staff
• Conduct explanatory data analysis to assess the integrity of the data, as well as to attain the basic understanding of the dataset
• Preparation of datasets for analysis, which includes data cleansing, standardization, validation, etc.
• Engineer unstructured datasets into structured ones using custom scripts or programs
• Communicate results through standardized reporting & visualizations using tools such as Tableau, Alteryx or Power BI
• Design and create data pipelines for standard datasets from enterprise databases, such as SAP and Workday.
• Collaborate with other data science teams to drive data initiatives
• Daily and Monthly Payroll Accounting Department responsibilities
• Collaborate with various members of the PAD team by providing Data Analytics support

Benefits

• Panasonic prioritizes total well-being and offers comprehensive benefits options to support physical, emotional, financial, social, and environmental health:
• Health Benefits – Offering medical, dental, vision, prescription plans, plus Health Savings Account and Flexible Spending Account options.
• Voluntary Benefits – Life, accident, critical illness, disability, legal, identity theft, and pet insurance.
• Panasonic Retirement Savings & Investment Plan (PRSIP) – 401(k) plan with company matching contributions and immediate vesting.
• Paid Time-Off Benefits – Vacation, holidays, personal days, sick leave, volunteer, and parental & caregiver leave.
• Educational Assistance – Tuition reimbursement for job-related courses after six months of service.
• Health Management and Wellbeing Programs –Lifestyle Spending Account, EAP, virtual health management, chronic condition, neurodiversity, tobacco cessation, substance abuse support, and life stage and fertility resources. Available to eligible employees starting the first day of the month following your start date. Eligibility for each benefit may vary based on employment status, location, and length of service.
• Employee Recognition Program - High5 employee recognition and awards platform, quarterly and annual employee recognition
• Annual Bonus Program - Opportunity for an annual performance-based bonus.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level