ZipRecruiter

Log In

1

Pivot Table Jobs in California (NOW HIRING)

Guitar Center

Inventory Analyst

Westlake Village, CA · On-site

$25 - $30/hr

Proficient in Excel (pivot table, vlookup) Pay Rate: $25.00- $30.00 / hr depending on background and experience. The job posting is not necessarily reflective of actual compensation that may be ...

Aston Carter

Senior Cost Accountant

Alameda, CA

$40 - $50/hr

... Pivot table, sox, sox compliance, sox controls, CPA, certified public accountant Top Skills Details accounting,cost accounting software,cost account,Cost Accounting,Sap Additional Skills ...

Guitar Center

Inventory Analyst

Westlake Village, CA · On-site

$25 - $30/hr

Proficient in Excel (pivot table, vlookup) Pay Rate: $25.00- $30.00 / hr depending on background and experience. The job posting is not necessarily reflective of actual compensation that may be ...

Guitar Center

Inventory Analyst

Westlake Village, CA · On-site

$28 - $32/hr

Proficient in Excel (pivot table, vlookup) Pay Rate: $28.00- $32.00 / hr depending on background and experience. The job posting is not necessarily reflective of actual compensation that may be ...

Aston Carter

Cost Accountant

Alameda, CA · On-site

$40 - $50/hr

... Pivot table, sox, sox compliance, sox controls, CPA, certified public accountant Top Skills Details accounting,cost accounting software,cost account,Cost Accounting,Sap Additional Skills ...

Aston Carter

Cost Accountant

Alameda, CA

$40 - $50/hr

... Pivot table, sox, sox compliance, sox controls, CPA, certified public accountant Top Skills Details accounting,cost accounting software,cost account,Cost Accounting,Sap Additional Skills ...

previous pagenext page

Showing results 21-40

All JobsPivot Table JobsPivot Table Jobs in California

Pivot Table information

What is a pivot table?

Pivot tables are a powerful feature in spreadsheet applications like Microsoft Excel and Google Sheets that allow users to quickly summarize, analyze, and organize large sets of data. By dragging and dropping fields, you can create customized reports and view your data from different perspectives. Pivot tables are commonly used for tasks such as finding totals, averages, or trends within large datasets, making them valuable tools for data analysis and business reporting.

What is the difference between Pivot Table vs Data Analyst?

AspectPivot TableData Analyst
Primary RoleTool for data summarization and analysisInterprets data, creates reports, and provides insights
Required SkillsExcel proficiency, data organizationStatistical analysis, data visualization, Excel and SQL skills
Work EnvironmentExcel, spreadsheets, data management toolsData analysis software, spreadsheets, reporting tools
CertificationsExcel certifications (e.g., Microsoft Office Specialist)Data analysis certifications (e.g., Microsoft Data Analyst Associate)

While Pivot Tables are a key tool used within data analysis, a Data Analyst performs broader tasks including interpreting data, creating reports, and providing strategic insights. Pivot Tables are essential for quick data summarization, but Data Analysts utilize a variety of tools and skills to analyze data comprehensively.

What are the key skills and qualifications needed to thrive as a data analyst, and why are they important?

To thrive as a Data Analyst, you need strong analytical abilities, proficiency in data interpretation, and a background in statistics or a related field. Familiarity with Microsoft Excel (especially Pivot Tables), SQL, and data visualization tools like Tableau or Power BI is typically required. Attention to detail, problem-solving skills, and effective communication are vital soft skills for translating complex data into actionable insights. These skills ensure accurate data analysis, support informed decision-making, and help organizations achieve their strategic goals.

What are some common challenges faced when using pivot tables?

Data analysts frequently use pivot tables to summarize, analyze, and visualize large datasets, but they can encounter challenges such as managing data integrity, dealing with inconsistent formatting, and handling very large datasets that may slow down performance. It’s also common to face difficulties when updating pivot tables after changes in source data or when integrating with other analysis tools. Developing strong organizational habits and routinely cleaning data can help mitigate these challenges, leading to more accurate and efficient analysis.
What are popular job titles related to Pivot Table jobs in California? For Pivot Table jobs in California, the most frequently searched job titles are:
What job categories do people searching Pivot Table jobs in California look for? The top searched job categories for Pivot Table jobs in California are:
Pivot Table jobs near you
Infographic showing various Pivot Table job openings in California as of August 2026, with employment types broken down into 71% Full Time, 26% Part Time, 2% Temporary, and 1% Contract. Highlights an 96% Physical, 1% Hybrid, and 3% Remote job distribution.

