Apply on Employer Site

NEOGOV · 3 months ago

Engineering Services Specialist

Chino CA 91708, CA

Full-time

Onsite

Mid Level

3+ years exp

The Inland Empire Utilities Agency (IEUA) is a regional wastewater treatment agency seeking an Engineering Services Specialist to support its Engineering Department. This role involves managing project data, generating reports, and improving workflow efficiencies for capital improvement projects and long-term infrastructure initiatives.

GovTechHuman ResourcesInformation TechnologySoftware

No H1B

Responsibilities

Analyze and interpret engineering, construction, financial, and operational data to support informed project and departmental decision-making

Conduct detailed trend analysis and forecasting using statistical and analytical techniques

Ensure data integrity through audits and troubleshooting of data-related issues

Extract, transform, and load (ETL) data from multiple sources for analysis and reporting

Generate regular and ad-hoc reports for management and other departments

Automate recurring reports and streamline data processing tasks for improved efficiency

Maintain familiarity with database platforms such as Microsoft Access, SQL Server, and MySQL

Effectively utilize project management and enterprise software including Primavera, SAP, Microsoft Power BI, and Microsoft Excel for data entry, tracking, and reporting

Create complex Excel models leveraging advanced formulas, pivot tables, and macros

Prepare clear and accurate reports, visually strong PowerPoint presentations, and project summaries

Develop and maintain written materials such as Standard Operating Procedures (SOPs), workflows, budget analyses, and key performance indicators (KPIs)

Assist in developing dashboards and visual reports for performance monitoring and data-driven decision-making

Qualification

PrimaveraSAPMicrosoft Power BIData AnalysisMicrosoft ExcelData VisualizationSQL ServerMySQLPowerPoint DesignReport GenerationTrend AnalysisData Integrity

Required

Graduation from an accredited four-year college or university with a major in business, public administration, information science or a closely related field

At least three years of progressively responsible experience in performing administrative, operations, budgetary and similar analyses preferably in construction management or engineering utilizing Primavera or similar software

An equivalent combination of education, training and experience

Strong skills in Excel, data visualization, and PowerPoint presentation design

Experience in a public agency is preferred