Data Analyst

at  City of Ottawa

Requisition ID: 11998
Department: Community & Social Services Dept.
Service: Comm Saf, Well-Being,Pol & Anlt Services
Branch: Soc Pol, Research & Analytics Branch
Employment Type: 1 Temporary Full Time Position (Up to 1 Year)
Work Hours: 35 hours per week
Affiliation: CIPP
Salary Information: $74 590,88 - $90 759,76 annually (2022 rates of pay)
Location: City Hall,110 Laurier Avenue West
City: Ottawa, ON
Job Category: Community and Social Services
Application Close: 28/03/2024

JOB SUMMARY

The Community and Social Services department is responsible for creating a strong social infrastructure by providing support to families and individuals in need to promote their self-reliance and quality of life, and in collaboration with community partners. This includes providing financial assistance, housing, childcare, employment, and long-term care.
The Social Policy, Research & Analytics Services team strives to increase the collective well-being of the City of Ottawa by unlocking the value of data. Our team looks at how we can leverage our existing and corporate strengths to better use data across our service areas.
As a data analyst, you will join a passionate, technical, and data-driven team that is motivated to improve the availability, consistency, and accessibility of data within and across CSSD service areas. The team is committed to incorporating equity, diversity, inclusion, and an Indigenous reconciliation, anti-racism, and gender-equity approach in all that we do. We want all clients to feel heard, seen and reflected in the data collection and analysis process.
You will be responsible for extracting, cleaning, preparing, and visualizing data for analysis, performance, and advanced analytics on a team of socially driven data professionals.
The City of Ottawa promotes the principles of diversity and inclusion and adheres to the tenets of the Canadian Human Rights Act and the Ontario Human Rights Code. We encourage applications from women, people with disabilities, Aboriginal peoples, and persons of all races, ethnic origins, religions, sexual orientations, and gender identities and expressions.

EDUCATION AND EXPERIENCE

Completion of 4 year university degree in Statistics, Economics, Mathematics, Computer Science, Data Science, Business Intelligence, Business Administration or a related field
Minimum of 3 years of experience in the field of data and analytics

KNOWLEDGE

• General knowledge of corporate technology systems and databases, business intelligence and data visualization tools
• Data systems and statistical data collection
• Survey techniques and methodologies
• Database management and data handling procedures (data integrity, statistics)
• Data management software such as Microsoft ACCESS
• Advanced skills in Microsoft EXCEL
• Microsoft Office software (Word, PowerPoint and Outlook)
• Records management systems
• Knowledge of applicable health and safety legislation, including the rights and duties of workers
• Knowledge or experience with a centre of excellence approach to enabling an organization and customers to self-serve advanced analytics is highly desirable

COMPETENCIES, SKILLS AND ABILITIES

• Prepare and deliver technical summary reports
• Data handling and statistical analysis
• Analytical skills backed by proficiency in dealing with data
• Skilled with data visualization tools such as Tableau, QlikView, or similar
• Plan, organize, and schedule work
• Work professionally with technical staff, consultants, and research partners
• Communicate effectively both verbally and in writing, with different stakeholders
• Ability to undertake projects and tasks with minimal supervision
• Ability to work in a team with technical staff
• Ability to manage multiple priorities in a fast-paced, ever changing environment.
• Strong initiative, judgment and reliability
• Highly motivated and conscientious
• Diplomacy, discretion and tact
• Works well in a team environment
• Desire and flexibility to expand their knowledge base to grow their skills in adjacent disciplines

WHAT YOU NEED TO KNOW

• Language Requirement: English oral, reading, writing
• Police Record Check: The successful candidate will be required to complete a Vulnerable Sector Check with the Police Services detachment in their jurisdiction to the City of Ottawa’s satisfaction.
• Experience and formal training combined with demonstrated performance and ability may substitute for stipulated academic requirements.
• Please save a copy of the job poster. Once the closing date has passed, it will no longer be available.
  We wish to thank all applicants for their interest and effort in applying for this position. Only candidates selected for interviews will be contacted.
  The City of Ottawa promotes the principles of diversity and inclusion and adheres to the tenets of the Canadian Human Rights Act and the Ontario Human Rights Code. We encourage applications from members of Indigenous, Black and other racialized communities, persons with disabilities, women and non-binary persons, persons of all ethnic origins, religions, sexual orientations, classes, gender identities and expressions.
  Candidates are encouraged to self-identify as a member of one or more designated employment equity groups in the self-identification questionnaire.
  The City of Ottawa provides accommodation during all parts of the hiring process, upon request, to applicants with disabilities. If contacted to proceed to the selection process, please advise us if you require any accommodation.
  Accessible formats and communication supports are available upon request. Please contact the HR Service Centre at 613-580-2424, extension 47411.

Please refer the Job description for details