1

Excel Pivot Table Power Query Jobs (NOW HIRING)

Senior Accountant

Pennsauken, NJ · Hybrid

$90K - $100K/yr

Automate and improve recurring reports using Excel (pivot tables, lookups, Power Query preferred) to reduce manual effort. Cross-Functional Support * Partner with AP/AR, operations, and FP&A (as ...

Primary Skills SQL (Advanced querying, joins, stored procedures, performance optimisation) Power BI / Tableau (Dashboard development and data visualisation) Microsoft Excel (Pivot Tables, Power Query ...

... Pivot Tables, Macros, Power Query) to clean, manipulate, and model data for reporting. • Partner ... Excel skills for complex data modeling and statistical analysis. • Minimum 6-9 years of ...

Accountant

Gastonia, NC · On-site

$46K - $60K/yr

Excel at a working level: Power Query for imports, Power Pivot or PivotTables for multi-table analysis, fluent with XLOOKUP / INDEX-MATCH, able to build clean reusable models * Bonus: SQL basics ...

Power Query * Dashboard design and performance optimization Advanced Excel skills including: * Power Query * Pivot Tables * VBA/Macros (preferred) * Financial and operational modeling Strong Python ...

Showing results 21-40

Excel Pivot Table Power Query information

See salary details

$44.5K

$80K

$141K

How much do excel pivot table power query jobs pay per year?

As of Sep 10, 2026, the average yearly pay for excel pivot table power query in the United States is $79,970.00, according to ZipRecruiter salary data. Most workers in this role earn between $61,500.00 and $90,500.00 per year, depending on experience, location, and employer.

What is the difference between Excel Pivot Table Power Query vs Data Analyst?

AspectExcel Pivot Table Power QueryData Analyst
Primary RoleData transformation, cleaning, and reporting within ExcelAnalyzing data, generating insights, and creating reports
Skills RequiredExcel skills, data manipulation, basic to advanced Power Query and Pivot Table knowledgeStatistical analysis, data visualization, Excel and database skills
Work EnvironmentOffice, primarily using Excel and related toolsOffice, often with additional BI tools and databases
CertificationsExcel certifications, Power Query coursesData analysis certifications like Microsoft Data Analyst Associate

Excel Pivot Table Power Query focuses on data preparation and reporting within Excel, while a Data Analyst performs broader data analysis, interpretation, and visualization tasks. Both roles require strong Excel skills, but Data Analysts typically have additional expertise in statistical methods and data visualization tools.

What other helpful pages are available for Excel Pivot Table Power Query?

Other pages related to Excel Pivot Table Power Query:

Infographic showing various Excel Pivot Table Power Query job openings in the United States as of September 2026, with employment types broken down into 1% Internship, 88% Full Time, 9% Part Time, and 2% Contract. Highlights an 86% Physical, 3% Hybrid, and 11% Remote job distribution, with an average salary of $79,970 per year, or $38.4 per hour.

Senior Accountant

Pennsauken, NJ • Hybrid

LHH US
Human Resource Programs Administration • 10K+ employees

$90K - $100K/yr

Full-time

Medical, Dental, Vision, Life

Re-posted 18 days ago


Job description

Hybrid Senior Accountant - Pennsauken, NJ ($90,000-$100,000)
We're hiring a Hybrid Senior Accountant to own key areas of the month-end close and deliver accurate, timely financial reporting. This role is ideal for someone who is highly confident with debits/credits, thrives in a structured close process, and is an advanced Excel user who can streamline reconciliations and reporting.
Location & Schedule
  • Location: Pennsauken, NJ
  • Work Model: Hybrid (mix of in-office and remote; schedule to be discussed)
  • Salary: $90,000-$100,000 (based on experience)
Key Responsibilities
Month-End Close Ownership
  • Execute and support the full month-end close process, ensuring all entries are complete, accurate, and posted on time.
  • Prepare, record, and review journal entries with strong debit/credit precision (accruals, prepaids, allocations, reclasses, amortization, depreciation).
  • Maintain and improve close checklists, timelines, and deliverables to ensure consistent on-time close.
Reconciliations & Financial Accuracy
  • Perform detailed balance sheet reconciliations (cash, AP/AR-related accounts, accrued expenses, prepaid accounts, fixed assets, intercompany, and other key accounts as applicable).
  • Investigate variances, identify root causes, and propose/execute corrective actions.
  • Ensure general ledger activity is properly supported and documented, with clear audit trails.
Reporting & Excel-Driven Analysis
  • Build and maintain Excel-based schedules and close workpapers, using advanced functions to improve speed and accuracy.
  • Create/refresh month-end reporting packages and support financial statement preparation.
  • Automate and improve recurring reports using Excel (pivot tables, lookups, Power Query preferred) to reduce manual effort.
Cross-Functional Support
  • Partner with AP/AR, operations, and FP&A (as applicable) to ensure proper coding, timing, and classification of transactions.
  • Support audit requests and provide documentation for internal/external reviews.
  • Participate in process improvement initiatives related to close efficiency, reconciliation quality, and reporting consistency.
Required Qualifications
  • 2-4 years of experience in a Senior Accountant role (or comparable scope and ownership).
  • Strong understanding of accounting fundamentals, including debits/credits and general ledger mechanics.
  • Hands-on experience owning key portions of the month-end close process.
  • Advanced Excel skills (required): pivot tables, XLOOKUP/VLOOKUP, SUMIFS, nested formulas; ability to manage complex reconciliations and schedules.
  • High attention to detail, strong organizational skills, and ability to meet deadlines consistently.
  • Strong written and verbal communication skills; comfortable collaborating across teams.
Preferred Qualifications
  • Bachelor's degree in Accounting or Finance.
  • Experience with ERP/accounting systems. Excel
  • Power Query/Power Pivot experience and/or light automation mindset.
  • Exposure to audits, internal controls, and documentation standards.
What Success Looks Like (First 90 Days)
  • Independently manages assigned close tasks and journal entries with minimal oversight.
  • Reconciliations are accurate, timely, and supported with clear documentation.
  • Excel workpapers are clean, efficient, and improve the team's ability to analyze balances and variances quickly.
  • Identifies at least 1-2 opportunities to streamline close/reconciliation processes.
Compensation & Benefits
  • Base Salary: $90,000-$100,000
  • Hybrid work flexibility
Competitive benefits include medical, dental, and vision coverage, employer-paid life and disability insurance, flexible spending accounts, commuter benefits, an employee assistance program, and a hybrid work schedule.
Equal Opportunity Employer/Veterans/Disabled
To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://www.lhh.com/us/en/candidate-privacy
The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:
• The California Fair Chance Act
• Los Angeles City Fair Chance Ordinance
• Los Angeles County Fair Chance Ordinance for Employers
• San Francisco Fair Chance Ordinance
Pay Details: $90,000.00 to $100,000.00 per year
Search managed by: Cassandra Coakley
Equal Opportunity Employer/Veterans/Disabled
Military connected talent encouraged to apply
To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://www.lhh.com/us/en/candidate-privacy
The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:
  • The California Fair Chance Act
  • Los Angeles City Fair Chance Ordinance
  • Los Angeles County Fair Chance Ordinance for Employers
  • San Francisco Fair Chance Ordinance
Massachusetts Candidates Only: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

LHH logo

About LHH

Sourced by ZipRecruiter

LHH Recruitment Solutions is a division of the Adecco Group, the world's leading HR Solutions provider and the 7th best workplace in the world. We are an industry leader in temporary and permanent recruitment within accounting and finance. We work with premier clients, from small businesses to Global Fortune 500 companies, and we know that every opening is more than a job, and that every candidate is more than a resume. We work closely with candidates to understand their needs and apply our industry expertise to make matches for clients that drive business results. Our ability to dynamically balance your needs with the right Solutions gives clients and candidates the right fit to succeed. We are an evolving organization and take pride in a culture of trust, where we celebrate diversity, equality and inclusion. We always put our people first, drive a growth mindset and foster a collective spirit. We understand that talent and potential come from every section of society, regardless of gender, race, age, or physical ability. At the Adecco Group, we are committed to making the future work for everyone!

Industry

Human resource programs administration

Company size

10,000+ Employees

Headquarters location

Jacksonville, FL, US