Software Development Engineer - Front Store

Software Development Engineer

We're building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you'll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time.

As a Software Development Engineer on the Retail Analytics team, you will be primarily responsible for designing and building the data foundation that powers our analytics platform. This means owning the end-to-end data layer in Snowflake — fact tables, dimension tables, and aggregate metrics tables — and building the Thought Spot data models and TML (Thought Spot Modeling Language) that expose that data to business users.

You will also contribute to the React/Type Script front-end layer, embedding Thought Spot analytics experiences into our internal applications.

This is an individual contributor role with opportunity to grow technical scope and platform ownership over time.

• 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 Thought Spot 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 Thought Spot analytics experiences (live boards, search, visualizations) into internal applications using the Thought Spot Everywhere SDK with React and Type Script
• Build and maintain React/Type Script components that wrap and extend Thought Spot 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.

• 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 (Thought Spot, dbt, Looker, or equivalent)
• 1+ years of React and Type Script 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

• Direct experience with Thought Spot — Worksheets, Live boards, TML, and the Thought Spot Everywhere SDK
• Experience with Snowflake-specific features: clustering keys, materialized views, dynamic tables, and cost governance
• Familiarity with retail merchandising domain concepts (pricing, assortment, promotions, category management)
• Experience working in an agile/scrum environment

BA/BS degree required — Computer Science, Engineering, Mathematics, Information Systems, or related field

40

Full time

The typical pay range for this role is:

$86,520.00 - $

This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to…