Software Development Engineer - Front Store

CVS Health is dedicated to building a more connected and compassionate health experience. The Software Development Engineer on the Retail Analytics team will design and build the data foundation for the analytics platform, focusing on Snowflake and ThoughtSpot integration while collaborating with cross-functional teams.

Responsibilities:

• 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:

• 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
• BA/BS degree required — Computer Science, Engineering, Mathematics, Information Systems, or related field
• Direct experience with ThoughtSpot — Worksheets, Liveboards, TML, and the ThoughtSpot 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