SQL Data Engineer (Internship / Co-op)

Location: Calgary, AB (Hybrid – remote + occasional onsite)

Type: 4–6 month internship / co-op (Mitacs Accelerate or co-op eligible) considered a benefit

Start: Fall 2025 or January 2026

About GCL Environmental

GCL Environmental is an Alberta-based firm bringing innovation to the environmental industry making a big impact. We’re building platforms that make field data real-time, reliable, and audit-ready to improve quality and accelerate reporting for clients. We are currently working on 1000s of sites and want to continue to elevate our clients experience. Visit our website at www.gclenv.com (http://www.gclenv.com)

What You’ll Do

- Design and implement event-sourced SQL schemas (snapshots, events, variance records).

- Build idempotent ingestion pipelines (Survey123, Power Automate & SQL).

- Integrate SQL with Microsoft Planner for task orchestration.

- Develop SQL views & Power BI dashboards for near real-time analytics.

- Create tests and replay harnesses to ensure data reliability & resilience.

What We’re Looking For

- Strong skills in SQL (SQL Server / Azure SQL): schemas, stored procs, triggers, views.

- Interest in event sourcing, idempotency, or transactional integrity.

- Bonus: familiarity with Power Platform (Power Automate, Power BI, Planner) or Esri Survey123.

- Enrolled in or recently graduated from Computer Science, Software Development, or Data Analytics.

Why Join Us

- Real-world project: launch a production-grade SQL platform.

- Hybrid work with industry + academic mentorship.

- Exposure to cutting-edge operational analytics in the environmental sector.

- Opportunity to make an immediate impact in a growing innovation-focused company.