database analyst

Community Development Council Durham; Ajax; On-site; CAD 80,000 - 110,000; Full time

Benefits offered by this job

Dental plan?

Health care plan

Vision care benefits

RRSP

Free parking

Job summary

Community Development Council Durham in Ajax, Ontario seeks an IT professional to design, implement, and manage databases and data systems. You will collect data to identify IT improvements, document requirements, and ensure secure access.

This role requires collaboration across staff and hands-on database work on-site. The ideal candidate has a Bachelor’s degree in computer science or related field and 2–3 years of experience, with strong skills in data visualization, MS Office, and

Qualifications

• Bachelor's degree in a related field.
• 2 years to less than 3 years of experience in IT/information systems.
• On-site work at a physical location in Canada (Ajax).

Responsibilities

• Collect data to identify areas for improvement within an IT infrastructure.
• Develop and implement a strategic blueprint for deploying databases.
• Develop and maintain computer databases.
• Document customers’ requirements for projects.
• Document reporting needs, queries, logic, results and recommendations to information systems professionals.
• Enact measures to prevent unauthorized data access.
• Liaise with staff on data requirements and availability.
• Set up IT infrastructure to allow applications to access databases.
• Test data models and database management systems.
• Design and develop databases.
• Operate database management systems to analyze data.

Skills

Mapping and data visualization

MS Office

Spreadsheet

Computer programming

Database management

Education

Bachelor's degree

Computer science

Computer engineering

Job description

• Dental plan

Overview

Languages

English

Education

• Bachelor's degree
• Computer science
• Computer engineering, other

Experience

2 years to less than 3 years

On site

Work must be completed at the physical location. There is no option to work remotely.

Responsibilities

Tasks

• Collect data to identify areas for improvement within an organization’s IT infrastructure
• Develop and implement a strategic blueprint to follow when deploying databases within their organization
• Develop and maintain computer databases
• Document customers’ requirements for projects
• Document reporting needs, queries, logic, results and recommendations to other information systems professionals
• Enact measures to make sure unauthorized users cannot access the data
• Liaise with staff on data requirements, collection and availability
• Setup the IT infrastructure to allow applications to access databases
• Test data models and database management systems
• Design and develop database
• Operate database management systems to analyze data

Experience and specialization

Computer and technology knowledge

• Mapping and data visualization software
• MS Office
• Spreadsheet
• Computer programming
• Database management

Additional information

Security and safety

• Criminal record check

Work conditions and physical capabilities

• Work under pressure
• Tight deadlines
• Attention to detail
• Sitting

Personal suitability

• Accurate
• Organized
• Team player
• Adaptability
• Accountability
• Quick learner

Benefits

Health benefits

• Dental plan
• Health care plan
• Vision care benefits

Financial benefits

• Registered Retirement Savings Plan (RRSP)

Other Benefits

• Free parking available

Employment groups

This employer promotes equal employment opportunities for all job applicants, including those self-identifying as a member of these groups:

Support for persons with disabilities

• Provides physical accessibility accommodations (for example: ramps, elevators, etc.)
• Participates in a government or community program or initiative that supports persons with disabilities
• Provides awareness training to employees to create a welcoming work environment for persons with disabilities
• Applies accessible and inclusive recruitment policies that accommodate persons with disabilities

Support for newcomers and refugees

• Participates in a government or community program or initiative that supports newcomers and/or refugees
• Assists with immediate settlement needs of newcomers and/or refugees (for example: housing, transportation, storage, childcare, winter clothing, etc.)
• Supports social and labour market integration of newcomers and/or refugees (for example: facilitating access to community resources, language training, skills training, etc.)
• Provides diversity and cross-cultural trainings to create a welcoming work environment for newcomers and/or refugees
• Does not require Canadian work experience

Support for youths

• Offers mentorship, coaching and/or networking opportunities for youth
• Provides awareness training to employees to create a welcoming work environment for youth

Support for Indigenous people

• Offers mentorship, coaching and/or networking opportunities for Indigenous workers
• Develops and maintains relationships with indigenous communities, indigenous-owned businesses and organizations
• Facilitates access to Elders who can offer support and guidance to Indigenous workers

Support for mature workers

• Participates in a government or community program or initiative that supports mature workers
• Applies hiring policies that discourage age discrimination
• Provides staff with awareness training to create a welcoming work environment for mature workers
• Provides workspace accommodations, such as age-appropriate ergonomic considerations, to meet the physical needs of mature workers (for example: adjustable desks and chairs, accessible parking, etc.)

Supports for visible minorities

• Applies hiring policies that discourage discrimination against members of visible minorities (for example: anonymizing the hiring process, etc.)
• Provides diversity and cross-cultural training to create a welcoming work environment for members of visible minorities