Informatics Data Engineer — SSIS, Power BI & SQL

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

Job summary

CVS Health is seeking an Informatics Specialist to support reporting, data integration, and application processes. You will troubleshoot data workflows, deploy reports, and maintain team applications to meet evolving requirements.

You will collaborate with technical and business teams to ensure reliable data delivery and contribute to documentation and deployment standards across reporting.

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, scheduled jobs, and job failure troubleshooting.
• Programming experience with VB.NET and C#.
• Experience developing or supporting automated deployment processes for database objects such as stored procedures.
• Experience extracting, transforming, and loading data between production systems, vendor files, and internal databases.
• Experience supporting secure file transfer processes such as SFTP.

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, prepare files for SFTP to external locations, and load vendor data into team databases.
• 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

SQL Server expertise

SSIS development

Power BI

SSRS reporting

VB.NET / C# programming

GitHub / source control

Troubleshooting

Communication

Education

Bachelor's degree in Information Systems or Computer Science

Tools

SQL Server

SSIS

SSRS

Power BI

Visual Studio

GitHub

SFTP / secure file transfer

Job description

CVS Health is seeking an Informatics Specialist to support reporting, data integration, and application processes. You will troubleshoot data workflows, deploy reports, and maintain team applications to meet evolving requirements.

You will collaborate with technical and business teams to ensure reliable data delivery and contribute to documentation and deployment standards across reporting.