As a key member of the Pulse Engineering Team, you will combine deep experience managing complex operational data sets while contributing to the implementation of new product features in our flagship products"
Must-have
- Strong production ETL/ELT background — Python and PySpark
- Real comfort with semi-structured data: parsing and flattening nested JSON, exploding arrays, handling EAV / Question-Answer or survey-response style models, and the data-quality headaches that come with them.
- Solid SQL and relational modeling on MySQL
- Hands-on AWS Glue: job authoring, the Data Catalog, crawlers, bookmarks for incremental loads, triggers/workflows.
- Core AWS data stack around it: S3, IAM, Athena, and an orchestration story (Step Functions, EventBridge, or Glue workflows).
- Mapping discipline — source-to-target mapping documents, validation/reconciliation, idempotent and incremental loads.
Strong assets
- Healthcare data background: OMOP/OHDSI CDM specifically, plus exposure to other standards we publish to. Familiarity with clinical vocabularies (SNOMED CT, LOINC, ICD-10, RxNorm)
- Experience building configurable/declarative transformation pipelines (mapping rules as data) rather than bespoke scripts per customer.
- Regulated-environment experience — HIPAA, and 21 CFR Part 11 awareness
- Prior work with EAV, survey/forms platforms, or clinical registry data
Pay: $105,386.16-$134,917.75 per year
Benefits:
- Casual dress
- Dental care
- Flexible schedule
- On-site parking
- Paid time off
Work Location: Hybrid remote in London, ON N5X 4E7
