Senior Data Engineer
Scipher Medicine is a precision immunology company that uses AI and network science to match patients with the most effective therapies. Its flagship product, PrismRA, is a blood-based test predicting whether a patient with RA will likely respond to anti-TNF therapy. Scipher Medicine is also developing the Spectra platform, which can be used to discover and validate new drug targets for various autoimmune diseases. The company has made significant progress quickly, with its PrismRA test already being used by clinicians in the US and Europe, and its Spectra platform has the potential to revolutionize drug development for autoimmune diseases.
Overview
We are seeking a skilled and autonomous Data Engineer to join our team. We are interested in candidates with experience designing, developing, and maintaining our data ingestion processes into Data Warehouses and other data pipelines. This is a full-time position based in our Waltham Ma, office. As a key member of our team, you'll be at the forefront of our data infrastructure transformation. Our dynamic environment and cutting-edge technology offer a unique chance to bring your innovative data pipeline concepts to life rapidly.
Role Requirements
Ability to translate business requirements, into effective data models in a data warehouse.
Autonomous learning. We’ll need folks who enjoy parsing large swaths of software documentation and gain sufficient prowess quickly to turn around and work on POCs that can be veritable candidates for production-ready processes/pipelines.
Advanced SQL skills, including schema design, CTEs, complex stored procedures, task etc. You’re familiar with standard data types but also variant types (json, xml). Extra points if you’re familiar with Snowflake-flavored syntax and features (stages, external functions, snowpipes, python UDFs, external tables, etc.).
Strong Python OOP We're seeking individuals well-versed in class utilization, inheritance, and functional programming. Live debugging and Python package creation should be second nature to you. Your code is clean, pythonic, and readable, and you appreciate a great formatter.
Understanding of HL7 messaging – used in EMR intergrations. Bonus points for javascript, MirthConnect, for Rhino javascript XML experience.
You’re great at creating and learning from internal documentation – we’re great at documenting. You understand that documentation (or playbooks as we call them) are living documents, not historical relics – and you update the playbook whenever an issue arises so we’re better prepared for next time.
Nice to have – in order of importance:
AWS Experience – Points if you can speak to expertise in SAM, Lambda, S3, boto3, API gateway, or anything else you see as obviously missing from this list and can explain to us why.
DevOps and CI/CD experience. Automating the process of promoting through dev/test/prod workflows. Extra points for Terraform experience.
Salesforce API v51+ - We do a lot of reverse ETL work with Salesforce.
Experience standing up an Orchestration Tool. We’ve got our eye on Prefect Orchestration.
Attention Search Firms/Third-Party Recruiters: Scipher Medicine is not seeking assistance or accepting unsolicited resumes from search firms for employment opportunities with Scipher Medicine. All resumes submitted by search firms to any Scipher Medicine employee via email, the Internet, or directly to hiring managers in any form without a valid written search agreement in place for a specific position will be deemed the sole property of Scipher Medicine, and no fee will be paid in the event Scipher Medicine hires a candidate as a result of the referral or through other means.
Scipher is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability status, protected veteran status, or any other characteristic protected by law
