Administrative Analyst

Administrative Analyst Engineering Services (Temporary Assignment)
Location: Downtown Los Angeles, CA
Schedule: Hybrid 9/80 Schedule (Monday Wednesday in office, Thursday remote, every other Friday off)
Hours: 7:00 AM 4:45 PM
Duration: Up to 6 Months
Pay Rate: $49 $51 per hour

About the Organization
A large public-sector agency responsible for planning, developing, and maintaining critical infrastructure projects that support essential services for Southern California communities. The organization manages a diverse capital improvement program and works collaboratively across engineering, finance, operations, and project management teams.

Position Summary
Seeking an experienced Administrative Analyst to provide analytical and administrative support within the Engineering Services Group. This role will serve as a key coordinator for Capital Improvement Program (CIP) reporting, budgeting, forecasting, and data management activities. The ideal candidate is highly organized, detail-oriented, analytical, and thrives in a collaborative team environment.

Key Responsibilities

• Collect, track, and validate project and financial data from project managers, project sponsors, and reporting systems.
• Prepare draft quarterly Capital Improvement Program (CIP) reports.
• Log and track funding requests and related documentation.
• Assist with quarterly CIP budget baselining and planned expenditure spreadsheets.
• Support monthly CIP spending forecasts and budget tracking activities.
• Prepare and maintain CIP-related memos, procedures, reports, and supporting documentation.
• Schedule and coordinate meetings with various stakeholder groups using Outlook.
• Manage and maintain a shared departmental email inbox.
• Perform administrative functions within a Power Apps-based CIP budget system.
• Develop, update, and refine Excel worksheets, reports, and tracking tools.
• Create dashboards and visual reporting using existing project and financial data.

Required Qualifications

• Bachelor's degree in a related field and four (4) years of relevant experience; OR
• Master's degree in a related field and two (2) years of relevant experience.
• Preferred degrees include Finance, Economics, Engineering, Business Administration, or related disciplines.

Required Technical Skills

• Advanced Microsoft Excel skills, including:
  • XLOOKUP
  • INDEX/MATCH
  • PivotTables
  • Pivot Charts
  • Data analysis and reporting
• Microsoft Outlook
• Microsoft Forms
• Dashboard creation and reporting
• Data collection, validation, and interpretation

Additional Requirements

• Local Southern California candidates only.
• Must meet the stated education and experience qualifications.
• Resumes that do not clearly demonstrate the required qualifications will not be considered.
• No CalPERS retirees.
• No H-1B sponsorship or transfers available.

Please submit your resume in Word or PDF format to be considered.