Staff Data Engineer, Observability Data Lake (ClickHouse)

Posted 12 Hours Ago
Be an Early Applicant
24 Locations
107K-213K Annually
Senior level
Fitness • Healthtech • Retail • Pharmaceutical
The Role
As a Staff Data Engineer, you will optimize SQL queries and manage structured and unstructured data in the observability data lake, leveraging ClickHouse for effective data storage and retrieval. You'll collaborate with the Technical Lead and data pipeline teams, ensuring performance, troubleshooting issues, and implementing best database management practices while staying updated on industry technologies.
Summary Generated by Built In

Bring your heart to CVS Health. Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand — with heart at its center — our purpose sends a personal message that how we deliver our services is just as important as what we deliver.
 
Our Heart At Work Behaviors™ support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable.

Description:

Bring your heart to CVS Health. Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand — with heart at its center — our purpose sends a personal message that how we deliver our services is just as important as what we deliver.

Our Heart At Work Behaviors™ support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient, and affordable.

Position Summary:

We are seeking a highly skilled Data and Database Engineer to join our Observability Data Lake team. This role is critical for optimizing the performance and efficiency of our observability data lake, which ingests and processes data at massive scale. As a Database Engineer, you will focus on the optimization of SQL queries and the management of both structured and unstructured data coming in and out of the lake. You will support the Technical Lead and the overall observability data lake team by ensuring high-speed data processing and retrieval, enabling actionable insights for observability use cases.

Key Responsibilities:

  • Optimize SQL queries to ensure high performance and efficiency in data processing and retrieval.
  • Manage and optimize the storage and retrieval of both structured and unstructured data within the observability data lake.
  • Collaborate with the Technical Lead and other team members to support the architecture, engineering, and optimization of the observability data lake.
  • Leverage ClickHouse for high-speed data storage and retrieval, ensuring seamless integration with data pipelines and visualization tools.
  • Work closely with the data pipeline team to ensure efficient data ingestion and correlation at scale using Vector.dev.
  • Implement best practices for database management, including indexing, partitioning, and query optimization.
  • Create and maintain documentation for database schemas, query optimization techniques, and data management processes.
  • Troubleshoot and resolve database-related issues, providing expert guidance and solutions to enhance performance.
  • Stay updated on the latest technologies and practices in database management and optimization, continuously seeking ways to improve operations and contribute to innovation within the team.
  • Participate in project meetings, providing technical oversight and contributing to the successful delivery of observability solutions.

Required Qualifications:

  • A minimum of 7 years of experience in database engineering, with a focus on SQL query optimization and data management.
  • Strong proficiency in SQL and experience with query optimization techniques.
  • Expertise in managing and optimizing both structured and unstructured data.
  • Experience with ClickHouse for high-speed data storage and retrieval.
  • Familiarity with data pipeline tools, particularly Vector.dev.
  • Strong analytical skills, with a focus on delivering actionable insights and improvements.
  • Excellent problem-solving skills and the ability to work collaboratively in a dynamic, fast-paced environment.
  • Strong communication and interpersonal skills, capable of working effectively with diverse teams.
  • Experience with modern development tools and practices, including version control, continuous integration/continuous deployment (CI/CD), and agile methodologies.

Education:

  • Bachelor’s degree from an accredited university or equivalent work experience (HS diploma + 4 years relevant experience).

Pay Range

The typical pay range for this role is:

$106,605.00 - $213,210.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 the base pay range listed above.  This position also includes an award target in the company’s equity award program. 
 
In addition to your compensation, enjoy the rewards of an organization that puts our heart into caring for our colleagues and our communities.  The Company offers a full range of medical, dental, and vision benefits.  Eligible employees may enroll in the Company’s 401(k) retirement savings plan, and an Employee Stock Purchase Plan is also available for eligible employees.  The Company provides a fully-paid term life insurance plan to eligible employees, and short-term and long term disability benefits. CVS Health also offers numerous well-being programs, education assistance, free development courses, a CVS store discount, and discount programs with participating partners.  As for time off, Company employees enjoy Paid Time Off (“PTO”) or vacation pay, as well as paid holidays throughout the calendar year. Number of paid holidays, sick time and other time off are provided consistent with relevant state law and Company policies. 
 
For more detailed information on available benefits, please visit Benefits | CVS Health

We anticipate the application window for this opening will close on: 03/07/2025

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.

Top Skills

SQL
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Woonsocket, RI
119,959 Employees
On-site Workplace
Year Founded: 1963

What We Do

CVS Health is the leading health solutions company that delivers care in ways no one else can. We reach people in more ways and improve the health of communities across America through our local presence, digital channels and our nearly 300,000 dedicated colleagues – including more than 40,000 physicians, pharmacists, nurses and nurse practitioners.

Wherever and whenever people need us, we help them with their health – whether that’s managing chronic diseases, staying compliant with their medications, or accessing affordable health and wellness services in the most convenient ways. We help people navigate the health care system – and their personal health care – by improving access, lowering costs and being a trusted partner for every meaningful moment of health. And we do it all with heart, each and every day.

Similar Jobs

WEX Inc. Logo WEX Inc.

Senior Data Engineer

Fintech • Payments
4 Locations
4900 Employees
117K-156K Annually

Ahold Delhaize USA Logo Ahold Delhaize USA

Commercial Analytics Co-op

AdTech • eCommerce • Food • Marketing Tech • Retail
Scarborough, ME, USA
10000 Employees

Ahold Delhaize USA Logo Ahold Delhaize USA

Commercial Reporting Analyst IV

AdTech • eCommerce • Food • Marketing Tech • Retail
Scarborough, ME, USA
10000 Employees

Ahold Delhaize USA Logo Ahold Delhaize USA

Senior Commercial Advanced Analytics Analyst

AdTech • eCommerce • Food • Marketing Tech • Retail
Scarborough, ME, USA
10000 Employees

Similar Companies Hiring

Zealthy Thumbnail
Telehealth • Social Impact • Pharmaceutical • Healthtech
New York City, NY
13 Employees
Cencora Thumbnail
Pharmaceutical • Logistics • Healthtech
Conshohocken, PA
46000 Employees
Stepful Thumbnail
Software • Healthtech • Edtech • Artificial Intelligence
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account