Technical Business Analyst, Investment Systems

CVS Health; Hartford (CT); Hybrid; USD 83,000 - 183,000; Full time

Benefits offered by this job

Comprehensive benefits

Bonus eligibility

Equity program

Job summary

CVS Health is hiring a Technical Business Analyst for Investment Systems to modernize investment data and reporting. Hybrid work in Hartford, CT with a focus on analyzing, documenting, and improving critical data flows and processes while migrating the data warehouse to Google Cloud.

You will translate complex business and technical requirements into clear documentation, support data governance, and enable AI-enabled analytics in a high-visibility environment.

Qualifications

• Bachelor's degree or equivalent in IS, CS, Business, Finance, or related field.
• 5+ years in business analysis, data warehousing, reporting, analytics, or related areas.
• SQL skills with complex queries, stored procedures, and data transformations.
• Experience documenting processes, requirements, and technical specs.
• Knowledge of ETL/ELT, data governance, and data quality.

Responsibilities

• Gather, analyze, and document business requirements, processes, and data flows.
• Document and validate business rules, calculations, and reporting logic.
• Create data dictionaries, source-to-target mappings, and data lineage artifacts.
• Support data warehouse modernization and migration to Google Cloud Platform/BigQuery.
• Collaborate with engineering to improve data quality, governance, and reporting.
• Facilitate requirements workshops, interviews, testing, and data validation.
• Help establish foundation for AI-enabled data solutions.

Skills

SQL skills

Data warehousing

Communication

Cross‑functional collaboration

Independent work

Education

Bachelor's degree

Master's degree preferred

Tools

SQL Server

Oracle

Oracle SQR

Job description

Technical Business Analyst, Investment Systems

Hybrid - Hartford, Connecticut, United States

Sep 18, 2026

$82,940 - $182,549/year

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 ourselvesaccountable 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.

About the Role

CVS Health is seeking a Technical Business Analyst, Investment Systems to support the modernization of our investment data and reporting ecosystem. This role will work closely with Investment Management, Pension, Accounting, Operations, and Technology teams to analyze, document, and improve critical business processes, data flows, and reporting solutions.

You will play a key role in capturing institutional knowledge, translating complex business and technical requirements into clear documentation, and helping drive the migration of our investment data warehouse to Google Cloud Platform. This position offers a unique opportunity to combine business analysis, data management, cloud transformation, and emerging AI capabilities in a highly visible environment.

Key Responsibilities

• Partner with business and technology stakeholders to gather, analyze, and document business requirements, processes, and data flows.
• Document and validate business rules, calculations, reporting logic, and system dependencies across investment platforms.
• Create and maintain process documentation, data dictionaries, source-to-target mappings, and data lineage artifacts.
• Support data warehouse modernization initiatives, including migration to Google Cloud Platform and BigQuery.
• Collaborate with engineering teams to improve data quality, governance, metadata, and reporting capabilities.
• Facilitate requirements workshops, stakeholder interviews, testing, and data validation activities.
• Help establish the foundation for advanced analytics and AI-enabled data solutions.

Required Qualifications

• Bachelor's degree or equivalent experience in Information Systems, Computer Science, Business, Finance, or a related field.
• 5+ years of experience in business analysis, data warehousing, reporting, analytics, or related disciplines.
• SQL skills with experience analyzing complex queries, stored procedures, and data transformations.
• Proven experience documenting business processes, requirements, and technical specifications.
• Knowledge of data warehousing, ETL/ELT processes, data governance, and data quality practices.
• Strong communication, facilitation, and problem-solving skills.
• Proven experience working independently and collaborate effectively across multiple teams.
• Ability to be onsite in Harford 2+ times a week.

Preferred Qualifications

• Experience in Investment Management, Pension, Asset Management, Banking, Insurance, or other financial services environments.
• Familiarity with investment data including holdings, transactions, performance, accounting, benchmarks, and security master data.
• Experience with SQL Server, Oracle, Oracle SQR, or legacy reporting platforms.
• Experience supporting cloud migrations, particularly within Google Cloud Platform and BigQuery.
• Exposure to metadata management, data catalogs, semantic models, or AI-driven analytics solutions.

Preferred Technical Skills

• SQL Server, Oracle, BigQuery
• Python
• Looker and analytics platforms

Education

Bachelor's degree required.
Master's degree preferred.

Role is hybrid out of Hartford and does not provide sponsorship at this time.

Pay Range

The typical pay range for this role is:

$82,940.00 - $182,549.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.

Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.

Great benefits for great people

We take pride in offering a comprehensive and competitive mix of pay and benefits that reflects our commitment to our colleagues and their families.

This full‑time position is eligible for a comprehensive benefits package designed to support the physical, emotional, and financial well‑being of colleagues and their families. The benefits for this position include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources, based on eligibility.

Additional details about available benefits are provided during the application process and on Benefits Moments .

We anticipate the application window for this opening will close on: 10/26/2026

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

CVS Health

Simplifying health care one person, one family and one community at a time

CVS Health is a leading health solutions company enhancing community well‑being through accessible care, digital innovation, and a dedicated workforce of over 300,000 professionals.

Grant - Michigan Economic Development Corporation$1.5M

Jul 2025

Post IPO Equity - Starboard Value

Footprint

Where they work

1 CVS Drive, Woonsocket, RI 02895, US 9501 E. Shea Blvd, Scottsdale, AZ 85260, US 2211 Sanders Road, Northbrook, IL 60062, US 750 West John Carpenter Freeway, Ste 1200, Irving, TX 75039, US 620 Epsilon Dr, Pittsburgh, PA 15238, US 2211 Sanders Rd, Northbrook, IL 60062, US