Transportation Planning Technician

WSP en Colombia; Colombia; On-site; COP 40,000,000 - 70,000,000; Full time

Job summary

WSP en Colombia seeks a Transportation Planning Technician to handle Excel-based calculations and large mobility datasets for client reports. The role involves processing graphs, validating datasets, and producing tables and figures for presentations.

You will work with traffic software like Synchro, Aimsun, and Vissim, perform basic simulations, and maintain documentation for traceability, while collaborating with Montreal/Quebec teams and leveraging Power BI for visuals.

Qualifications

• College diploma or university degree in Civil Engineering, Civil Engineering Technology, Transportation, Urban Planning, Geography, Geomatics, Urban Design, or related field.
• 2 to 5 years of experience in technical support within a consulting engineering, transportation, or planning environment.
• Versatile technical resource comfortable with quantitative data processing and graphic production.
• Self-motivated, rigorous, and detail-oriented.

Responsibilities

• Prepare calculation worksheets in Excel using the team’s templates and methodologies.
• Process and present large volumes of mobility data through graphs and tables (traffic counts, origin-destination surveys, speed and flow, ridership).
• Structure, validate, and clean datasets from clients and data collection firms.
• Produce tables and charts for reports and client presentations.
• Prepare calculation files in traffic software such as Synchro, Aimsun, and Vissim; include network coding and signal timing configuration.
• Conduct vehicle turning simulations with AutoTURN and prepare supporting figures.
• Document assumptions, versions, and data sources for traceability.
• Produce planning diagrams and mobility figures; ensure visual identity and templates consistency.

Skills

Excel

Data processing

Graphic production

Self-learning

Attention to detail

French

English

Education

Civil Engineering degree

Tools

AutoCAD

AutoTURN

Synchro

Aimsun

Vissim

QGIS

ArcGIS

Power BI

Job description

Transportation Planning Technician

• Prepare calculation worksheets in Excel using the team’s templates and methodologies.
• Process and present large volumes of mobility data in a concise manner through graphs and tables, including traffic counts, origin-destination surveys, speed and flow data, and ridership data.
• Structure, validate, and clean datasets received from clients and data collection firms before analysis.
• Produce tables and charts presenting results for reports and client presentations.

Description

Transportation Planning Technician

Key Responsibilities

Calculations and Data Processing

• Prepare calculation worksheets in Excel using the team’s templates and methodologies.
• Process and present large volumes of mobility data in a concise manner through graphs and tables, including traffic counts, origin-destination surveys, speed and flow data, and ridership data.
• Structure, validate, and clean datasets received from clients and data collection firms before analysis.
• Produce tables and charts presenting results for reports and client presentations.

Traffic Simulation and Modeling

• Prepare calculation files in specialized traffic software such as Synchro, Aimsun, and Vissim, including network coding, import of speed and flow data, and traffic signal timing configuration.
• Perform vehicle turning simulations using AutoTURN and prepare supporting figures.
• Conduct consistency checks and basic quality control reviews on modeling files before submission to the responsible engineer.
• Document assumptions, versions, and data sources to ensure analysis traceability.

Graphic and Cartographic Production

• Produce plans and conceptual diagrams representing planning and design concepts.
• Create figures and maps illustrating mobility concepts, including networks, routes, flows, typical sections, service areas, and phasing.
• Contribute to the development of standardized graphic templates (maps, figures, and tables) for reuse in reports.
• Monitor and ensure consistency of the visual identity across all graphic deliverables.
• Support the production of visual materials for proposals and public presentations.

Collaboration

• Participate in project kick-off and progress meetings with Quebec teams.
• Quickly integrate review comments from engineers and project managers.
• Propose improvements to templates, workflows, and graphic libraries to improve production efficiency.

Desired Profile

• College diploma or university degree in Civil Engineering, Civil Engineering Technology, Transportation, Urban Planning, Geography, Geomatics, Urban Design, or any other relevant field.
• 2 to 5 years of experience in technical support within a consulting engineering, transportation, or planning environment. Early-career candidates with strong potential will also be considered.
• Versatile technical resource, comfortable with both quantitative data processing and graphic production.
• Strong ability to self-learn software applications, which is a critical requirement given the diversity of tools used.
• Self-motivated, rigorous, and detail-oriented.
• Fluency in French, both spoken and written, is an essential requirement and a screening criterion. The incumbent collaborates daily with Quebec teams and produces figures, tables, and annotations in French.
• Functional English is an asset for communication with other WSP offices.
• Ability to manage multiple assignments simultaneously and deliver within established deadlines.

Technical Skills

Office Software

• Advanced Excel skills (formulas, pivot tables, charts).
• Microsoft Word.
• Microsoft PowerPoint.

Drafting

• AutoCAD.
• AutoTURN.

Traffic Simulation

• Synchro.
• Aimsun.
• Vissim.
• Knowledge of at least one of these tools is considered a strong asset; internal training will be provided for the others.

Graphic Design

• Adobe Illustrator.
• Adobe Photoshop.
• Adobe InDesign.

Mapping

• QGIS.
• ArcGIS.

Collaboration Tools

• Microsoft 365 Suite:
  • SharePoint
  • Teams

Additional Assets

• Data processing or automation skills using Power Query, Python, or VBA.
• Comfort with generative AI tools (Microsoft 365 Copilot or equivalent) to accelerate data processing, formatting, creation of initial graphic drafts, and document summarization.
• Ability to critically validate AI-generated content to ensure calculation and data accuracy, technical consistency, and compliance with WSP visual identity standards.
• Compliance with WSP internal guidelines regarding responsible AI use and client data confidentiality.

Success Indicators

• Volume of technical hours transferred from Quebec engineers to the GCC.
• Accuracy and completeness of calculation worksheets and simulation files, with minimal rework.
• Quality and consistency of graphic deliverables according to WSP visual standards.
• On-time delivery of project deliverables, proposals, and client presentations.
• Progressive expansion of autonomy in the use of simulation tools.

Special Conditions

• Work schedule aligned with the Eastern Time Zone (Montreal).
• Peak workload periods during deliverable submissions or proposal deadlines may require flexibility.
• Daily remote collaboration with teams in Montreal and other Quebec offices.
• Access to specialized traffic software licenses and internal training on the methods used by the Quebec Mobility team.

Qualifications

#Colombia

Schedule

Full-time

Employee Status

Regular

Job Posting

Oct 2, 2026, 1:45:09 AM