Data Analyst – Summer Student

Systems, Research, & Impact Team

The Calgary Drop-In Centre (the DI) is more than an emergency shelter. We provide essential care as well as health services, employment training, and housing supports to people who need help. Our programs and services connect people to permanent housing that meets their individual needs. Rooted in community and fueled by kindness, the DI proudly serves as part of the Homeless-Serving System of Care.

Position Summary

Reporting to the Senior Advisor, Systems, Research and Impact, the Data Analyst Summer Student Position supports the goal of ending chronic homelessness at the DI, by leveraging and harnessing the power of data in the not-for-profit sector. The DI has a very large and robust dataset, that requires time and attention to recalibrate the data sets to align with the ever-changing needs and barriers that individuals experiencing homelessness often face. The Data Analyst will work with the Senior Advisor, as well as the Organizational Impact Analyst, to assist in the creation of reports and data visualization tools in order to frame existing data and establish frameworks for new data sets.

Time Commitment

Not less than 40 hours per rotation; with 5 days on and 2 days off. Some unusual hours may be required from time to time as the need arises. These hours may be altered at the discretion of management

• This is a summer student position that is funded for a term of eight weeks

Job Duties

• Data Management
  • Assist with maintaining data integrity on the DI's internal database, Guestbook
  • Assisting with developing a strategy for articulating the needs of individuals experiencing homelessness, through the use of data
  • Preparing data for entry by compiling and sorting information; establishing data entry priorities
  • Reviewing historical DI records to create a migration plan to the new database
  • Amalgamate and format large quantities of data into meaningful data sets for analysis
  • Undertake analysis and processing of data sets to produce metrics, indices and summary reports that enable efficient and informed decisions
  • Collaboration with our internal Information Technology (IT) team to explore new automated solutions for data presentation and analysis
  • Research and identify new data solutions for implementation within the organization
  • Complete information management related projects as assigned
    
• Administrative support
  • Responding to and triaging internal data requests
  • Creation of internal processes to support the agency's strategic priority of increasing internal data capacity
  • Developing and enhancing our unit testing, data validation and governance processes to ensure the accuracy of our data portfolio
  • Other administrative tasks as assigned

Required Competencies

• Currently enrolled in computer science or data science / analytics program, or mathematics, statistics, commerce, or business analysis programs
• Proficient in Office365 and Microsoft Office Suite 2016
• Excellent communications skills, both verbal and written
• The ability to make sound rational decisions based on information provided and employ critical thinking where information may not be clear.
• Experience or understanding of open-source software frameworks (Dynamics365), data visualization tools (PowerBI), and databases (SQL and/or VBA)
• Apply solid technical knowledge to understand and apply records management principles, concepts, tools, and technologies
• Resiliency and stress tolerance and the ability to maintain composure, remain calm and focused when dealing with a high volume of volatile and stressful situations.
• Energetic and self-directed, with effective time management and organizational skills including the ability to deal with several priorities at the same time
• High morals, ethics, and integrity
• Eager to learn new systems and adopt improved best practices
• Must demonstrate initiative and work autonomously
• Demonstrated ability to research, analyze, think critically, and synthesize information to enhance user experience and business processes

Working Conditions

While your position does not normally consist of front line work, it is important for us to tell you that front-line staff are exposed to emotionally disturbing events, such as: medical distress, threatened/actual serious injury, violence, abuse, and death; where clients may be experiencing fear, terror, hopelessness, rage, self-harm and conflict. It is understood and accepted that you will be working in distress and/or high-stress situations, which may include emergency response where resiliency and stress tolerance and the ability to maintain composure, remain calm and focused is imperative. Exposure to bodily fluids may also occur.

Why the DI?

The DI aims to be an “Employer of Choice” and affords each employee an opportunity to help make a real difference in our community, and more importantly in the lives of less privileged people. We take great care in hiring the right people who fit, and who share our outlook on the value of people. We believe in living our values in every word we speak and in every action we take, and we want people who understand this commitment.

Our Culture

Our values form the cornerstone of our culture:

RESPECT: Our actions honour the rights, differences, and dignity of others

COMMUNITY: Through collaborative partnerships, we work together as a team, building inclusive communities

KINDNESS: We accept each person’s uniqueness with compassion and empathy

WELLNESS: We promote, provide and support holistic wellbeing

ACCOUNTABILITY: We operate with transparency and integrity in both our relationships and our commitments.

Our Compensation

Some of the great benefits the DI has are agency paid:

• Vacation days
• Sick days
• Wellness days
• Medical & Dental coverage
• Homewood EFAP
• Long-Term Disability*
• Life Insurance and Accidental Death & Dismemberment (AD&D)*
• Critical Illness Insurance*

• Employees will be enrolled in Long-Term Disability, Life and AD&D and Critical Illness insurance, paid for by the employee. This is mandatory and may not be opted out of.

Benefits are based on employment type and usually available the 1st of the month following your start date. If you are successful in obtaining employment with the DI, Human Resources will discuss your eligibility for benefits with you.

E7NCKm4Sdd