ETL Developer
Spectraforce
US
Remote
an hour ago
Job Description
Job Role: ETL Developer
Duration: 6+ Months
Location: Remote
Design, develop, and optimize SQL Server databases, tables, views, stored procedures, functions, and triggers.
Write efficient, scalable, and maintainable T SQL queries.
Build, enhance, and maintain SSIS packages for data extraction, transformation, and loading.
Implement error handling, logging, and performance tuning in ETL workflows.
Schedule and monitor ETL jobs using SQL Server Agent.
Develop interactive and paginated reports using SSRS.
Manage report subscriptions, security, and deployment.
Work with business users to gather reporting requirements.
Performance Optimization
Troubleshoot slow-running queries, ETL jobs, and reports.
Perform indexing strategies, query tuning, and database optimization.
Ensure data accuracy, consistency, and integrity across systems.
Support data validation, reconciliation, and documentation.
Work with cross-functional teams to understand data needs.
Provide production support for database, ETL, and reporting issues.
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 50.00/hr.
Duration: 6+ Months
Location: Remote
Design, develop, and optimize SQL Server databases, tables, views, stored procedures, functions, and triggers.
Write efficient, scalable, and maintainable T SQL queries.
Build, enhance, and maintain SSIS packages for data extraction, transformation, and loading.
Implement error handling, logging, and performance tuning in ETL workflows.
Schedule and monitor ETL jobs using SQL Server Agent.
Develop interactive and paginated reports using SSRS.
Manage report subscriptions, security, and deployment.
Work with business users to gather reporting requirements.
Performance Optimization
Troubleshoot slow-running queries, ETL jobs, and reports.
Perform indexing strategies, query tuning, and database optimization.
Ensure data accuracy, consistency, and integrity across systems.
Support data validation, reconciliation, and documentation.
Work with cross-functional teams to understand data needs.
Provide production support for database, ETL, and reporting issues.
Applicant Notices & Disclaimers
- For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 50.00/hr.