200+ applicants

Company

Original Job Post

Scipher Medicine · 3 days ago

Senior Data Engineer

Waltham, MA

Full-time

Onsite

Senior Level

Wonder how qualified you are to the job?

Maximize your interview chances

Alternative MedicineBiotechnology

H1B Sponsorship

Insider Connection @Scipher Medicine

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Ability to translate business requirements into effective data models in a data warehouse.

Autonomous learning and quick adaptation to new software documentation for developing production-ready processes/pipelines.

Advanced SQL skills including schema design, CTEs, and complex stored procedures. Familiarity with Snowflake-flavored syntax is a plus.

Strong Python OOP skills with proficiency in class utilization, inheritance, and functional programming.

Understanding of HL7 messaging for EMR integrations. Familiarity with javascript, MirthConnect, and Rhino javascript XML is a bonus.

Creating and updating internal documentation to enhance operational efficiency.

Nice to have skills include AWS experience, DevOps and CI/CD experience, Salesforce API v51+, and experience with Orchestration Tools.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data modelingSqlSchema designCtesStored proceduresJsonXmlSnowflakePythonOopDebuggingPackage creationHl7 messagingJavascriptMirthconnectRhinoDocumentationAutonomous learningProblem-solvingAttention to detailAdaptabilityCommunicationAWSSAMLambdaS3Boto3API gatewayDevOpsCI/CD

Required

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 integrations. 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.

Preferred

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.

Company

Scipher Medicine

Scipher Medicine develops a healthcare platform designed to determine which drug will work best for each patient.

Founded in 2014

Waltham, Massachusetts, USA

51-200 employees

https://www.sciphermedicine.com

H1B Sponsorship

Scipher Medicine has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Trends of Total Sponsorships

2022 (8)