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
