ETL Consultant – SQL Server – SSIS – SSRS

Job Summary

Lorven Technologies, Inc. is hiring an ETL Consultant – SQL Server – SSIS – SSRS for a remote, long‑term contract. This role offers a competitive annual salary of $104,106.16 and requires 13 years of experience in data integration and reporting.

Key Responsibilities

• Design, develop, and maintain ETL pipelines using SQL Server Integration Services (SSIS).
• Create and optimize reports and dashboards with SQL Server Reporting Services (SSRS).
• Perform data extraction, transformation, and loading across multiple source systems.
• Conduct performance tuning, troubleshooting, and root‑cause analysis for SQL Server environments.
• Provide production support, monitor job execution, and ensure data quality standards.
• Collaborate with business analysts and stakeholders to translate requirements into technical solutions.
• Document technical specifications, data flow diagrams, and operational procedures.

Required Qualifications

• Minimum 13 years of hands‑on experience with SQL Server, SSIS, and SSRS.
• Proven track record delivering end‑to‑end ETL solutions in complex, high‑volume environments.
• Strong SQL scripting and query optimization skills.
• Experience with version control, CI/CD pipelines, and automated testing for data workflows.
• Excellent problem‑solving abilities and attention to detail.
• Effective communication skills for remote collaboration.

Preferred Skills

• Knowledge of Azure Data Factory, Power BI, or other cloud‑based data services.
• Familiarity with Agile or DevOps methodologies.
• Certification in Microsoft SQL Server or related technologies.

Location & Employment Type

This is a fully remote contract position based in the United States.

Frequently Asked Questions

What technologies will I work with as an ETL Consultant?

You will primarily use Microsoft SQL Server, SSIS for data integration, and SSRS for reporting, with optional work on Azure Data Factory or Power BI.

Is this position fully remote?

Yes, the role is 100% remote and open to candidates located anywhere in the United States.

What is the contract duration and salary?

The contract is long‑term with a fixed annual salary of $104,106.16.