Software Development Engineer – Front Store

CVS Health

Software Development Engineer designing and building the data foundation for CVS Health's analytics platform. Collaborating with cross-functional teams to enhance consumer experience.

Posted 6/10/2026full-timeRemote • New York • 🇺🇸 United StatesMid-LevelSenior💰 $86,520 - $173,040 per yearWebsite

Tech Stack

Tools & technologies

AWSAzureCloudGoogle Cloud PlatformReactSQLTypeScript

About the role

Key responsibilities & impact

Design and build Snowflake fact, dimension, and aggregate metrics tables that support retail analytics use cases including pricing, assortment, promotions, and category management
Develop and maintain ThoughtSpot data models — Worksheets, Views, and TML definitions — to expose curated, governed data layers to business users
Write and optimize complex SQL in Snowflake including window functions, CTEs, incremental loading patterns, and query performance tuning
Define and enforce data modeling standards, naming conventions, metric definitions, and documentation practices across the analytics data layer
Integrate ThoughtSpot analytics experiences (liveboards, search, visualizations) into internal applications using the ThoughtSpot Everywhere SDK with React and TypeScript
Build and maintain React/TypeScript components that wrap and extend ThoughtSpot embedded experiences, connecting them to Snowflake-backed APIs and data models
Work closely with cross-functional teams, including PMs, Data Engineering, and business stakeholders, to identify business needs and translate them into requirements for solution improvements or ad hoc analyses in a fast-paced environment.

Requirements

What you’ll need

3+ years of hands-on software or data engineering experience
2+ years of SQL development — strong command of complex queries, joins, window functions, CTEs, and query optimization in a cloud data warehouse (Snowflake preferred)
Demonstrated experience designing dimensional data models — facts, dimensions, and aggregate/summary tables
Experience building or maintaining BI semantic layers, data models, or governed metrics definitions (ThoughtSpot, dbt, Looker, or equivalent)
1+ years of React and TypeScript development — able to build and maintain front-end components and integrate third-party SDKs
Experience with cloud-based platforms (Azure, GCP, or AWS)
Strong communication skills and ability to collaborate with analysts, product managers, and business stakeholders

Benefits

Comp & perks

medical, dental, and vision coverage
paid time off
retirement savings options
wellness programs
other resources, based on eligibility

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLSnowflakeReactTypeScriptdata modelingcomplex querieswindow functionsCTEsquery optimizationBI semantic layers

Soft Skills

communicationcollaboration