Apply on Employer Site

Yakshna Solutions · 20 hours ago

Data Warehouse/BI Developer 4

Herndon, VA

Full-time

Hybrid

Mid, Senior Level

$95K/yr - $100K/yr

5+ years exp

Yakshna Solutions, Inc. is a certified woman-owned small business providing IT solutions and services. They are seeking an experienced SQL Developer/Tester to assist with SQL Support, development, and performance tuning related to various projects.

ConsultingGovernmentInformation ServicesInformation Technology

No H1B

U.S. Citizen Only

Responsibilities

Assist with overall SQL Support (development, performance tuning, testing, documentation) related to quarterly projects and other efforts as needed

Development - SQL Development support to include creation of stored procedures or underlying queries. Provide support in the design, development, and implementation of ETL packages with SQL Server Integration Services (SSIS)

Performance Tuning - Review existing SQL Queries, Execution Plans, etc. to determine performance enhancements for long running queries

Data Manipulation - Provide alternative options to existing data manipulation techniques. Examples would be converting Excel manipulation activities into SSIS packages that reduce process/cycle time of data preparation

SQL Development Processes - Review existing development processes and provide recommendations on how to enhance core development activities (i.e., Code Promotion, Code Reviews)

Testing – Develop test plans and cases and thoroughly test reports and workflows

Qualification

SQL developmentSQL Server Integration ServicesPerformance tuningAutomation toolsData governanceTechnical documentationCommunicatorInvestment industry experienceTeam collaborationIndependent work