Manager, Business Analysis

At CVS Health, we're building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.As the nation's leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues - caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day.Key Responsibilities:

• Healthcare Industry Knowledge: Ensure compliance with healthcare standards and regulations, such as HIPAA.including FHIR standards.

• Data Migration and Management: Implement strategies to ensure data accuracy, quality, and compliance with industry regulations.
• Customization: Understand business needs and convert to technical specs.

Core Responsibilities: -

• IIB: Experience in designing and developing enterprise application using IBM ACE (App Connect Enterprise), IBM MQ, IBM DB2, knowledge of Sterling file gateway.

• Experience in writing ESQL to handle message writing and transformation. Experience in integrating IIB with WTX (WebSphere Transformation Extender), processing XML messages and files.

• Writing scripts using Python and BASH

• Incident Management: Quickly respond to any failures or issues in the database and ETL processes, providing resolution within SLA.

• Troubleshoot Errors: Diagnose ETL errors or database failures, analyze logs, and apply fixes, as necessary.

• Data Quality Assurance: Monitor the data pipeline to ensure accuracy, completeness, and timeliness of ingested data.

• Data Validation: Check the quality and integrity of data in the production environment based on reported issue(s). Escalate data discrepancies or quality issues found during monitoring or user reports.

• Data Reconciliation: Assist in the reconciliation of data discrepancies and support the correction of data in case of ETL or database failures.

• Business Requirements: Ensure that the business requirements for data ingestion and quality are consistently met in the production pipeline.

• Root Cause Analysis (RCA): Provide detailed RCA reports for incidents, documenting steps taken for resolution and preventive measures.

• Job Scheduling: Maintain and update ETL job schedules using tools like Apache, SSIS.

• Performance Tuning: Perform routine optimization of ETL jobs and database queries to maintain optimal performance.

• Documentation: Maintain detailed runbooks and operational documentation to support troubleshooting and knowledge sharing.

• Collaboration with Development Teams: Work closely with development teams to deploy changes to ETL pipelines and databases with minimal disruption.Skills Requirements: -

• Integration Platform: IBM ACE, IBM MQ
  • Knowledge of Framework, Spring boot
  • IBM APIC, Kong
• Database Technologies:

• MS SQL Server, DB2, MySQL

• Query optimization.

• Monitoring Tools:

• Splunk

• Custom SQL scripts for proactive monitoring

• DevOps:

• Jenkins, GitHub actionsCommunication Tools: ServiceNow for incident and change management, Anticipated Weekly Hours
40Time Type
Full timePay Range

The typical pay range for this role is:$54,300.00 - $159,120.00This 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.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 peopleWe take pride in our comprehensive and competitive mix of pay and benefits - investing in the physical, emotional and financial wellness of our colleagues and their families to help them be the healthiest they can be. In addition to our competitive wages, our great benefits include:

• Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.
• No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching.
• Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility.

For more information, visit https://jobs.cvshealth.com/us/en/benefitsWe anticipate the application window for this opening will close on: 08/29/2025Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.

Client-provided location(s): Raleigh, NC

Job ID: CVS-R0681374_1005

Employment Type: OTHER

Posted: 2025-08-30T19:43:47