Data Wrangler

**WSP **is one of the world's leading professional services firms. Our purpose is to future proof our cities and environments.

We have over 65,000 team members across the globe. In Canada, our 12,000+ people are involved in everything from environmental remediation to urban planning, from engineering iconic buildings to designing sustainable transportation networks, from finding new ways to extract essential resources to developing renewable power sources for the future.

The excellence we bring to our work and to our workplace has been recognized far and wide. We are among the LinkedIn Top 25 Companies two years in a row, one of the Top 100 Sustainable Companies in the World (and among the Top 10 in Canada), and we earned Platinum Elite Recognition through our participation in more than half of Canada's Top 100 Infrastructure Projects.

At **WSP**:

- We value our people and our reputation
- We are locally dedicated with international scale
- We are future focused and challenge the status quo
- We foster collaboration in everything we do
- We have an empowering culture and hold ourselves accountable

**MONTREAL | THORNHILL | MISSISSAUGA | TORONTO**

***The Opportunity**:
The Data Wrangler is a member of the Global Engineering Apps Information Management (IM) team. You will work with our IM team, groups of engineers and scientists using our Geo IM and Chemistry IM Systems, developers, project managers, business analysts, vendors, and IT staff to improve and enhance our handling of technical discipline related data. Our IM team uses agile methods to deliver quality results in time.

***

**Why WSP?**
- We value and are committed to upholding a culture of **Inclusion **and **Belonging**:

- Our **Flexible Work Policy** - we recognize the importance of balance in our lives and encourage you to prioritize the balance in yours. We will support you on and off the job so you can be fully present in both your work and home lives.
- Our **Hybrid Work Policy**:

- a combination of in-person and remote working, enables us to purposefully think of how we work, who we need to work with, and where the work should be done.
- A **Canadian **success story - we're **proud **to wear the red and white of this beautiful country and show the world what Canada has to offer.
- **Enhance **the world around you - from the environment to the highways, to the buildings and the terrain, WSP is the fabric of Canada.
- **Outstanding** career opportunities - we're growing and pushing ourselves every day to be greater than yesterday - we're open to **your **ideas and trying **new **things.
- A phenomenal **collaborative **culture and a workforce filled with genuinely **good people** who are doing humbly important work. Come find out for yourself what it's like to be a part of our journey.

**We offer attractive pay, flexible work options, a great corporate culture, comprehensive and employee-focused benefits including virtual healthcare and a wellness platform as well as great savings programs, and a clear vision for the future.**

**#WeAre**WSP**

**A day in the life**:

- Work with project managers, business groups, vendors, developers, and IM specialists to create processes for getting historical datasets into our engineering and scientific information management systems as well as processes to prepare data from our IM systems for client data delivery.
- Produce clean, efficient scripts, queries, and processes to help review, structure, format, clean, qa/qc, and otherwise prepare data for import into our IM systems. Data may be in csv, excel, Access database files, other databases, IoT, or other formats.
- Collaborate with scientific and engineering staff to create efficient data workflows for getting data from IM systems prepared/accessible for use in specialized third party engineering apps including numerical model inputs, 3D visualizations, etc.
- Work with Azure developers to make your scripts and processes easily accessible to scientists and engineers who may not have Python skills as well as make them available for use by those with scripting skills.
- Configure Power BI reports connected to third party SQL databases.
- Support users of IM systems with technical questions, troubleshooting, and training related to getting their data into and out of our systems.
- Create How to Guides explaining use of data wrangling processes (step-by-step guides and short videos).
- Exercise responsible and ethical decision-making regarding company funds, resources and conduct, and adhere to WSP’s Code of conduct and related policies and procedures.
- Perform additional responsibilities as required by business needs.

***What you'll bring to WSP...**
- Bachelor’s Degree in Information Management, Data Science or a related field.
- A minimum of 3 years use and knowledge of Python, SQL
- A minimum of 3 years relevant post-education experience extracting, transforming, and loading data from csv, excel files, Access files, and SQL databases.
- 3