Intern / Co-Op – Data/Computer Science - University of Guelph

at  Geosyntec Consultants Inc

Overview:
Looking for a place to start your career? A place where you can work with industry recognized professionals who are solving tough environmental engineering problems? Geosyntec is the place for you! As an Intern / Co-Op – Data/Computer Science - University of Guelph in our Guelph, Toronto or Waterloo office, you will have the opportunity to apply your engineering or computer science academic knowledge to real-world situations while also learning the business skills needed for a successful consulting career.
We are seeking an engineering co-op / intern for approximately 13 to 15 weeks during the fall semester of 2024. This opening is for a 40-hour per week position and part-time employment will not be considered. It is preferable to have a co-op candidate who could return to the position for up to two additional semester rotations during their undergraduate or graduate studies. Candidates are responsible for coordinating their own transportation to and from the office.
Our clients ask us to address their new ventures and most challenging problems involving the environment, natural resources, and civil infrastructure. Geosyntec is internationally known for its technical leadership, broad experience, and exceptional client service. Learn more by visiting www.geosyntec.com.
Essential Duties and Responsibilities:

Is this the right position to help you achieve your professional goals? Some of the key responsibilities for position include:

• Monitoring and maintaining existing scripting tools and workflows, while also performing regular audits and assessments;
• Building JavaScript widgets for frontend applications;
• Authoring scripts in Python or other languages to compile, transform, and visualize data; such as custom Excel ETL tools;
• Designing, developing, and managing databases in SQL Server;
• Creating web-based reports and dashboards using BI tools;
• Pipelining data from servers to dashboards/tools efficiently;
• Ensuring data outputs are well defined and readily accessible;
• Conducting data input and analysis, includes preparing maps, tables, and figures to effectively visualize and communicate key insights derived from data analysis;
• Follow instructions and interact with engineers, geologists, office administrative staff, CADD operators, contractors and construction personnel.

Education and Licensure:

• Currently registered in a Bachelor’s or Master’s university degree program in a relevant Computer Science or related discipline. (required)

Skills, Experience and Qualifications:

• MS SQL Server and T-SQL skills. (required)
• Intermediate Python skills. (required)
• Basic JavaScript Skills and knowledge of front-end development. (required)
• Experience with database management and building ETL processes. (preferred)
• Experience implementing operational automation using scripting techniques. (preferred)
• Experience with GIS Software (ArcGIS Pro, ArcGIS Online). (preferred)
• Familiarity with basic scientific and engineering concepts (basic chemistry, engineering unit conversions, introductory statistics, algebra and geometry). (preferred)
• Strong analytical and problem-solving skills. (required)
• Outstanding academic credentials and exceptional interpersonal, technical writing, problem-solving skills, workflow management, and documentation proficiency. (required)

• Monitoring and maintaining existing scripting tools and workflows, while also performing regular audits and assessments;
• Building JavaScript widgets for frontend applications;
• Authoring scripts in Python or other languages to compile, transform, and visualize data; such as custom Excel ETL tools;
• Designing, developing, and managing databases in SQL Server;
• Creating web-based reports and dashboards using BI tools;
• Pipelining data from servers to dashboards/tools efficiently;
• Ensuring data outputs are well defined and readily accessible;
• Conducting data input and analysis, includes preparing maps, tables, and figures to effectively visualize and communicate key insights derived from data analysis;
• Follow instructions and interact with engineers, geologists, office administrative staff, CADD operators, contractors and construction personnel