onsite
Data Control Analyst - Transportation Maintenance - Clackamas County
Software Engineer
Analyze, validate, and report on transportation maintenance data using SQL, Python, GIS, and visualization tools to support operational decisions and ensure data integrity.
About the role
Key Responsibilities
- Collect, clean, and validate transportation maintenance datasets from multiple sources.
- Develop and maintain SQL queries, stored procedures, and ETL pipelines to ensure accurate data flow.
- Create GIS maps and dashboards to visualize asset conditions, work orders, and performance metrics.
- Implement data governance standards, monitor data quality, and resolve discrepancies.
- Produce regular and ad‑hoc reports for managers, supporting budgeting, scheduling, and compliance activities.
Requirements
- Proficiency in SQL and relational database concepts.
- Experience with Python (pandas, NumPy) for data manipulation and analysis.
- Knowledge of GIS software (ArcGIS, QGIS) and spatial data handling.
- Strong skills in data visualization tools such as Tableau, Power BI, or similar.
- Excellent analytical, problem‑solving, and communication abilities.