Analytics Engineer at TrialSpark

| Greater NYC Area
!Sorry, this job was removed at 12:13 p.m. (EST) on Tuesday, March 31, 2020
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

TrialSpark is a digital health company that accelerates the discovery of new treatments for patients by reimagining the clinical trial process.

Today, clinical trials are deeply inefficient. A single clinical trial can cost more than 100 million dollars and less than 10% of clinical trials are completed on time. Our mission is to bring treatments to patients faster by addressing these inefficiencies.

Job Description

As an Analytics Engineer, you'll be the chief steward of our analytical data infrastructure. An analyst at heart, you will build reliable data models, surface key company metrics, and develop tools that streamline data discovery and knowledge sharing. You'll work closely with our Platform engineers, data scientists and data analysts to create a data architecture that ensures the right information is available and accessible to all stakeholders throughout the organization.

At TrialSpark we pride ourselves on being data-driven and our decision making rests on our ability to leverage data in the best ways possible. As such, the Analytics Engineer plays a central role to how we make those decisions in as fast and reliable a way as possible. A good candidate will be able to balance the structure required to curate a highly robust and high fidelity data warehouse, while understanding that as a start-up, you need to be nimble, iterative and always looking to learn. In addition to running the day-to-day, you’ll be asked to look for ways to improve our processes as the business scales. 

Duties include, but are not limited to:

  • Build and maintain the analytics layer of our team’s data environment to make data standardized and easily accessible (we use dbt as our data transformation tool)
  • Maintaining and improving our Looker model to ensure that stakeholders can access the data they need in a clear and reliable way
  • Integrating third party data sources as we add marketing channels, data partners and other vendors
  • Working closely with Product and Engineering to ensure upstream product model changes integrate well with our data model; and when it doesn’t build the necessary capabilities to adjust
  • Supporting our CCD and OMOP model transformations
  • Managing user roles and permissions for Redshift and Looker
  • When needed, performing stakeholder related work, such as dashboards or analysis
  • Integrating and productionizing analyst and data science models as needed
  • Build data expertise, best practices and own data quality for all analytical data needs
  • Define and manage SLA for all data sets in allocated areas of ownership

Relevant Experience

  • 2-4 years of relevant analytical experience
  • BS/BA in a quantitative degree
  • Experience building analytical data models
  • Proficient in SQL
  • Proficient in LookML
  • Experience with Python
  • Experience with dbt a plus
  • Strong communicator; experience working with non-technical stakeholders a plus
  • You are passionate about our mission. You are excited about building the perfect team to bring medical treatments to patients faster.
  • You are organized, persistent and empathetic. You consistently follow-up on tasks and aren’t afraid to track down people to help solve problems.
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • JavascriptLanguages
    • PythonLanguages
    • ReactLibraries
    • ReduxLibraries
    • FlaskFrameworks
    • PostgreSQLDatabases


Our office is located in the Flatiron District of NYC, near Madison Square Park. The area is lively and has great food and transportation options!

An Insider's view of TrialSpark

What are some social events your company does?

We believe in healthy living! We organize regular team exercise classes as a company!

Frank Wu

Product Manager

How do you empower your team to be more creative?

We believe in presenting problems, not solutions, to the team. Our job is to align the team on company goals and issues, and allow the team to work creatively to solve them. We believe team autonomy fosters creativity and a healthier culture.

Linhao Zhang


What are TrialSpark Perks + Benefits

TrialSpark Benefits Overview

Trialspark 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!

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Retirement & Stock Options Benefits
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
We have a monthly transportation subsidy!
Company Outings
Yearly retreat and holiday party, regular team events and outings!
Free Daily Meals
We offer free lunch every day except Wednesday (when we encourage employees to leave the office and explore the area!)
Game Room
Super Smash Club every Friday!
Stocked Kitchen
Happy Hours
Pet Friendly
Come meet our office dog, Rosie!
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
More Jobs at TrialSpark9 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Project Mgmt
Data + Analytics
New York
Data + Analytics
New York
New York
Project Mgmt
New York
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView TrialSpark's full profileSee more TrialSpark jobs