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.

The Retail Analytics team supports CVS Health's Front Store business by delivering data-driven business products that improve consumer experience and business performance. We are a cross-functional, agile team working at the forefront of analytics and AI/ML technology for key CVS Retail strategic priorities. Within our team, we believe a cutting-edge product can only be delivered if every aspect of the solution — from data to front-end UI — is fully designed and developed by SMEs within the team.

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