ETL Developer
Spectraforce
Norfolk, Virginia
Remote
an hour ago
Job Description
Job Role: ETL Developer
Duration: 6+ Months
Location: Remote
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.