Note: Hybrid 3 times per month candidate must be physically located in Ontario

Public Sector Experience: Preferred Healthcare preferred

Must Haves:

• 3+ years' experience with IICS (Informatica Intelligent Cloud Services)
• 3+ years' experience with Azure ecosystem
• 3+ years' experience with SQL Server
• 3+ years' experience with Linux/Unix
• 3+ years' experience with Programming Languages (Python, BASH, PowerShell)

Description

Background Information

• The objective of this engagement is to procure a Senior Software Developer ETL (Extract, Transform, Load) Contingent Resource to support the Ontario Cancer Registry (OCR) Enhancement Project, aimed at improving cancer registry workflows, data collection, and data management through automation and expanded data access. The selected resource will work collaboratively with Ontario Health's teams in Digital Excellence in Health, Data & Decision Sciences, and the Privacy and Legal Office.

Project Scope & Key Responsibilities

• The Senior ETL Developer will contribute to the following key project objectives:
• Enhancing eMaRC (Electronic Mapping, Reporting, and Coding Plus)
• Developing a Natural Language Processing (NLP) add-on module to improve processing of pathology reports, specimen collation, and biomarker templates.
• Reducing manual efforts for cancer registrars, thereby accelerating disclosure of case information.
• Optimizing OCR IT Logic and Data Extraction
• Redesigning data ingestion processes to enhance the way cancer case information is captured and managed.
• Exploring new data elements from Discharge Abstract Database (DAD) and National Ambulatory Care Reporting System (NACRS) to improve case linkage.
• Automating Cancer Stage Abstracting
• Applying NLP-driven rule-based logic to extract stage data elements directly from eMaRC pathology reports.
• Automating uploads into RegistryPlus WebPlus staging abstract, reducing manual abstraction workload.
• Expanding Access to Cancer-Related Data Sources
• Facilitating broader access to Electronic Health Record (EHR) data to improve case identification and data completeness.
• Collaborating with Ontario Health data teams to integrate diagnostic imaging data into the OCR 6.

Responsibilities:

• Provide guidance, expertise, and mentoring to discuss specific engineering practices and problems that may arise during day-to-day work.
• Provide context and perspective regarding engineering design decisions as well as business requirements that influence implementation details.
• Ensure a consistent approach to executing work assignments in a timely and competent manner.
• Accountable for workload, tasks and initiatives and for service quality within assigned work and within direct scope of operations.
• Recommend changes across the team's engineering practices as well as external team practices to improve the team's cycle time as well as lead time for the team's product backlog.
• Collaborate with Quality Assurance, DBAs and Release management teams for implementation.
• Stay abreast of evolving technology, architecture, and design, patterns, practices, and platforms.
• Make decisions where results have major impact across the organization requiring sophisticated solutions and long-term correction.
• Provide updates on tasks via discussions and status reports.
• Identify risks and escalate to project leadership on a timely basis.
• Maintain up-to-date knowledge of emerging tools, including investigation and guidance with new/emerging technologies (POCs), and applying them to data engineering solutions as appropriate.
• Responsible for creating detailed technical documentation for end users.

Desired Skills:

• Knowledge of Data structures (XML, JSON, etc)

Required Skills:

• In-depth knowledge of software development and software development Life Cycle (SDLC).
• Strong knowledge of agile development practices.
• In-depth knowledge of data models, data mining, and segmentation techniques.
• Strong knowledge of relevant programming languages (Python, Java, bash, PowerShell, etc.).
• Strong knowledge of relevant data query languages (SQL, KQL, etc.).
• In-depth knowledge of relevant data manipulation techniques.
• Strong knowledge of data analytics techniques.
• In-depth knowledge of database design using relational, document, object, big data, tabular, and other platform types.
• Strong operational knowledge of relevant data platforms in on-premises environments and cloud platforms.
• Excellent knowledge of best practices related to product deployment, operations, and support of databases and pipelines.
• Excellent knowledge of data security and data protection mechanisms.
• Strong knowledge and understanding of data management authorities and legislation relevant to health care in Ontario.

Required Experience / Evaluation Criteria: 100 Points (70% of scoring)

• 1) 4-6 years of Experience using Informatica Intelligent Cloud Services (IICS), Big Data Management.: 60 Points
• 2) 4-6 years of Experience in designing, developing and implementing data solutions in Cloud, preferably Microsoft Azure: Synapse, Databricks, including storage in Azure Data Lake (Gen 2).: 25 Points
• 3) 5+ years of Experience in Windows PowerShell and Unix/Linux Bash shell scripting.: 15 Points

Deliverables

• Leads change processes for the adoption of new engineering practices.
• Independently engages and actively participates in team discussion with product management teams to recommend product features and changes to product features to improve the user experience, operation and maintainability of the product.
• Works with a high level of autonomy within a defined project/solution/system scope based on direction from Lead Engineers, Architects, and Product Managers.
• Participates in the development of engineering plans and systems specifications with Lead Engineers.
• Ensures alignment of practices, patterns and solutions.
• Ensures work aligns to broader roadmaps and systems strategies.

Additional Terms

• Term: 1 position for 126 business days, with an option at Ontario Health's discretion to extend for an additional 125 business days.
• Ontario Health assets including laptops and related equipment cannot be removed from the province of Ontario without prior written approval from Ontario Health.
• Assignment Type: This position is currently listed as "Hybrid". The resource under this request will be required to work onsite as per Hiring Manager sole discretion. All work must be conducted in Canada unless otherwise agreed to by Ontario Health.

Knowledge Transfer Details:

• The candidate will ensure full knowledge transfer is provided to the Ontario Health team before end of engagement.
• The candidate must provide installation, design, development, and migration related documentation as part of knowledge transfer.
• All code, configuration, and documentation built by the candidate as part of this engagement is considered Ontario Health material.
• The candidate must complete all knowledge transfer at the latest two weeks before the end of the contract and it must be signed off by the Ontario Health Hiring Manager.