BI Solution architect with Data Warehouse

Overview

Hybrid
$90 - $95
Contract - Independent
Contract - W2
Contract - 12 Month(s)
75% Travel

Skills

BI
Data warehouse

Job Details

Solution architect-BI
Santa Ana, CA - 4 days weeks
Role Overview
The Solution Architect will lead onsite engagement for a data and analytics transformation program, working closely with business and technology stakeholders to translate requirements into scalable BI and data solutions. This role includes guiding data foundation build-out, enabling advanced analytics and insights, and ensuring smooth communication with the offshore delivery team.

Key Responsibilities
  • Engage with business teams to define reporting, analytics, and Conversational BI requirements
  • Assess current data and BI landscape and define target-state architecture
  • Oversee creation of data pipelines, semantic layers, and reporting assets
  • Guide adoption of advanced analytics using statistical/ML/LLM techniques where applicable
  • Ensure robust governance, DevOps readiness, and IaC-based deployment
  • Act as the primary onsite liaison for requirement clarity, knowledge sharing, and stakeholder communication

Required Skills & Qualifications
  • Strong experience in enterprise data warehousing, BI architecture, and large-scale analytics delivery
  • Deep understanding of data modeling for analytics (dimensional & semantic layer design)
  • Hands-on expertise with ETL/ELT patterns and orchestration
  • Strong knowledge of data governance, metadata management, security models, and IAM for data platforms
  • Experience with BI tools (preferably Looker or equivalent enterprise-grade platforms)
  • Awareness of AI/ML techniques for insight automation, anomaly/outlier detection
  • Strong understanding of DevOps concepts for data: CI/CD, code-based delivery, versioning
  • Proficiency in cloud-based data analytics platforms (Google Cloud Platform experience highly advantageous; BigQuery familiarity a plus)
  • Excellent stakeholder management, business communication, and requirement discovery skills
  • Ability to operate in an onsite offshore model, driving clarity and collaboration
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.