Data WarehouseBI Developer

Job Description

Position:
Data Warehouse/BI Developer

Location:

1111

E. Main St. Richmond, VA
- Onsite

The 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:

• 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.

• 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

• Experience with automation tools such as Power Automate
• Experience with data governance best practices/procedures
• Investment/financial market industry experience

Regards,

Manoj

Derex Technologies INC

Contact :
Ext 206

Qualifications: Additional Information

All your information will be kept confidential according to EEO guidelines.