Senior Accounting Technician

Contact Government Services, LLC

Los Angeles, CA

$87K - $126K/yr

Full-time

Re-posted 20 days ago

Job description

Senior Accounting Technician
Employment Type: Full-Time, Mid-Level
Department: Finance

CGS is seeking a Senior Accounting Technician to join our team supporting the mission of a large federal agency. This position will entail a wide range of duties including management of accounts payable, reimbursement activity, collections, and account oversight.

CGS brings motivated, highly skilled, and creative people together to solve the government’s most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others. Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities.
 
Skills and attributes for success:
- Adjustment of the payroll/labor transactions via re-org processing.
- Correct and processes federal government travel in accordance with policies and regulations.
· Verify, analyze, and maintain financial information used by the DOJ Office of the Comptroller.
· Use various electronic software and databases, such as UFMS, JEDI and JEDI-2, SAFARI, E-2, and SAMS.gov, to analyze complex data sets.
·  Use various software packages, databases, and online resources to record and retrieve financial data, particularly related to reimbursable and billing process.
·Use a financial management system to track expenditures of multiple accounts.
· Generate reconciliation reports from a financial management system and reconcile financial books /reports weekly.
· Prepare financial reports and documentation for review and signature by DOJ Office of the Comptroller Management and numerous other U.S. Government agencies.
·Assist and provide support to other sections of DOJ in UFMS transaction processing and provide suggestion in system errors resolutions.
· Compose memorandums, referencing financial reports and activities, as well as letters to the outside vendors and agencies, as needed.
· Composes and disseminates correspondence, prepares forms and financial documents, manage databases, maintains the office files, routes paperwork, schedules and assists with web conferences, prepares meeting room and office events.
· Performs other duties, either as assigned or on own initiative, that are necessary for regular or special projects undertaken by the division.
· Contributes to team efforts, as needed.

Qualifications:
- Two-year degree in accounting or four-year degree in a related field (finance, business, banking, or economics) with 30 credit hours in accounting.
- Knowledge of manual and automated accounting systems used by banking, financial and other institutions.
- Experience working with commitments, obligations, and interagency reimbursement agreements.
- Experience working with the quarterly review, accrual and closeout process.
- Ability to provide analysis and technical support for a variety of financial activities.
- Ability to identify and analyze change in budgetary and/or financial activities.
- Ability to research and analyze financial data.
- Must be a US Citizen upfront.
- Must be able to obtain a Public Trust Clearance.

Ideally, you will also have:
- UFSM, JEDI, SAFARI, E-2, and Excel proficiency.
- Budgeting Cycle Management.
- Financial Management.
- Accounts payable (A/P) and Accounts receivable (A/R) management and processing.
- Reimbursable agreements analysis and management.
- Obligations processing and committed funds tracking.
- Auditing and accounting services.
- Cash flow analysis.
- Statistical analysis.
- Financial fraud-related research.
- Electronic data acquisition and processing.
- Systems analysis and administration.
- Database user support.
- Reporting.
- Record Management.
- Business legal compliance.
- Special projects.
- Analytical and critical thinking, time management and organization.
- Excel proficiency with skills to include various formatting, sorting, and correction of data, and table manipulations, such as: Table array, Sum function, Max min function, Vlookup, Trim, Pivot table, Arithmetical formulas.

Our Commitment:
Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client’s specific needs. We are committed to solving the most challenging and dynamic problems.

For the past seven years, we’ve been growing our government contracting portfolio, and along the way, we’ve created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work.

Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come.

We care about our employees. Therefore, we offer a comprehensive benefits package.
-         Health, Dental, and Vision
-         Life Insurance
-         401k
-         Flexible Spending Account (Health, Dependent Care, and Commuter)
-         Paid Time Off and Observance of State/Federal Holidays

Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Join our team and become part of government innovation!

Explore additional job opportunities with CGS on our Job Board:
https://cgsfederal.com/join-our-team/

For more information about CGS please visit: https://www.cgsfederal.com or contact:
Email: info@cgsfederal.com

#CJ

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.