Remote ETL Developer (SSIS/SSRS) - Data Integration Expert

ESR Healthcare; United States; Hybrid; USD 73,012; Full time

Job summary

A healthcare technology company is seeking an ETL Developer to work remotely. In this role, you will develop and optimize SQL queries for complex data extraction and transformation across various systems. You'll collaborate with business analysts to translate requirements into technical specifications for ETL solutions and create SSRS reports. Strong SQL and ETL skills are essential, as well as the ability to work independently and meet deadlines. This position offers a competitive hourly rate of $53.

Qualifications

• Experience in developing and optimizing SQL queries for data manipulation.
• Strong ability to collaborate with analysts to gather technical requirements.
• Knowledge of data warehousing concepts and best practices.

Responsibilities

• Develop SQL queries for data extraction and transformation.
• Collaborate with stakeholders for technical specification gathering.
• Design and maintain ETL processes for data integration.

Skills

SQL

Data transformation

Communication skills

ETL processes

Self-starter attitude

Data warehousing

Tools

SSIS

SSRS

Visual Studio

Job description

ETL Developer / Data Integration Professional Remote
$53/hr

Job Description:
1. Develop and optimize complex SQL queries for data extraction, transformation, and loading across multiple systems and large datasets.
2. Perform data mapping and transformation between source and target systems to ensure accurate and consistent data flow.
3. Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications for ETL and reporting solutions.
4. Design, develop, and maintain ETL processes using Microsoft technologies including SSIS, SSRS, and Visual Studio to support data integration and reporting needs.
5. Demonstrate strong communication skills and a self-starter attitude, working independently and as part of a team to meet project deadlines and objectives.
6. Implement and maintain data warehousing solutions, applying best practices for architecture, modeling, and performance tuning
7. Create and maintain SSRS reports and dashboards, delivering actionable insights to business users.
8. Troubleshoot and resolve data integration issues, ensuring timely and accurate data delivery across systems.
9. Document ETL processes, data flows, and system configurations, maintaining clear and comprehensive technical documentation.