Analytics Engineer

| Greater NYC Area
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
About TrialSpark

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+. And the problem is only getting worse.

TrialSpark is a new healthcare company that owns the end-to-end drug development process. Our proprietary technology allows us to integrate and improve clinical research for patients, providers, and sponsors, while executing clinical trials faster and cheaper.
Job Description 

As an Analytics Engineer, you’ll be the chief steward of our analytical data infrastructure. You will model complex data, build and integrate reliable data pipelines, surface essential company metrics, and develop tools that streamline data discovery and knowledge sharing. You’ll sit on TrialSpark’s Platform Team and work closely with Data Analysts, Platform Engineers, Product Engineers, and key cross-functional stakeholders to create a data architecture that ensures the right information is available and accessible to all stakeholders throughout the organization.

Responsibilities  
  • Building and maintaining the analytics layer of our team’s data environment to make data standardized and easily accessible
  • Maintaining and performance tuning our Redshift cluster and any expensive queries
  • 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 and schema changes integrate well with our data model; and when it doesn’t build the necessary capabilities to adjust
  • Supporting health data model transformations (For example, CCD to OMOP)
  • Administering Redshift and Looker
  • When needed, performing stakeholder related work, such as dashboards or analysis
  • Integrating and productionizing analyst and data science models as needed
  • Building data expertise and best practices across the team
  • Owning end-to-end data quality for all analytical needs
  • Defining and managing SLAs 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 is 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.

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

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

CTO

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
401(K)
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!
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 TrialSpark16 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Operations
HR + Recruiting
new
New York
Design + UX
new
New York
Data + Analytics
new
New York
Finance
new
New York
Finance
new
New York
Developer
new
New York
Developer
new
New York
Design + UX
new
New York
Developer
new
New York
Data + Analytics
new
New York
Operations
new
New York
HR + Recruiting
new
New York
Operations
new
New York
Developer
new
New York
Design + UX
new
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