Senior Analytical Engineer: SQL and DBT #2760

GRAIL · Peninsula

Company

GRAIL

Location

Peninsula

Type

Full Time

Job Description

GRAIL is a healthcare company whose mission is to detect cancer early, when it can be cured. GRAIL is focused on alleviating the global burden of cancer by developing pioneering technology to detect and identify multiple deadly cancer types early. The company is using the power of next-generation sequencing, population-scale clinical studies, and state-of-the-art computer science and data science to enhance the scientific understanding of cancer biology, and to develop its multi-cancer early detection blood test. GRAIL is headquartered in Menlo Park, CA with locations in Washington, D.C., North Carolina, and the United Kingdom. GRAIL, LLC is a wholly-owned subsidiary of Illumina, Inc. (NASDAQ:ILMN). For more information, please visit www.grail.com.

GRAIL is seeking a Senior Analytical Engineer, supporting Commercial Operations. GRAIL’s Senior Analytical Engineer integrates data engineering and data analysis to curate and transform raw data to produce Business Intelligence (BI) ready datasets which will optimize our Commercial Sales Operations. This position is located in Menlo Park California, with onsite 2 days a week.

In this role you will build out data marts using DBT and SQL for new data sources coming into our data warehouse, in close partnership with our Data Platform team within Software Engineering. As GRAIL’s first Analytical Engineer, you’ll have an exciting opportunity to shape our best practices and workflows on data transformation, testing, and documentation, while working collaboratively with stakeholders across our Commercial Organization (Sales, Marketing, Customer Success, Customer Experience, Product) to understand the organization-wide needs for data collection, analysis, reporting, and application. GRAIL's successful Senior Analytical Engineer is someone comfortable supporting a commercial sales organization in performance analysis, who can think strategically but is also hands on with a proven track record building a data ecosystem that delivers compelling business value in a rapidly growing environment. 

You will:
Design, build, and maintain data models in DBT using SQL.
Collaborate with data analysts, data engineers, and business stakeholders to document data requirements for data marts.
Ensure data quality and integrity with testing.
Automate and scale common ad-hoc requests Lead on our best practices, workflows, and documentation.
Analysis data in Redshift.

We look to you to bring:
Expert level professional experiences in SQL and optimizing SQL queries from diverse sources towards creating performance or like analysis. 
5-8 years of direct analytical engineering or data engineering experience with a Bachelor’s Degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
Or, 2-5 years of direct analytical engineering or data engineering experience with a Master’s Degree (preferred) in Computer Science, Statistics, Informatics, Information Systems or another quantitative field. 
Additional professional experiences may be substituted for Degree. 
3+ years of experience with DBT or similar tools, including defined working experience with often complex data modeling principles, patterns, and industry trends.
In depth experience with relational databases, query authoring, and performance tuning.
Experience in designing and re-organizing facts and dimensions tables, complex data models and SCD’s. 
Python scripting experience is highly preferred.
SalesforceTools (Sales, Marketing, Service Cloud).Experience with implementing CI/CD processes.
Solid understanding of data warehouses like Snowflake or Redshift and BI tools like Tableau.
Demonstrated positive collaboration skills with key stakeholders and system users to deliver robust systems and compelling results.

Desired Experience:
AWS (Redshift, S3, Glue, Managed Airflow) Snowflake,Tableau.
Golang.
DevOps, such as CI/CD pipelines, containerized deployment, infrastructure as code, such as Terraform. 
Life sciences / Biotech sector experience in a regulated environment GxP, FDA, ISO 13485. 

The expected, full-time, annual base pay scale for this position is $124,000 to $168,00. Actual base pay will consider skills, experience, and location.

Based on the role, colleagues may be eligible to participate in an annual bonus plan tied to company and individual performance, or an incentive plan. We also offer a long-term incentive plan to align company and colleague success over time.

In addition, GRAIL offers a progressive benefit package, including flexible time-off, a 401k with a company match, and alongside our medical, dental, vision plans, carefully selected mindfulness offerings.

GRAIL is an Equal Employment Office and Affirmative Action Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability or any other legally protected status. We will reasonably accommodate all individuals with disabilities so that they can participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation. GRAIL maintains a drug-free workplace.

Apply Now

Date Posted

10/25/2023

Views

3

Back to Job Listings Add To Job List Company Profile View Company Reviews
Positive
Subjectivity Score: 0.9

Similar Jobs

Senior Staff Simulation Engineer - Wisk

Views in the last 30 days - 0

Wisk Aero is seeking a Senior Staff Simulation Engineer to join their Flight Physics Vehicle Modeling FPVM team The role involves designing implementi...

View Details

Senior Simulation Software Integration Engineer - Wisk

Views in the last 30 days - 0

Wisk is seeking a Senior Simulation Software Integration Engineer to lead the integration of highfidelity simulation models develop advanced test fram...

View Details

Support Engineer - Pricefx

Views in the last 30 days - 0

Pricefx a leading SaaS Pricing Price Optimization Management provider is seeking a Tier 34 Support Engineer The role involves providing technical sup...

View Details

Avionics Mechanical Engineer (Harness) - Reliable Robotics Corporation

Views in the last 30 days - 0

Reliable Robotics is seeking an Avionics Mechanical Engineer to join their Vehicle Design and Integration team in Mountain View California The role in...

View Details

Sr. Flight Software Engineer (Verification) - Reliable Robotics Corporation

Views in the last 30 days - 0

Reliable Robotics is a team of missiondriven engineers developing safetyenhancing technology for aviation aiming to make air transportation safer more...

View Details

Senior Product Manager - Instrumental

Views in the last 30 days - 0

Instrumental is seeking a Senior Product Manager with extensive experience in enterprise SaaS products or deep domain expertise in electronics manufac...

View Details