Data Analyst

**Who You Are**:
You are an inquisitive Data Analyst with strong mathematical skills, analytical reasoning, and understanding of hydraulic principles. You are action-oriented, manage time effectively, and employ innovative problem-solving techniques to achieve success.

Your mission at Smith Cameron Group - Flowmetrix is to ensure the highest degree of data quality is achieved and any issues are resolved in a timely manner. This data may include sanitary, combined, or storm sewer flow data, sewer system inspection data, wastewater treatment plant (WWTP) records, rain data, pump station data, etc.

To be successful in this role you work well in both individual and team environments. You are technically strong and are highly adaptable.

**About the Role**:

- Analyze data for calibration, trends, patterns, and outliers, using graphical and statistical analysis.
- Follow standard procedures and data processing techniques to prepare data for review and audits.
- Identify data issues and propose solutions.
- Assist in final report preparation, producing work of professional quality, accurately and timely.
- Assist with work order management.
- Communicate data quality issues to field staff and project managers.
- Assist with project engineering tasks.
- Participate in the implementation of assigned projects (when time permits)
- All other tasks as assigned by manager.

**Required Experience**:

- Degree/Diploma in a field related to either Environmental or Civil Engineering or a combination of education and experience.
- Minimum 1 year of data analysis experience in engineering and/or environmental field.
- Basic understanding/familiarity with databases or Geographic Information Systems (GIS)
- Familiar with regression models and other statistical tests
- Knowledge of data analysis and statistics to find data correlation, outlier analysis and interpret the statistical result
- Intermediate knowledge of Excel
- Water Resources /Hydraulic background is an asset.
- Understanding of project management processes is an asset.
- Knowledge of Python is an asset.
- Experience with ERP’s is an asset.
- GIS and VBA knowledge is an asset
- Basic understanding of ADS product lines, services, and software is an asset.

**Competencies**:
**Dealing with Ambiguity**
Can effectively cope with change; can shift gears comfortably; can decide and act without having the total picture; is not upset when things are up in the air; doesn’t have to finish things before moving on.

**Decision Quality**
Makes good decisions (without considering how much time it takes) based upon a mixture of analysis, wisdom, experience, and judgment; most of his/her solutions and suggestions turn out to be correct and accurate when judged over time; sought out by others for advice and solutions.

**Functional/Technical Skills**

Has the functional and technical knowledge and skills to do the job at a high level of accomplishment.

**Informing**

Provides the information people need to know to do their jobs and to feel good about being a member of the team, unit, and/or the organization; provides individuals information so that they can make accurate decisions; is timely with information.

**Interpersonal Savvy**

Relates well to all kinds of people, up, down, and sideways, inside and outside the organization; builds appropriate rapport; builds constructive and effective relationships; uses diplomacy and tact; can diffuse even high-tension situations comfortably.

**Time Management**

Uses his/her time effectively and efficiently; values time; concentrates his/her efforts on the more important priorities; gets more done in less time than others; can attend to a broader range of activities.

Pay: From $55,000.00 per year

**Benefits**:

- Dental care
- Disability insurance
- Employee assistance program
- Extended health care
- Life insurance
- On-site parking
- Vision care
- Wellness program

Schedule:

- 8 hour shift

Supplemental pay types:

- Overtime pay

**Experience**:

- Water Resources /Hydraulic: 1 year (preferred)
- DA experience in engineering and/or environmental field: 2 years (required)

Licence/Certification:

- Environmental Science/ Engineering Degree (preferred)

Work Location: In person