What are the responsibilities and job description for the Data Analyst 2 position at Virginia Information Technologies Agency?
We are seeking a skilled Data Analysr to support critical data migration, validation, and integration processes across multiple systems, including VIIS, STC, and EDR. The ideal candidate will have strong expertise in Oracle PL/SQL, Python, GCP Cloud Functions, and ETL/ELT processing to ensure accurate and efficient data movement.
Key Responsibilities:
- Priority 1: Support and validate data migration from VIIS to STC, ensuring data accuracy and completeness.
- Priority 2: Support and validate data transfer from STC to EDR, troubleshooting and resolving any migration issues.
- Priority 3: Facilitate and optimize data integration within EDR, ensuring seamless connectivity and data consistency.
- Develop and execute data validation processes to identify and resolve discrepancies.
- Write and optimize PL/SQL queries for data extraction, transformation, and migration.
- Utilize Python and GCP Cloud Functions to automate and streamline data workflows.
- Collaborate with cross-functional teams to support data governance, integrity, and compliance efforts.
- Document processes, workflows, and issues to improve future migrations and integrations
Required Qualifications:
Oracle PL-SQL, Python, GCP Cloud Functions, ETL/ELT Processing
Job Type: Contract
Pay: $47.00 - $49.00 per hour
Location:
- Richmond, VA 23219 (Required)
Ability to Commute:
- Richmond, VA 23219 (Preferred)
Work Location: In person
Salary : $47 - $49
