Communications Specialist

Distress Centre CalgaryCalgary, AB
Onsite

About The Position

This is a full-time, 8-week position with standard working hours from 9:00 AM to 5:00 PM. Flexible work arrangements may be considered and discussed with the successful candidate, where appropriate. This position is supported through the Canada Summer Jobs (CSJ) 2026 program. Applicants must meet the program eligibility criteria, including: Being between 15 and 30 years of age at the start of employment; Being a Canadian citizen, permanent resident, or a person granted refugee protection under the Immigration and Refugee Protection Act for the duration of the job; Being legally entitled to work in Canada in accordance with relevant provincial or territorial legislation and regulations; Having a valid Social Insurance Number at the start of employment. Work location: On-site at Distress Centre Calgary, 999 8 Street SW, Suite 500. For over 50 years, Distress Centre has served Calgary and Southern Alberta by providing 24-hour crisis support, information, and resources at no cost. Distress Centre does not define crisis. We do not judge. Anyone can call us day or night. We are committed to fostering a respectful, inclusive workplace where employees are valued, experience a sense of belonging, and are confident being their most authentic selves. We welcome and encourage applications from Indigenous peoples, people with disabilities, and members of equity-deserving groups. We value all the ways that our community is diverse – in identity, experience and perspective.

Requirements

  • Studies in Data Systems, Information Technology, or a related field
  • Familiarity with system administration, database management, or data analytics
  • Experience or coursework with business intelligence tools (Power BI, Tableau, etc.)
  • Understanding of basic cybersecurity principles and user access control
  • Strong analytical and problem-solving skills
  • Working with SQL Server
  • Working with Azure storage

Nice To Haves

  • SQL Server databases skills regarding schemas and indexes.
  • Azure storage accounts and blob containers.

Responsibilities

  • Optimize SQL queries and database performance.
  • Automate tasks using Python.
  • Manage data archiving and lifecycle processes.
  • Document workflows.
  • Analyze slow-running queries and suggest improvements.
  • Implement indexing, query refactoring, and partitioning.
  • Create step-by-step guides for decommissioning and archival.
  • Document SQL queries, Python scripts, and automation logic.
  • Design and implement archival strategies for historical data.
  • Data lifecycle management: retention and cleanup methodologies.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service