Data Engineer

| Greater NYC Area | Hybrid
Sorry, this job was removed at 12:15 p.m. (EST) on Thursday, January 27, 2022
Find out who's hiring in Greater NYC Area.
See all Data + Analytics jobs in Greater NYC Area
Easy Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

About TrialSpark

TrialSpark is a technology-driven drug development company that runs end-to-end clinical trials, focused on bringing new treatments to patients faster and more efficiently.

The biggest bottleneck in bringing new treatments to patients is the clinical trial. On average, getting a drug through the trial process takes nearly a decade and frequently costs $1B+. To combat this industry problem, TrialSpark has built a technology platform that optimizes all aspects of a clinical trial, enabling more efficient trial design, faster trial completion, and higher trial data quality.

TrialSpark recently raised their Series C, and is putting the capital to work by  in-licensing and co-developing drug programs through in-house development, joint ventures, and NewCos. Together with doctors, patients, and communities, TrialSpark is working to develop the treatments of tomorrow.

About the Position

As a Senior Data Engineer on our Data Platform Team, you will own TrialSpark’s data infrastructure. You will make key data architecture decisions and lead significant greenfield initiatives to implement the next generation of our data platform and pipelines. You’ll enable product and analytical teams with timely, high quality data from diverse sources including application databases, partner Electronic Health Record systems, and medical devices. You’ll become a domain expert in clinical data and its application to products and operations across the company. 

In this role you’ll collaborate with Product Engineers and our Infrastructure Team to build data transformations that unlock efficiencies in the clinical trial process, for example to ingest hundreds of millions of complicated health records, clean and structure this data for analytical and product use cases, and identify patients that will be served by previously inaccessible treatments. You’ll partner with the Analytics, Product, and Medical teams to set and achieve targets for data quality and latency, and build a learning feedback loop to move these needles over time. As a founding member of the Data Platform team, you will play a significant role in developing the team’s culture and strategy. Ultimately, you will leverage data to bring treatments to patients who may not have had access otherwise.

Responsibilities

  • Design and build data pipelines to clean and structure clinical data
  • Deploy tools to continuously monitor, test, and optimize data pipelines to ensure timely delivery and high data quality
  • Partner with Analytical stakeholders to assess the quality of our data and automate targeted improvements
  • Safeguard patient privacy and trial data integrity by Implementing data privacy and security, for example by implementing de-identification of Personally Identifiable Information
  • Partner with our Analytics team to maintain and evolve our modern data stack as necessary (Looker, Redshift, DBT, Stitch)
  • Help enforce best practices and promote testability and maintainability throughout our systems and codebase

Qualifications

  • At least one year of professional software development experience preferably in a data-oriented role (e.g. Data Engineer)
  • Professional experience building and maintaining data pipelines (e.g. Airflow, Prefect, Luigi, AWS Glue or Batch)
  • Fluency in SQL and at least one other programming language (Python preferred)
  • Experience with Unix, Docker, and cloud technologies
  • Strong problem solving and debugging skills
  • Strong written and verbal communication skills

Nice to have

  • Experience with infrastructure as code tools (e.g. Terraform, Ansible, Pulumi)
  • Experience performance tuning row-based (e.g. PostgreSQL) and columnar (e.g. Redshift) data stores
  • Experience working with healthcare data (Electronic Health Records, Insurance Claims, etc.)
  • B.S. in Computer Science or related field

You will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Read Full Job Description
Easy Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
  • Product
  • People Operations
    • JavascriptLanguages
    • PythonLanguages
    • ReactLibraries
    • ReduxLibraries
    • FlaskFrameworks
    • PostgreSQLDatabases
    • LookerAnalytics
    • FigmaDesign
    • MiroDesign
    • ConfluenceManagement
    • Google DriveManagement
    • Google DocsManagement
    • JIRAManagement
    • SlackCollaboration
    • ZoomCollaboration

Location

Our office is located in Manhattan, near the Empire State Building. The area is lively and has great food and transportation options!

An Insider's view of Formation Bio

What’s the vibe like in the office?

The space is very open which makes it easy to collaborate and engage with different teams across the organization. People are very welcoming, supportive, and friendly. There is always a variety of different food and drinks available in the kitchen, in addition to foods that co-workers bring in for everyone to taste!

Joseph Frappaolo

IT Support Technician

What projects are you most excited about?

The project that excites me most is our new hire onboarding program because of the impact it will have on our company. Though we have a robust onboarding program in place already, we have the opportunity to think creatively about how to make the experience even better for our new hires, from the moment they accept our offer.

Erin Siegel

Senior People Operations Manager

How has your career grown since starting at the company?

I started working at Formation Bio in July of 2018. I joined the company as a Clinical Research Coordinator and was allowed to grow and adapt into new roles as the company's business model shifted. I transitioned into working as a Clinical Trial Associate after a couple of years, and now have over a year of experience as a Clinical Project Manager!

Gurpreet Singh

Clinical Project Manager

How has your career grown since starting at the company?

Formation Bio has given me the opportunity to take ownership over big projects and work streams, allowing me to have an impact on key functional business areas.

Maya Dongier

Senior Accounting Manager

What are Formation Bio Perks + Benefits

Formation Bio Benefits Overview

Formation Bio is nothing without its employees, so they are well taken care of! We offer comprehensive benefits that span from insurance to 401ks, with added perks like a pet-friendly office. Come meet our office dog, Rosie!

Culture
Open door policy
Open office floor plan
Employee resource groups
Hybrid work model
Flexible work schedule
Diversity
Mandated unconscious bias training
Diversity employee resource groups
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental insurance
Vision insurance
Health insurance
Life insurance
Financial & Retirement
401(K)
Company equity
Pay transparency
Child Care & Parental Leave Benefits
Generous parental leave
Vacation & Time Off Benefits
Unlimited vacation policy
Paid holidays
Paid sick days
Office Perks
Company-sponsored outings
Yearly retreat and holiday party, regular team events and outings!
Free snacks and drinks
Company-sponsored happy hours
Fitness stipend
Home-office stipend for remote employees
Mother's room
Professional Development Benefits
Job training & conferences
Lunch and learns
Promote from within
Continuing education stipend
Virtual coaching services

More Jobs at Formation Bio

Easy Apply
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about Formation BioFind similar jobs like this