Data Specialist

Make a significant impact in the lives of people with developmental disabilities by joining Canada's largest Developmental Disabilities service provider.

Calling all change-makers, innovators, advocates and digital information and technology professionals to consider this opportunity!

Full-Time, Temporary

(3 months, with a possibility of extension)

Data Specialist

(40 hours/week)

Waterloo Office (In-Office)

The Data Specialist is responsible for creating and supporting data and analytics products by enabling data integrity across data sources at Karis Disability Services. This includes maintaining, transforming, and presenting data. Data maintenance includes documenting the current data and designing the desired future state of data architecture. The Data Specialist will deploy practical solutions that will ensure data is accurately moving between systems and is stored securely. The Data Specialist enables users to see the data they are authorized to see in a way that will help the user make good decisions.

Responsibilities include: 

Data Maintenance & Documentation

• Implement master data management including providing documentation for data dictionaries and catalogs.
• Conduct data discovery and documentation of relevant (highest priority) data schemas and sources.
• Audit and analyze data to ensure consistency, correctness, and fitness for use.
• Document data flows and usage within systems and identify potential concerns or issues with data.
• Execute and monitor data cleaning processes to ensure that data within source systems remains consistent, correct, and cohesive.

Data Access, Analytics, and Usage

• Consult with internal stakeholders to assess end-user data needs and develop data products.
• Develop Extract Transform Load (ETL) processes and workflows to move data from internal and external sources to the data warehouse.
• Design and architect data warehouses, determining a structure for storing data and presenting data products while maintaining security.
• Develop technical specifications for the recommended policies, reviewing and providing input into draft policies.
• Test, validate, and document data access and usage.

Data Visualization and Presentation

• Create dashboard visualizations to present data that has been extracted or transformed.
• Prioritize and execute report creation based on requests within the organization.
• Develop data products (e.g., views, data extractions, simple data collection tools).
• Complete ad-hoc analysis and export files in Excel, SSRS, SSIS, PowerBI, and other tools.
• Track access to, and usage of, visualized data and reports.
• Be a resource to departments for in-application reporting tools (e.g., Cognos, SSRS, Report Builder).

Requirements:

• 1 year of previous work experience, in data or software development
• University Degree or College Diploma in a related field of study (Data Analytics, Data Science, Computer Programming, Statistics)
• Data analysis and presentation skills
• Experience with Data Tools and Languages including SSIS, SSRS, Python, Excel Macros, PowerBI, SQL
• Business analysis skills including requirement gathering, stakeholder engagement, and responding to user feedback

Why Should You Apply?

• Live out our shared values, help others, and find purpose in your work every day.
• Receive competitive wages.
• Find support through an Employee and Family Assistance Plan.
• Make a significant impact in the lives of people with developmental disabilities, and the sector, by joining Canada’s largest Developmental Disabilities service provider

Application Deadline: November 22nd, 2024

Apply with a cover letter and résumé by November 22nd, 2024, to the attention of the Business Intelligence Manager Via the ‘Apply Now’ feature.

• Start Date: December 2024

Karis Disability Services seeks to hire a workforce that represents the diversity of our communities where we serve. We are committed to promoting communities of belonging where Black, Indigenous, and People of Colour feel valued, respected, represented, and heard. We encourage applications from qualified candidates from members of groups with historical or current barriers to equity. We seek to provide accessibility through all stages of the hiring process for all applicants with disabilities, consistent with our Accessibility Policies and the AODA. Please let us know if you require accommodation, and we will work with you to meet your accessibility needs.