Skip to main content

Data Warehouse/BI Developer 4

globalpointHenrico, VASenior L5
Investment Decision Support SQL Developer/TesterThe Investment Decision Support team is seeking an experienced SQL Developer/Tester with strong database, programming, and analytical skills to actively participate in the following scope of work: Assist with overall SQL Support (development, performance tuning, testing, documentation) related to quarterly projects and other efforts as needed. Activities may include: 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.
Required Skills:
  • 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
Additional Preferred Skills:
  • Experience with automation tools such as Power Automate
  • Experience with data governance best practices/procedures
  • Investment/financial market industry experience
  • Skill - Required / Desired - Amount - Actual expSQL database development and programming - Required - 5QA/testing - Required - 3SSIS - Required - 3writing technical documentation - Required - 3automation tools such as Power
  • Automate - Nice to have - 1
APPLY NOW (opens in a new tab)

Matching similar jobs

Level

Senior L5

Location

Henrico, VA

Occupation

Software Developers

Industry

Computer Systems Design Services

Posted

11 days ago

APPLY NOW (opens in a new tab)