Pivot Table Jobs in California (NOW HIRING)

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: [email protected] #CJ $87,360 - $126,186.67 a year 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.