Data Engineer

Wize Solutions LLC

Abingdon (VA)

On-site

USD 70,000 - 90,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Wize Solutions LLC in Abingdon, VA is seeking a Backend-focused Data Engineer to build and optimize SQL Server-based data pipelines for a federal contracting client. You will tune stored procedures, develop ETL jobs, and support dimensional models to ensure reliable Power BI refreshes.

The role requires 3–5 years of SQL Server experience, strong T-SQL skills, and the ability to work with both technical and non-technical stakeholders on-site. Federal clearance is required.

Qualifications

  • 3 to 5 years of hands-on SQL Server development.
  • Federal security clearance capability: U.S. citizenship required to obtain and maintain clearance.
  • Strong T-SQL skills, including query tuning and execution plan work.
  • Experience building ETL processes using SSIS or similar tools.
  • Working knowledge of data warehousing and dimensional modeling.
  • Experience creating and managing SQL Server Agent jobs.
  • Understanding of how Power BI datasets connect to SQL Server, including Import vs DirectQuery, refresh behavior, and gateways.
  • Experience implementing data masking and handling sensitive data (including PII).
  • Clear communication with both technical and non-technical stakeholders.

Responsibilities

  • Develop and tune SQL Server databases, including stored procedures, views, and indexes.
  • Build and maintain ETL pipelines to move data from source systems into the warehouse.
  • Support and extend data warehouse models using fact and dimension tables.
  • Create and manage SQL Server Agent jobs, including schedules, alerts, and failure handling.
  • Design backend data so Power BI dataset refreshes (semantic models) are reliable and performant.
  • Coordinate with report developers to troubleshoot refresh failures, slow queries, and data issues tied to SQL.
  • Monitor and resolve performance issues across queries, jobs, and data loads.
  • Document data flows, job schedules, and data models.

Skills

SQL Server
T-SQL
query tuning
execution plan work
data masking
stakeholder communication

Tools

SQL Server Agent
ETL pipelines
SSIS
Power BI
Azure Data Factory
Azure SQL
Microsoft Fabric
Power Platform
RPA
C#/.NET

Job description

Backend-focused Data Engineer role in Abingdon, VA supporting a commercial client doing federal work.

Responsibilities
  • Develop and tune SQL Server databases, including stored procedures, views, and indexes
  • Build and maintain ETL pipelines to move data from source systems into the warehouse
  • Support and extend data warehouse models using fact and dimension tables
  • Create and manage SQL Server Agent jobs, including schedules, alerts, and failure handling
  • Design backend data so Power BI dataset refreshes (semantic models) are reliable and performant
  • Coordinate with report developers to troubleshoot refresh failures, slow queries, and data issues tied to SQL
  • Apply data masking to protect sensitive data in both production and non-production environments
  • Monitor and resolve performance issues across queries, jobs, and data loads
  • Document data flows, job schedules, and data models
Requirements
  • Federal security clearance capability: U.S. citizenship required to obtain and maintain clearance
  • 3 to 5 years of hands-on SQL Server development
  • Strong T-SQL skills, including query tuning and execution plan work
  • Experience building ETL processes using SSIS or similar tools
  • Working knowledge of data warehousing and dimensional modeling
  • Experience creating and managing SQL Server Agent jobs
  • Understanding of how Power BI datasets connect to SQL Server, including Import vs. DirectQuery, refresh behavior, and gateways, and what the backend must support
  • Experience implementing data masking and handling sensitive data (including PII)
  • Clear communication with both technical and non-technical stakeholders
Technologies
  • SQL Server, T-SQL
  • SQL Server Agent
  • ETL pipelines
  • SSIS
  • Power BI
  • Azure Data Factory, Azure SQL
  • Microsoft Fabric
  • Power Platform
  • RPA
  • C#/.NET
Clearance
  • Must be able to obtain and maintain a federal security clearance
Nice to Have
  • Active federal security clearance
  • Experience with Azure Data Factory, Azure SQL, or Microsoft Fabric
  • Experience on federal contracts or programs
  • Microsoft certifications such as DP-203, DP-600, or similar
Job Details
  • Location: Abingdon, VA 24210 (onsite)
  • Salary: USD 70,000 - 90,000 per year
  • Minimum Experience: 3 years
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Robotics Technologies • Columbia Township (MO)

On-site
USD 95,000 - 135,000
Data Engineer: SQL Server, ETL, Power BI (Onsite VA)
Data Engineer: SQL Server, ETL, Power BI (Onsite VA)

Wize Solutions LLC • Abingdon (VA)

On-site
USD 70,000 - 90,000
Data Engineer
Data Engineer

Northbound Executive Search • Austin (TX)

On-site
USD 80,000 - 120,000
Data Engineer
Data Engineer

Jack • United States

On-site
USD 70,000 - 90,000
Competitive medical, dental, and vision plans
Company-paid life, AD&D, and disability insurance
401(k) with company match
+3
Data Engineer 3 - TS clearance required
Data Engineer 3 - TS clearance required

Bow Wave LLC • Arlington (VA)

On-site
USD 81,000 - 99,000
Senior Data Engineer
Senior Data Engineer

Node.Digital LLC • Herndon (VA)

Remote
USD 120,000 - 160,000
Medical
Dental
Vision
+6
Data Engineer (w/ active Secret)
Data Engineer (w/ active Secret)

CriticalSolutions, LLC • Norfolk (VA)

On-site
USD 87,000 - 112,000
Premium medical/dental/vision
401K matching
Flexible PTO
Data Engineer
Data Engineer

Sotalent • McLean (VA)

On-site
USD 102,000 - 170,000
Health, dental, and vision insurance
401(k) with company matching
Tuition reimbursement
+2
Senior Data Engineer
Senior Data Engineer

RelMap Consulting • United States

Remote
USD 96,000 - 110,000
Data Engineer
Data Engineer

Compunnel Inc. • Norfolk (VA)

On-site
USD 110,000 - 150,000