Woonsocket, Rhode Island

Job Description
You love telling stories with data and creating actionable insights. You enjoy working on difficult problems and thrive in data driven organizations. Come join CVS’s Retail Media Network (CMX) part of Fortune 4, CVS Health.

We are building a world class team at CMX with the goal to make a significant impact on the company’s already rapid growth. We want to make sure we are both innovative and rigorous as we build out our Business intelligence team to lead CMX data strategy, reporting and self-service dashboards initiatives.

As the Senior Consultant BI Analyst, you play a critical role in managing CMX BI initiatives through advanced reporting. You will acquire and combine data from multiple online data sources to manage our analytics reporting and custom analysis. Our BI products and services serve both internal and external/client stakeholders with the goal of driving incremental revenue growth through data-driven optimizations.

The Senior Consultant BI analyst also works closely with Marketing strategy, media, partner management to provide data-driven insights and new solutions. You innovate and thrive in an analytical and creative environment where collaboration, client service, and new analytics development initiatives are leveraged in a data-driven approach to our product & service offerings

The ideal candidate must have a deep knowledge in gathering business requirements and building ETL jobs within a retail media context. Experience within the digital media, e-commerce, retail or Consumer Packaged Goods is A MUST.


• Design, develop and deploy BI solutions, including sourcing data from digital platforms (DV360, TTD, GAM, CM, FB, Pinterest, YouTube, Twitter and CTV) to data lake and developing semantic layer in GCP platform
• Build and maintain an understanding of data flows, sources, and data transformations across multiple domains
• Determine if data integration is needed, identify data sources, and work with enterprise IT to build a solution to meet business partners’ expectations
• Proactively identify data quality issues and collaborate with other subject matter experts to identify solutions
• Responsible for design, setup and support of data governance and data integration processes using ETL tools
• Work closely with business partners in gathering detailed business requirements, establishing business definitions, and translating business requirements to technical solutions

Required Qualifications
• 2+ years of relevant professional experience in business intelligence, data engineering, or related field
• Experience in database design, data modeling and ETL process within different cloud environment platforms (i.e. GCP, Azure, AWS, Snowflake, Databricks)
• Proficiency interacting with various database and file storage systems (Examples: Oracle, Hadoop, NoSQL).
• Excellent working knowledge of large data manipulation using complex SQL across digital media platforms (i.e. DV360, TTD, GAM, FB, Instagram, Twitter, Pinterest, CTV, YouTube)
• Excellent knowledge in Python, Databricks, Spark, GCP and Tableau
• Experience gathering and aligning business requirements across stakeholders in the digital world

COVID Requirements
COVID-19 Vaccination Requirement
CVS Health requires its Colleagues in certain positions to be fully vaccinated against COVID-19 (including any booster shots if required), where allowable under the law, unless they are approved for a reasonable accommodation based on disability, medical condition, pregnancy, or religious belief that prevents them from being vaccinated.
  • If you are vaccinated, you are required to have received at least one COVID-19 shot prior to your first day of employment and to provide proof of your vaccination status within the first 30 days of your employment. For the two COVID-19 shot regimen, you will be required to provide proof of your second COVID-19 shot within the first 60 days of your employment. Failure to provide timely proof of your COVID-19 vaccination status will result in the termination of your employment with CVS Health.
  • If you are unable to be fully vaccinated due to disability, medical condition, pregnancy, or religious belief, you will be required to apply for a reasonable accommodation within the first 30 days of your employment in order to remain employed with CVS Health. As a part of this process, you will be required to provide information or documentation about the reason you cannot be vaccinated. If your request for an accommodation is not approved, then your employment may be terminated.

Preferred Qualifications
• Experience in software development languages such as python
• Experience in designing and implementing custom reporting systems by managing or guiding technical teams with tools such as Tableau
• Knowledge and experience in identity resolution and digital data connectivity platforms (ie. Liveramp, Acxiom, Experian, Throttle)
• Understanding of the digital media landscape with a focus on retail media networks

Bachelor's degree in engineering, business analytics or equivalent experience

Business Overview
At CVS Health, we are joined in a common purpose: helping people on their path to better health. We are working to transform health care through innovations that make quality care more accessible, easier to use, less expensive and patient-focused. Working together and organizing around the individual, we are pioneering a new approach to total health that puts people at the heart.

We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion based on race, ethnicity, sex/gender, sexual orientation, gender identity or expression, age, disability or protected veteran status or on any other basis or characteristic prohibited by applicable federal, state, or local law. We proudly support and encourage people with military experience (active, veterans, reservists and National Guard) as well as military spouses to apply for CVS Health job opportunities. See Job Description

Woonsocket, Rhode Island

Continue serving and work with a purpose

As a CVS Health colleague, you'll find career opportunities across the organization and at every stage of your career. More important, your work will have an impactful purpose on someone's life, including your own. Learn more about how you can continue serving on your next mission at CVS Health.

Careers for Veterans and Military Spouses


"The military has an ethos that is grounded in purpose-driven service that’s bigger than the individual. The same holds true for us at CVS Health. You can talk to colleagues in any part of our business and they will be able to articulate our company’s purpose. Working here provides an opportunity for service members and military spouses to continue to serve, just in a civvies."

Similar jobs