Senior Informatics & Data Integration Lead

CVS Health; Tennessee; Hybrid; USD 54,000 - 159,000; Full time

Job summary

CVS Health is hiring an Informatics Support Specialist to enhance reporting, data integration, and application processes. The role involves troubleshooting data workflows, deploying reports, and maintaining SSIS packages to support reliable operations.

You will collaborate with technical and business teams, work with SQL Server, SSIS, SSRS, and Power BI, and contribute to documentation and standards across reporting and deployment activities.

Qualifications

• 3+ years of experience in application support, database support, informatics, or a related technical role.
• Strong experience with Microsoft SQL Server.
• Hands-on experience with SSIS package development, support, and troubleshooting.
• Experience supporting and deploying SSRS reports and Power BI dashboards.
• Experience using Visual Studio for development and maintenance activities.
• Experience with GitHub or similar source control tools.
• Experience with enterprise scheduling tools and job failure troubleshooting.
• Programming experience with VB.NET and C#.
• Experience developing or supporting automated deployment processes for database objects.
• Experience extracting, transforming, and loading data between production systems and vendor files.

Responsibilities

• Investigate and troubleshoot issues related to SSRS reports, Power BI dashboards, SSIS packages, scheduled jobs, and related data processes.
• Deploy SSRS reports and Power BI reports in alignment with team standards and established deployment practices.
• Use automated processes to deploy stored procedures to team databases.
• Develop, maintain, and support SSIS packages that extract data from production databases and load vendor data.
• Support scheduled jobs and enterprise scheduling processes, including issue identification and resolution.
• Update and maintain team-developed applications as needed to support team processes and requirements.
• Partner with technical and business teams to gather requirements, resolve issues, and support solution delivery.
• Support ongoing reporting, database, and application reliability across the team's environment.
• Contribute to documentation, standards, and process consistency across reporting and deployment activities.

Skills

Root cause analysis

Troubleshooting

Verbal communication

Written communication

Cross-functional collaboration

Problem solving

Education

Bachelor's degree in Information Systems, Computer Science, Informatics, or related field

Tools

SQL Server

SSIS

SSRS

Power BI

Visual Studio

GitHub

Job description

CVS Health is hiring an Informatics Support Specialist to enhance reporting, data integration, and application processes. The role involves troubleshooting data workflows, deploying reports, and maintaining SSIS packages to support reliable operations.

You will collaborate with technical and business teams, work with SQL Server, SSIS, SSRS, and Power BI, and contribute to documentation and standards across reporting and deployment activities.