Solution Architect

Mega Cloud Lab; Santa Ana (CA); On-site; USD 130,000 - 160,000; Full time

Job summary

A leading cloud solutions provider in California seeks a Solution Architect to lead onsite engagements for a data and analytics transformation program. In this role, you will engage with business teams to define reporting requirements, assess the current BI landscape, and guide the creation of data solutions. The ideal candidate will have strong experience in enterprise data warehousing and BI architecture, along with proficiency in cloud-based data analytics platforms. This is a pivotal role requiring excellent stakeholder management skills.

Qualifications

• Strong experience in enterprise data warehousing and BI architecture.
• Deep understanding of data modeling for analytics required.
• Hands-on expertise with ETL/ELT patterns and orchestration necessary.

Responsibilities

• Engage with business teams to define analytics requirements.
• Assess current data landscape and define architecture.
• Oversee creation of data pipelines and reporting assets.

Skills

Enterprise data warehousing

BI architecture

Large-scale analytics delivery

Data modeling for analytics

ETL/ELT patterns

Data governance knowledge

BI tools (Looker)

AI/ML techniques awareness

DevOps concepts

GCP experience

Job description

Job Summary

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 (GCP 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