RQ00745-Data Science Developer at Source Code in Toronto, ON, Canada

Job description

• Public Health Ontario (PHO) is building provincial enhanced analytics capability and infrastructure that turns public health data into timely analytics, surveillance, and decision support. The Data Engineer / Data Science Specialist builds and automates the data foundation that the Engine and its initiatives rely on: cloud-based data pipelines, lake/Lakehouse structures, analytics models, and visualizations.
• The role combines two functions. As a Data Engineer, it automates the data pipeline for analytic products and advanced analyses. As a Data Science Specialist, it helps identify and prioritize use cases and integrate AI techniques (machine learning, NLP) into PHO's work, increasing capacity for modelling, forecasting, and scenario analysis. The role supports both foundational capability/infrastructure work and HealthMap data ingestion and aligns with and advances the Public Health Data Utility (PHDU) on PHO's Azure platform.

Responsibilities

• Participate in product teams to analyze system requirements, and architect, design, code, and implement cloud-based data and analytics products that conform to standards.
• Design, create, and maintain cloud-based data lake and Lakehouse structures, automated data pipelines, analytics models, and visualizations (dashboards and reports).
• Liaise with IT colleagues to implement products, conduct reviews, resolve operational problems, and support business partners in the effective use of cloud-based data and analytics products.
• Analyze complex technical issues, identify alternatives, and recommend solutions.
• Prepare and conduct knowledge transfer.
• Automate the data pipeline for analytic products and advanced analyses, including ingestion, ETL, and production for the foundational capability and for HealthMap (DLSPH model data).
• Help identify and prioritize analytic use cases and integrate AI techniques (machine learning, NLP) into PHO's work.
• Increase PHO's capacity for modelling, forecasting, and scenario analysis.
• Build on and advance the PHDU and PHO's Azure data and analytics platform; support data acquisition through data-sharing and governance processes where required.
• Document methods and transfer knowledge to PHO staff so the pipeline and capability can be sustained beyond the engagement.
• Automated data pipelines and cloud data lake / Lakehouse structures supporting the capability and HealthMap.
• Analytics models and visualizations (dashboards and reports) conforming to standards.
• Prioritized AI / ML use cases and supporting models (forecasting, scenario analysis).
• Knowledge-transfer documentation and sessions for PHO technical staff.

Requirements

• Experience with multiple cloud-based data and analytics platforms and coding / programming / scripting tools to create, maintain, support, and operate cloud-based data and analytics products.
• Experience designing, creating, and maintaining cloud-based data lake and Lakehouse structures, automated data pipelines, analytics models, medallion architecture, and visualizations (dashboards and reporting) in real-world implementations.
• Deep experience with modern technology stacks: Azure Storage, Azure Data Lake, Azure Databricks Lakehouse, and Azure Synapse. Power BI, Python, SQL, Azure Databricks, and Azure Data Factory.
• Experience assessing client information-technology needs and objectives.
• Experience problem-solving to resolve complex, multi-component failures.
• Experience preparing knowledge-transfer documentation and conducting knowledge transfer.
• A team player with a track record for meeting deadlines.
• Be an advanced professional able to apply concepts, practices, and procedures in practice.
• Work with minimal direction and lead and train others in technical components and concepts.
• Plan, lead, and deliver complex deliverables that provide options for decisions within the organization.
• Bring a high level of expertise in the required skill set, specialized in the technical area, and provide specific advisory support as required.
• AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting and business operations.
• Note: The higher end of the range is intended for absolutely exceptional candidates who meet all must-have requirements and most or all nice-to-have qualifications. The client will evaluate candidates based on both rate expectations and overall skill set when shortlisting.
• Written and oral communication skills to participate in team meetings, write and edit systems documentation, prepare and present written reports on findings and alternative solutions, and develop guidelines / best practices.
• Interpersonal skills to explain and discuss the advantages and disadvantages of various approaches.
• Experience conducting knowledge-transfer sessions and building documentation for technical staff on architecting, designing, and implementing end-to-end data and analytics products.

Skills

Required

• Coding / programming / scripting tools
• Azure Storage
• Azure Data Lake
• Azure Databricks Lakehouse
• Azure Synapse
• Power BI
• Python
• SQL
• Azure Databricks
• Azure Data Factory
• Problem-solving
• Team player

Preferred

• Written and oral communication skills
• Interpersonal skills

Benefits

• $68.55/hr - $82.26/hr Inc.
• $54.84/hr - $65.81/hr T4