Programs Database Analyst
Full Time • Manager, Analysis and Evaluation
About the Role
The role of the Programs Database Analyst is to analyze data requirements within an organization, design, test and implement data collection systems, build reports to meet organizational needs and ensure staff are trained in data entry and reporting. In addition, the Programs Database Analyst will work with management to ensure that data collection protocols are being followed and/or are consistent with operational and reporting needs. The Programs Database Analyst also ensures data collection systems are compliant with requirements articulated in PIPA, FOIP, and HIA.
Duties and Responsibilities
Programs Database Analyst
- Identify, understand and plan for organizational and human impacts of various data collection systems, and ensure that new technical requirements are properly integrated with existing processes and skill sets
- Plan and document data system flow from the ground up
- Interact with internal users and stakeholders to learn and document requirements
- Interact with third party systems developers and management to understand software limitations and new functionalities
- Perform system testing
- Design and implement database systems, as well as separate program models
- Elicit and analyze stakeholder feedback on an ongoing basis; address forthcoming issues
- Review, evaluate and report database trends and discrepancies
Database Administration and Training
- Develop user training manuals
- Support program database experts to ensure staff are trained on their respective database programs
- Ensure that all organizational database support needs are met (troubleshooting, etc.)
- Control and monitor user access to databases
- Ensure that program staff and leadership are trained on pulling the latest program data as required
- Create new reports and provide statistics as data requirements change
- Participate in probationary and annual performance reviews
- Attend scheduled staff and supervision meetings
- Perform other duties as required
Education and Experience
- Diploma or degree in related field
- Minimum 2 years related working experience in database analysis or administration
- Experience working with social services databases would be considered an asset
- Education and/or experience in community services and programs would be an asset
Knowledge, Skills and Abilities
- General understanding of research, analysis and process thinking
- Strong verbal and written communication skills with the ability to establish and maintain effective working relationships with partners, stakeholders, public, government officials and management
- Accurate and efficient keyboarding, data entry skills and working knowledge in operating office equipment e.g. printer, copier and fax machine.
- Excellent proficiency with Microsoft Office Suite 2007 (PowerPoint, Word, Excel, Outlook (email) and Outlook Calendar), Internet navigation, databases and general computer use
- Flexible, able to prioritize problem-solving, multi-task, and deal with difficult situations in a calm and confident manner.
- Demonstrate a non-judgemental attitude, respectful and patience when dealing with people who live in poverty
- Familiarity with issues of poverty, community based organizations and the services they provide
The Programs Database Analyst should demonstrate competence in all of the following:
- Behave Ethically: Understand ethical behavior and business practices and ensure own behavior is consistent with these standards and aligns with the mission 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.
- Criminal Record Check
- CWIS Check
- Standard First Aid and CPR
- Conflict into Calm Training
The above-noted training must be completed during the first six months of employment or as agreed upon with the supervisor.
HOW TO APPLY
Interested candidates are invited to submit their resume and cover letter to:
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.