We are looking for a Data Warehouse Application Support specialist to join a service-focused team in Thornhill, Ontario.

This role supports data warehouse operations, reporting, and analytical processes while helping ensure data reliability and timely issue resolution.

The successful candidate will combine strong technical expertise with clear communication, sound documentation practices, and the ability to work effectively in an Agile environment.

Responsibilities: Support day-to-day operation of data warehouse applications by investigating issues, resolving defects, and maintaining stable system performance.

Develop and enhance Python-based scripts and processes to automate support activities, data handling, and operational tasks.

Write and optimize SQL queries across Oracle and SQL Server environments to troubleshoot data issues and validate results.

Build, update, and maintain dashboards, reports,



and Power BI deliverables that support business visibility and decision-making.

Monitor ETL workflows, including SSIS-related processes, to identify failures, coordinate fixes, and improve data flow reliability.

Produce transparent technical documentation for support procedures, reporting logic, recurring issues, and resolution steps.

Collaborate with cross-functional teams in Agile delivery settings, participating in planning, tracking, and continuous improvement activities using tools such as JIRA.

Contribute to quality assurance efforts by validating outputs, testing changes, and helping maintain high data accuracy standards.

Provide project-based support and take the lead on assigned initiatives when required, ensuring deadlines and service expectations are met.

📌 Data Warehouse Application Support (Thornhill)
🏢 Robert Half
📍 Thornhill