Data Warehouse Architect

Job Description

Job Location : Richmond, VA (Hybrid)

Note : Candidates must be local to Richmond, VA, or willing to work onsite for interviews.

Job Description :

Jivan Infotech is seeking a Data Warehouse Architect for the State of Virginia . The ideal candidate will have experience working with Azure Data Factory , SSIS packages, and managing source code in Azure DevOps . The position will require excellent communication skills, the ability to manage project deadlines, and experience with data profiling and comparison. The role is hybrid, with some work performed remotely. A dependable high-speed internet connection is required for remote work.

Responsibilities :

• Develop and manage Azure Data Factory Pipelines or SSIS packages in SQL Server environments. (6 years)
• Manage source code in a GIT repository using Azure DevOps . (6 years)
• Estimate level of effort and manage deadlines for data warehouse projects. (6 years)
• Perform data profiling and comparison using tools like Toad Datapoint . (6 years)
• Maintain high standards of communication, both written and verbal, with team members and stakeholders. (6 years)
• Be self-motivated and independent, with the ability to work flexible hours as needed. (6 years)
• Ensure compliance with CJIS background checks and HIPAA / PII training requirements. (6 years)

Top Skills & Years of Experience :

Skill

Experience Level

Specialty

Azure Data Factory Pipelines

6 years

Designing and implementing data workflows in Azure environments.

SSIS Packages

6 years

Experience with SQL Server Integration Services for ETL processes.

Source Code Management

6 years

Managing source code in GIT using Azure DevOps .

Data Profiling & Comparison

6 years

Experience with Toad Datapoint for data profiling and comparison.

Project Estimation & Deadline Management

6 years

Estimating project effort and managing timelines and deadlines.

Communication Skills

6 years

Strong written and verbal communication for reporting and collaboration.

Self-Motivation & Independence

6 years

Ability to work independently and maintain productivity remotely.

Compliance & Security Training

6 years

Knowledge of CJIS , HIPAA , and PII regulations.

Preferred Skills :

Job Duration :

Long-term contract (Initial contract period : 1 year with possible extension).

Requirements

Required Skills & Experience : PowerBuilder Development (version 7 or higher) – 5 years T-SQL Query Writing (Sybase / MS SQL Server) – 10 years Data Management (profiling, mapping, validation, analysis) – 10 years Source Control (TFS / Azure DevOps, Git) – 5 years Unit Testing & Documentation – 10 years Testing & Production Support – 5 years Change Management – 5 years Minimum Qualifications : Some college education in Computer Science, IT, Computer Engineering, or related fields Experience working in a hybrid office environment Willingness to learn and adapt to new technologies This role requires a strong understanding of database management, system design patterns, and best practices in software development. The candidate must possess excellent troubleshooting skills and be able to communicate technical concepts effectively with both technical and business teams.