WHO WE ARE

Through the vision to eliminate poverty in our community and guided by a passionate concern for the dignity and well-being of each individual, Bissell Centre's work is based on building relationships, hope and trust. Our mission is to work with others to empower people to move from poverty to cultural, social, and economic prosperity. We empower people to meet their own basic daily needs, participate in community and have sustainable livelihoods, secure housing, feel hope for the future and make plans for a prosperous life. By joining Bissell Centre, you will become part of a fast-paced and dedicated team that works together to realize our vision.

Are you a Computer Science or Information Technology Student looking to make an impact in your community? Do you have endless optimism, ready to move and create change in the community? Through the vision to eliminate poverty in our community and guided by a passionate concern for the dignity and well-being of each individual, Bissell Centre's work is based on building relationships, hope and trust. Our community comes from all walks of life and so do we.

Through our programs we work to empower people from meeting their own basic daily needs to having sustainable livelihoods, secure housing, and feeling hope for the future and make plans for a prosperous life. By joining Bissell Centre, you will become part of a fast-paced and dedicated team that works together to realize our vision.

Currently, Bissell Centre is looking for an individual wanting to join our Analysis & Evaluation team. Are you ready to be our Student Database Administrator and make an impact in our community?

ABOUT THE ROLE

Reporting to the Manager, the Database Administrator will oversee the migration of legacy data to Microsoft Dataverse, ensuring smooth integration with Power Apps and Power BI reporting. This includes data extraction, transformation, and loading, as well as resolving import/export issues and validating data integrity. The administrator will collaborate with stakeholders to test and monitor the migration process, ensuring accurate data mapping and formatting. Additionally, they will maintain detailed documentation on migration steps, challenges, and solutions for continuous optimization.

This position will be funded by the Venture for Canada Student Internship program. To qualify for this grant applicants must be either a Canadian citizen, permanent resident, or refugee. They must also be enrolled full-time in an accredited Canadian college or university.

WHAT IS THE ROLE

Duties and Responsibilities

• Lead the migration of legacy data to Microsoft Dataverse, ensuring smooth integration with Power Apps and Power BI for reporting purposes.
• Extract, transform, and load data from legacy systems into Dataverse, ensuring accuracy and alignment with target formats.
• Validate data integrity during migration and troubleshoot any discrepancies or errors in data imports and exports, ensuring successful transfers between systems.
• Monitor and track the progress of data migration, ensuring it is completed within the agreed timeline and meets quality standards.
• Set up monitoring processes for post-migration performance, optimizing data flows and implementing best practices.
• Collaborate with stakeholders to define requirements, map data, test migration, and maintain documentation.
• Provide support in the creation of Power BI reports as needed.
• Perform other duties as required

WHAT YOU BRING TO THE ROLE

Qualifications & Commitment to Values

This position will be funded by the Venture for Canada Student Internship program. To qualify for this grant applicants must be either a Canadian citizen, permanent resident, or refugee. They must also be enrolled full-time in an accredited Canadian college or university.

Formal Education and Experience

• Be a Canadian citizen, permanent resident or refugee.
• Enrolled full-time in an accredited Canadian college or university.
• Actively working towards a diploma or degree in Computer Science, Information Technology, Data Science or a related field (2^nd year or higher).
• Solid understanding of Microsoft Dataverse and Power Apps integration, with hands-on experience in data management and migration.
• Hands-on experience with Microsoft Dataverse for data storage and integration.
• Experience with data migration, mapping, troubleshooting and validating large datasets.
• Knowledge of data import/export tools and resolving related issues.
• Proficient in SQL and troubleshooting database issues.
• Skilled in maintaining documentation for knowledge sharing.
• Knowledge of Power BI is an asset.

Working Conditions

This position is fully remote.

This position will foster a collaborative work culture between the Analysis & Evaluation team.

Flexibility of the working week is inherent in this position. Flexibility to work a combination of weekdays and weekends may be required, with a focus on work-life balance.

Guiding Competencies

The Student Database Administrator should demonstrate strong competency in the following:

• Behave Ethically: Understand ethical behavior and business practices and ensure own behavior is consistent with these standards and aligns with the mission, vision, and core values of Bissell Centre.
• Build Relationships: Establish and maintain positive working relationships with others, both internally and externally, to achieve the goals of the organization.
• Communicate Effectively: Speak, listen, and write in a clear, thorough, and timely manner using appropriate and effective communication tools and techniques.
• Focus on Participant Needs: Anticipate, understand, and respond to the needs of participants and the community to meet or exceed their expectations within the organizational parameters.
• Foster Teamwork: Foster, sustain and role model productive team management practices, and contribute to a positive team environment. Share expertise and knowledge to support, coach and develop others.
• Make Decisions: Assess situations to determine the importance, urgency and risks, and make clear decisions that are timely and in the best interests of the organization.
• Organizational Skills: Set priorities, develop a work schedule, monitor progress towards goals, and track details/data/information/activities.
• Plan: Determine strategies to move the organization forward, set goals, create and implement action plans, and evaluate the process and results.
• Solve Problems: Assess problem situations to identify causes, gather and process relevant information, generate possible solutions, and make recommendations and/or resolve the problem.

Screening Requirements

• Criminal Record Check
• Child Intervention Record Check

Training Requirements

• Conflict into Calm Training

The above listed training requirements must be completed within the first three months of employment. Other training requirements may be identified during employment and must be completed as directed.

HOW TO APPLY

Interested candidates are invited to submit their resume and cover letter to: ajose@bissellcentre.org.

We thank all applicants for their interest. However, only candidates selected for interview will be contacted.

As the COVID-19 pandemic evolves, Bissell Centre continues to take action to protect person served and staff. Strategies related to Bissell Centre's response to COVID-19 are driven by the guiding principle of taking all reasonable precautions and measures to protect the health and safety of both persons served and staff. In keeping with this intentional purpose, COVID-19 full vaccination is a condition of employment for new hires, except due to legitimate, established exceptions.

Bissell Centre is an equal opportunity employer who is committed to diversity within our community and welcomes applications from all qualified individuals regardless of race, national or ethnic origin, colour, religion, age, sex, sexual orientation, gender identity or expression, marital status, family status, genetic characteristics, or disability. Bissell Centre is committed to the principle of equal employment opportunity for all employees, in accordance with provincially and federally legislated protected grounds.