Data Warehouse Consultant

IMCS Group; Richmond (VA); Hybrid; USD 80,000 - 100,000; Full time

Job summary

A leading technology and consulting firm in Richmond, VA is seeking an experienced Data Warehouse / BI Developer 4 to support SQL development and testing initiatives. This position demands over 5 years of SQL programming expertise, proficiency in ETL processes with SQL Server Integration Services (SSIS), and the ability to produce clear technical documentation. Candidates must excel in both independent and collaborative work settings, ensuring high data integrity and efficient data management. This hybrid role offers the potential for extension beyond the initial contract period.

Qualifications

• 5+ years of SQL database development and programming experience.
• 3+ years of QA/testing experience.
• Hands-on experience with SQL Server Integration Services (SSIS).
• Strong experience writing technical documentation.
• Excellent communication skills.

Responsibilities

• Provide SQL development support, including stored procedures and complex queries.
• Design and implement ETL packages using SQL Server Integration Services (SSIS).
• Perform SQL performance tuning and optimizing queries.
• Support data manipulation initiatives and automate workflows.
• Produce clear technical documentation.

Skills

SQL database development

QA/testing

SQL Server Integration Services (SSIS)

Technical documentation

Communication skills

Tools

Power Automate

Job description

Job Title: Data Warehouse / BI Developer 4

Duration: 02/02/2026 – 08/14/2026 (Extension Possible)

Interview: Web Cam Interview Only

Job Description

We are seeking an experienced SQL Developer / Tester to support ongoing data, reporting, and investment decision-support initiatives. The IDS team serves as the primary data steward for the Investments Department, ensuring high data integrity, availability, and efficient data lifecycle management.

This role requires strong SQL development, testing, performance tuning, and documentation skills, along with experience supporting ETL processes using SSIS. The selected candidate will work closely with business and technical teams in a hybrid work environment.

Key Responsibilities

• Provide SQL development support, including creation and maintenance of stored procedures and complex queries
• Design, develop, and implement ETL packages using SQL Server Integration Services (SSIS)
• Perform SQL performance tuning by analyzing execution plans and optimizing long-running queries
• Support data manipulation and transformation initiatives, including converting manual Excel-based processes into automated SSIS workflows
• Review and recommend improvements to SQL development processes such as code promotion and peer reviews
• Develop detailed test plans, test cases, and perform thorough testing of reports, workflows, and data processes
• Produce clear and concise technical documentation, including requirements, process flows, and support documentation
• Collaborate effectively with cross-functional teams while also working independently with minimal supervision

Required Skills & Experience

• 5+ years of SQL database development and programming experience
• 3+ years of QA/testing experience
• Hands-on experience with SQL Server Integration Services (SSIS)
• Strong experience writing technical documentation (requirements, process maps, procedures)
• Excellent communication skills (written and verbal)
• Proven ability to work both independently and as part of a collaborative team

Preferred / Nice-to-Have Skills

• Experience with automation tools such as Power Automate
• Knowledge of data governance best practices and procedures
• Experience in the investment or financial services industry
• Hybrid role with on-site presence required in Richmond, VA
• Contract position for approximately 6 months with potential for extension