Data Analyst

POSITION: DATA ANALYST

**LOCATION: CONCORD, ON**

**REPORTS TO: ENGINEERING SERVICES MANAGER**

**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)

This may include:

- Facilitate the flow of information from the Project Manager to the Project Team.
- Complete assigned project tasks and procure required resources.
- Track project deliverables.
- Review project data for accuracy and completeness.
- Compile project data quantities supporting the invoicing process.
- Issue, review and close project work order documentation.
- Review and maintain documentation for quality assurance.
- Participate in project meetings, status updates, and debriefings.
- Execute project tasks as needed to ensure that projects are advanced.
- 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
- Understanding of project management processes 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**:
**Creativity**

Comes up with many new and unique ideas; easily makes connections among previously unrelated notions; tends to be seen as original and value-added in brainstorming settings.

**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.

**Salary**: $45,000.00-$55,000.00 per year

**Benefits**:

- Casual dress
- Company events
- Disability insurance
- Employee assistance program
- Extended health care
- Life insurance
- On-site parking
- RRSP match
- Tuition reimbursement
- Vision care
- Wellness program

Schedule:

- Monday to Friday

Application question(s):

- Do you have a degree in Environmental or Civil Engineering

**Experience**:

- Data Analytics: 2 years (required)

Work Location: In person