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, whereappropriate. 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 Canadain accordance withrelevant provincial or territorial legislation and regulations Having a valid Social Insurance Number at the start of employment Who We Are 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 equitydeserving groups. We value all the ways that our community is diverse in identity, experience and perspective. What to Expect The Communications Specialist will optimize SQL queries and database performance, automate tasks using Python, and manage data archiving and lifecycle processes. The role also involves documenting workflows and working with SQL Server and Azure storage. What Youll Do This list highlights core responsibilities and is not exhaustive. Additional related duties may arise over time and will be discussed and supported by your supervisor. SQL Querying Work Analyze slow-running queries and suggest improvements. Implement indexing, query refactoring, and partitioning. Python Querying and Automation. Create step-by-step guides for decommissioning and archival. Document SQL queries, Python scripts, and automation logic. Managing Historical Data Design and implement archival strategies for historical data. Data lifecycle management: retention and cleanup methodologies. SQL server databases skills regarding schemas and indexes. Azure storage accounts and blob containers. What You Bring Qualifications & Experience 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 How to Apply Please submit your resume and cover letter through ADP. Distress Centre is an inclusive workplace. If you require accommodation at any stage of the application or interview process, please contact were happy to support you. We thank all applicants for their interest; only those selected for an interview will be contacted. #J-18808-Ljbffr
Job Title
Communications Specialist