Data Warehouse Engineer / Data Warehouse Architect

Adroit Innovative Solutions Inc is seeking a Data Warehouse Engineer / Data Warehouse Architect for a long-term project with the State of California. The role focuses on reviewing ETL workflows, validating data quality, and providing governance and documentation support.

Responsibilities:

• Review ETL workflows and data pipelines
• Analyze source-to-target mappings
• Validate data quality and reconciliation
• Investigate data load issues (RCA)
• Assess operational processes and transition readiness
• Identify business continuity risks
• Review vendor implementation strategies
• Provide QA, governance, and documentation support
• Recommend process improvements

Requirements:

• 8+ years of U.S. experience for Engineer
• 10+ years of U.S. experience for Architect
• 8+ years of Enterprise ETL development & support
• Strong Teradata SQL (Mandatory)
• Enterprise Data Warehouse (EDW)
• ETL Design, Development & Support
• Data Validation & Reconciliation
• Production Data Warehouse Support
• Root Cause Analysis & Troubleshooting
• Documentation & Communication Skills
• Operational & Transition Risk Assessment
• Must not be currently employed by Optum
• Healthcare / Health Data experience
• Collibra
• Databricks
• Large-scale Vendor Transition experience
• Public Sector Data Warehouse experience