i-Link Solutions · 22 hours ago
VRS - Data Warehouse/BI Developer 4
Richmond, VA
Full-time
Hybrid
Senior Level
5+ years expi-Link Solutions is seeking an experienced SQL Developer/Tester to join the Virginia Retirement System's Investment Decision Support team. The role involves SQL development, performance tuning, testing, and ensuring high levels of data integrity and availability for investment analysis.
Cloud ComputingInformation TechnologySoftwareWeb Development
No H1B
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
Required
5+ years of experience in SQL database development and programming
3+ years in a QA/testing role
Experience with SQL Server Integration Services
Experience writing technical documentation (requirements, process maps, etc.)
Excellent communicator and ability to produce clear and concise documentation
Demonstrated experience working in a team environment
Demonstrated experience working independently with only high-level guidance
Preferred
Experience with automation tools such as Power Automate
Experience with data governance best practices/procedures
Investment/financial market industry experience
Company
i-Link Solutions
i-Link Solutions, Inc. (i-Link) is an enterprise modernization firm that develops and delivers high-quality solutions.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase