EngineerJobs.io
← Back to all jobs
Wize Solutions LLC

Data Engineer

Wize Solutions LLC
Abingdon, VA $70k - $90k/yr Full time Posted 1d 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 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

This backend-focused Data Engineer role at Wize Solutions LLC supports a commercial client engaged in federal work. The position is based onsite in Abingdon, VA 24210 and focuses on building and operating SQL Server ETL pipelines and data warehouse components that power reporting workflows.

Key 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, including schedules, alerts, and failure handling
  • Design backend data to enable dependable, high-performance Power BI dataset refresh (semantic model support)
  • Partner 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

Required Qualifications

  • Ability to obtain and maintain a federal security clearance (U.S. citizenship required)
  • 3 to 5 years of hands-on SQL Server development experience
  • 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 gateway considerations
  • 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

Clearance Requirements

Must be able to obtain and maintain a federal security clearance.

Preferred Qualifications

  • 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

Role Details

The work involves constructing and maintaining the backend that supports reporting. Building Power BI reports is not part of the role. However, the position requires understanding how Power BI dataset refreshes and dependencies rely on the SQL Server backend. In addition, the role supports protection of sensitive data through masking and sound security practices.

Location and Compensation

  • Location: Abingdon, VA 24210 (onsite)
  • Salary: USD 70,000 to 90,000 per year

Similar Jobs