Data Analyst, Business Intelligence

| Greater NYC Area | Hybrid
Sorry, this job was removed at 7:43 a.m. (EST) on Wednesday, June 16, 2021
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.

Background

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

The Data Analyst, Business Intelligence is responsible for building data and operational models as well as analyzing and reporting on metrics (KPIs, OKRs) that enable various TrialSpark teams to better understand business performance and to make better decisions. 

You should be able to demonstrate a willingness to work in a fast-paced and evolving environment  while balancing competing projects with time pressures. The ability to establish and maintain effective working relationships with cross functional stakeholders is key. You should have excellent written and verbal communication skills, technical experience with SQL, and an ability to create and manage complex operational models in Excel / Sheets.  

You will be the 3rd hire on TrialSpark's Business Intelligence team and will have a broad portfolio of projects and responsibilities. 

Responsibilities

Duties include but are not limited to: 

  • Partnering with operational stakeholders to create, define, analyze and report on business health via Key Performance Indicators (KPIs) and Objectives and Key Results (OKRs)
  • Providing analysis, insights and recommendations to Operations Leadership to inform business decisions that enable TrialSpark to operate faster and more efficiently 
  • Using our Business Intelligence dashboarding tool, Looker, to convey information to operational stakeholders, that is both useful and actionable. This includes building and automating as well as improving existing dashboards 
  • Building and refining elements of Salesforce and working closely with the Engineering, Product, Sales and Site Identification teams to create functionality that informs and improves our processes
  • Partnering closely with the other Analysts, Engineers and Product Managers to create and help scope projects that require deep technical model building
  • Tools that you’ll be working with include: Google Sheets / Microsoft Excel, Looker, Salesforce, dbt and SQL

Required education and experience

  • At least 3 years of analytical experience (data analyst, financial analyst, consulting, business strategy and operations). This is an open level role. Title will be commensurate with experience.
  • At least 2 years experience building and improving datasets and models using Google Sheets / Microsoft Excel and SQL  
  • At least 2 years experience with Business Intelligence Tools (Looker, Tableau)
  • Basic understanding of Salesforce. Bonus if you have experience as an administrator or managing a Salesforce administrator
  • Excellent communication, organizational and prioritization skills. Ability to manage multiple projects simultaneously 
  • Experience working with various cross functional stakeholders on tight and fluid timeliness 
  • Strong analytical mindset. You know that data should be leveraged to make the best business decisions possible
  • Ability to operate independently, identify and surface problems and devise solutions
  • You’re curious, empathetic, humble and act like an owner. You consistently follow-up on tasks and aren’t afraid to track down people to help solve problems 
  • Healthcare experience is a plus but not required
  • Experience with dbt or other transformation tools is a plus but not required

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