Healthcare ETL Engineer - SQL/SSIS & Data Pipelines

Ensure Data Solutions, LLC; United States; On-site; USD 85,000 - 120,000; Full time

Job summary

Ensure Data Solutions, LLC is seeking an ETL Developer with healthcare experience to design, implement, and optimize SQL-based ETL processes for a healthcare SaaS platform in a fast-growing company. The role emphasizes automation, data quality, and scalable data delivery to support decision-making.

The ideal candidate will work across departments, lead technical projects in an Agile/SCRUM environment, and maintain ETL workflows on MS SQL data warehouses, with hands-on SSIS, T-SQL, and data

Qualifications

• Minimum of 3 years relevant experience.
• Experience with Visual Studio, SSIS, Team Foundation.
• 3 years designing, implementing, testing, deploying, and maintaining ETL solutions using Microsoft SQL Server Integration Services (SSIS).
• Experience analyzing existing SQL queries and scripts for performance improvements.
• Understanding of SQL, relational, and analytical databases.
• Experience with enterprise databases, MS-SQL.
• Excellent interpersonal/communication skills with various levels of the organization.
• Detail-oriented with the ability to multitask and meet deadlines.

Responsibilities

• Implement and optimize Microsoft SQL-based ETL processes using SSIS packages and Stored Procedures to extract from a variety of sources, including API's, databases, and text files.
• Responsible for the design of ETL data feeds.
• Deploy and maintain ETL processes in a development environment.
• Perform code optimization and performance tuning of existing ETL processes.
• Generate ad-hoc reports for different users.
• Re-define ETL process validation, metadata maintenance, data integrity validation process, quality standards, and monitoring standards to ensure data quality.
• Provide accurate estimates of the effort required to complete assignments.
• Document technical designs with charts, diagrams, schemes, and descriptive software component documentation
• Research and advise on emerging technologies with respect to industry best practices, procedures, and concepts.
• Manage highly complex projects from start to finish using Agile/SCRUM development methodology and Team Foundation Server (TFS).
• Develop and assist Project Managers and Directors with the creation of task-level project plans that detail the specific tasks required to deliver a solution.
• Develop, test, and implement system changes and upgrades.

Skills

Visual Studio

SSIS

Team Foundation Server

SQL

ETL design

Data analysis

Agile/SCRUM

Reporting

Tools

Microsoft SQL Server

SSIS

Stored Procedures

Job description

Ensure Data Solutions, LLC is seeking an ETL Developer with healthcare experience to design, implement, and optimize SQL-based ETL processes for a healthcare SaaS platform in a fast-growing company. The role emphasizes automation, data quality, and scalable data delivery to support decision-making.

The ideal candidate will work across departments, lead technical projects in an Agile/SCRUM environment, and maintain ETL workflows on MS SQL data warehouses, with hands-on SSIS, T-SQL, and data