Data Engineer

Role

Data Engineer (SQL/ETL Migration & Infrastructure)

Location: Richmond, VA (Hybrid - Onsite Monday, Tuesday, Wednesday Preferred)

Duration: 4-6 Month Contract (Potential Extension)

We are seeking a highly skilled Data Engineer to support a large-scale migration initiative involving SQL Server, ETL processes, and Azure cloud technologies. This consultant will be responsible for both the development and migration of data workloads as well as the administration of the infrastructure supporting those workloads.

The ideal candidate will bring strong expertise in SQL Server, ETL technologies, SSIS/SSRS, and server administration , with the ability to install, configure, maintain, and optimize data platform components across multiple environments. This role will play a critical part in ensuring successful migration efforts while maintaining performance, security, and reliability.

We can provide a starting hourly rate between $45 and $60 depending on previous experience.

Top Hiring Manager Requirements

1. ETL Administration & Migration Experience
2. SQL Server with SSIS/SSRS Expertise
3. Server Management & Infrastructure Support

Key Responsibilities

• Design, develop, and support SQL Server-based data solutions and migration initiatives to Azure.
• Build, maintain, and optimize ETL processes and data pipelines.
• Install, configure, and administer ETL tools, software libraries, database drivers, and ODBC/JDBC connectors across servers and virtual machines.
• Manage SQL Server databases, including performance tuning, troubleshooting, and optimization.
• Develop, deploy, and support SSIS packages and ETL workflows.
• Design, administer, and maintain SSRS reports and reporting environments.
• Support migration of SQL Server, SSIS, and SSRS workloads to Azure-based platforms.
• Manage Python libraries, packages, and runtime environments while resolving version and dependency conflicts.
• Maintain secure, stable, and compliant data platform environments.
• Document infrastructure configurations, deployment processes, and operational procedures.
• Support CI/CD processes for data engineering workloads using GitHub Actions.
• Collaborate with infrastructure, cloud, and application teams to ensure successful project delivery.

Required Qualifications

• 7-10 years of experience in Data Engineering, Database Administration, or related fields.
• Strong hands-on expertise with SQL Server , including:
• T-SQL
• Stored Procedures
• Query Optimization
• Performance Tuning
• Extensive experience with:
• SSIS Package Development and Deployment
• SSRS Report Development and Administration
• Strong Python development experience.
• Proven experience administering ETL tools, software libraries, database drivers, and connectivity tools (ODBC/JDBC).
• Experience installing, configuring, and supporting applications on Windows Servers and Virtual Machines.
• Experience migrating data workloads and infrastructure to Microsoft Azure.
• Knowledge of source control and CI/CD practices, including GitHub Actions.
• Strong troubleshooting, documentation, and operational support skills.