DeveloperJobs.io
← Back to all jobs
Wize Solutions LLC

Data Engineer

Wize Solutions LLC
Abingdon, VA $70k - $90k/yr Full time Posted 2d ago
Backend Developer Analytics Automation Developer Azure Azure Data Engineer Azure Data Factory Azure Data Platform Azure Platform Azure Sql Business Analytics Business Intelligence Cloud Data Engineering Cloud Data Platform Cloud Engineer Cloud Platform Cloud Platforms Cloud Platforms Cloud Platforms Data Data Analysis Data Analytics Data Analytics Tools Data Architecture Data Engineer Data Engineering Data Factory Data Factory Azure Data Integration Data Integration Tools Data Pipeline Data Platform Data Processing Data Visualization Data Warehouse Database Databases Digital Marketing Engineer ETL Hr Technology Informatica Information Technology (IT) Microsoft Microsoft Azure Microsoft Fabric Microsoft Office Microsoft Power Platform Power BI Power Platform Reporting and Analytics Software Development SQL Sql Server Integration Services Visual Design
Apply Now

Job Description

Wize Solutions LLC is seeking a backend-focused Data Engineer to support a commercial client engaged in federal work. Based onsite in Abingdon, VA 24210, this role centers on building reliable SQL Server ETL pipelines and data warehouse workloads that feed downstream reporting, including Power BI dataset refresh performance and secure handling of sensitive data.

The position is ideal for someone with strong hands-on SQL Server development experience and a clear understanding of how Power BI semantic models rely on the SQL backend. You will tune database objects, manage scheduled SQL Server jobs, and troubleshoot data load and query performance issues that impact reporting outcomes.

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 data warehouse
  • Support and extend data warehouse models, including fact and dimension tables
  • Create and manage SQL Server Agent jobs, schedules, alerts, and failure handling
  • Structure backend data so Power BI datasets refresh reliably and perform well
  • Collaborate with report developers to troubleshoot refresh failures, slow queries, and data issues traced 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

  • U.S. citizenship required; ability to obtain and maintain a federal security clearance
  • 3 to 5 years of hands-on SQL Server development
  • Strong T-SQL skills, including query tuning and execution plans
  • Experience building ETL processes (including SSIS or similar tools)
  • Working knowledge of data warehousing concepts and dimensional modeling
  • Experience creating and managing SQL Server Agent jobs
  • Understanding of how Power BI datasets connect to SQL Server (Import vs. DirectQuery, refreshes, gateways) and what the backend must support
  • Experience with data masking and handling sensitive data (PII)
  • Clear communication with 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

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 or DP-600 (or similar)

Salary: USD 70,000 - 90,000 per year. Experience level: 3+ years. This onsite role supports federal work for a commercial client, with a backend focus on SQL Server ETL, data warehouse objects, and the SQL performance needed to keep Power BI dataset refreshes stable.

Similar Jobs