Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Analyst Edw Solution Architect

Temporary

Momento USA

Momento USA is a global technology consulting, talent acquisition and creative development firm that addresses clients most pressing needs and challenges.

We currently looking for Data Analyst/EDW Solution Architect our client location based on - San Jose,CA(Onsite). Please see the job description below for your reference.

Title: Data Analyst/EDW Solution Architect

Location: San Jose, CA

Work Type: Onsite 5 days

Couple of refresher points: Client is seeking below & role is based out of San Jose USA - 5 working days from the HQ office.

Tech Stack: The role requires strong hands-on experience in SQL, Python, Informatica, APIs, reporting, and data engineering. Candidate needs to be able provide sufficient practical examples of building integrations, designing reports/dashboards, working with ERP/CRM systems (Workday/Salesforce), or solving real-world technical challenges.

Domain Knowledge: Please prioritize candidates with experience on both the engineering and business sides, specifically:

A solid grasp of SaaS financial metrics such as ARR, bookings, billings, revenue, and pipeline.
Hands-on work building data models and reports for these metrics, including aligning definitions across Finance, Sales, and RevOps systems like Salesforce and Workday.
Direct experience partnering with senior leaders in Finance, FP&A, and RevOps to gather requirements, agree on metric definitions, and deliver reporting the business trusts.

We're looking for candidates with:

  • Strong hands-on experience in SQL, Python, Informatica, and API integrations
  • Data architecture and pipeline design experience
  • Reporting and dashboard development experience with measurable business outcomes
  • Strong stakeholder management and requirements gathering skills
  • Experience with Workday/Salesforce data (preferred)
  • AI/LLM experience (nice to have)
  • We can look at architect and senior data engineer roles with solutioning expertise.

JD:

Data Analyst/EDW Solution Architect

Position Summary

We are seeking an experienced Data Analyst/Enterprise Data Warehouse (EDW) Solution Architect to design, build, and optimize scalable enterprise data, analytics, and AI solutions. This blended role will translate business needs into trusted data products, engineer reliable ingestion and transformation pipelines, and define the architecture for a modern data warehouse and data lake ecosystem. Serving as the face of IT for business stakeholders, this individual will engage with them regularly to understand priorities, shape solutions, communicate progress, and drive adoption. The role will use Informatica for the data ingestion and integration layer, Google BigQuery as the cloud data warehouse and data lake platform, and Tableau as the analytics and visualization user interface.

Key Responsibilities

  • Solution architecture: Define the target-state EDW, data lake, and analytics architecture, including logical and physical data models, integration patterns, security controls, metadata, lineage, and nonfunctional requirements.
  • Data ingestion and integration: Design and develop batch and near-real-time pipelines using Informatica to ingest data from enterprise applications, databases, APIs, files, and third-party platforms.
  • BigQuery engineering: Build and optimize curated data layers, dimensional models, data marts, and lakehouse-style datasets in Google BigQuery, with attention to partitioning, clustering, performance, scalability, and cost.
  • Data transformation: Implement reusable transformation logic, data standardization, reconciliation, and orchestration processes across raw, trusted, and consumption layers.
  • Analytics and visualization: Partner with business stakeholders to define KPIs and create governed Tableau dashboards, reports, and self-service analytics experiences.
  • Business analysis: Elicit and document requirements, profile source data, perform exploratory analysis, identify trends and anomalies, and translate findings into actionable recommendations.
  • Data quality and governance: Establish data quality rules, monitoring, exception handling, lineage, reference data, business definitions, stewardship processes, and auditability.
  • Security and compliance: Apply role-based access, least-privilege principles, sensitive-data protections, retention requirements, and applicable privacy and regulatory controls.
  • AI solutions on the EDW: Design and build AI-enabled solutions that securely use governed EDW and data lake assets, implementing Role-Based Access Control (RBAC) and Row-Level Access (RLA) controls to ensure users, applications, and AI services can access only authorized data.
  • Business-facing IT leadership: Act as the primary IT partner and trusted advisor for business stakeholders, maintaining frequent interaction to understand needs, facilitate decisions, manage expectations, present solution options, and coordinate delivery across technical teams.
  • Operational excellence: Monitor pipelines and dashboards, troubleshoot production issues, conduct root-cause analysis, and improve reliability through automation, testing, and observability.
  • Technical leadership: Lead design reviews, create architecture standards and technical documentation, mentor team members, and collaborate with application, cloud, security, and business teams.

Required Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, Analytics, or a related field, or equivalent practical experience.
  • 8+ years of experience across data engineering, business intelligence, data analysis, data warehousing, or solution architecture.
  • Hands-on experience with Informatica products and enterprise ETL/ELT design, development, deployment, and support.
  • Strong experience with Google BigQuery, SQL, cloud data warehousing, data lake concepts, data modeling, and query optimization.
  • Demonstrated experience developing Tableau dashboards, semantic layers, calculated fields, data sources, row-level security, and performance-optimized visualizations.
  • Experience building AI-enabled solutions on enterprise data warehouse or data lake platforms, including secure access to governed data for AI models, agents, or applications.
  • Hands-on experience designing and implementing Role-Based Access Control (RBAC) and Row-Level Access (RLA) security controls across BigQuery, Tableau, and enterprise data products.
  • Strong knowledge of dimensional modeling, star and snowflake schemas, slowly changing dimensions, master and reference data, and data lifecycle management.
  • Experience integrating structured and semi-structured data from SaaS applications, relational databases, APIs, and files.
  • Proficiency in SQL and at least one scripting or programming language such as Python.
  • Experience with data quality frameworks, metadata management, data lineage, testing, CI/CD, and production support.
  • Strong communication skills with the ability to explain technical concepts to business audiences and convert business requirements into scalable solutions.
  • Proven ability to serve as the face of IT for business teams, build trusted stakeholder relationships, lead recurring working sessions, and communicate solution strategy, trade-offs, risks, and delivery status clearly.

Thanks

Thirumurugan D

<

View phone number on snaprecruit.com

Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status

Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the Data Analyst Edw Solution Architect in San Jose, CA vacancy
  • $110k - $138k

     ...cybersecurity, cloud and infrastructure solutions. Through its Advanced Technology Center...  ...Solutions & Architecture team, part of AI & Data Solutions, focused on computer vision...  ...your expertise with sellers and solution architects so more of the team can carry computer... 
    Suggested
    Full time
    Work experience placement
    Remote work
    Flexible hours
    Shift work

    World Wide Technology

    San Jose, CA
    3 days ago
  •  ...Job Title : Siemens Camstar / Opcenter MES Solution Architect & Developer Location : San Jose CA   Job Description:   Siemens Camstar...  ..., uploading, and validating them.  Collecting real-time data from equipment sensors and processes. Implementing data collection... 
    Suggested

    Galaxy i Technologies, Inc.

    San Jose, CA
    13 hours ago
  • $120 - $130 per hour

     ...enterprise supply chain team as the Lead Solution Architect for E2open Manufacturing Visibility. In...  ...platforms, logistics/supplier systems, data platforms, and APIs/middleware....  ...and functional leadership to developers, analysts, integration specialists, and support teams... 
    Suggested
    Hourly pay
    Contract work
    Temporary work
    Work experience placement
    Local area

    Randstad Digital

    San Jose, CA
    1 day ago
  •  ...Oracle Fusion Applications Solutions ArchitectWe are seeking an Oracle Fusion Applications Solutions Architect with expertise in the design, implementation, and governance of...  ...migration methodologies, toolsets, and automated data validation during conversion cycles.Provide... 
    Suggested
    Work experience placement

    Lattice Semiconductor

    San Jose, CA
    3 days ago
  •  ...partners as they research quantum computing solutions for their most pressing business...  ...empowered to use our software and services. As a data scientist intern, you will be supporting...  ...year. Job Title Quantum Data Analyst Intern 2027 Date posted 18-Sep-2026... 
    Suggested
    Full time
    Contract work
    Part time
    Fixed term contract
    Internship
    Shift work

    IBM

    San Jose, CA
    4 days ago
  • $205k - $308k

     ...Senior Solutions Architect, Alliances Everpure is building the Enterprise Data Cloud data unified, governed and understood as one intelligent system, and the foundation enterprises build AI on. No vendor delivers that alone. Our key Alliance Partners own software and... 
    Flexible hours

    Pure Storage

    Santa Clara, CA
    2 days ago
  • $148k - $235.75k

     ...process, documenting blockers and finding solutions to launch AI Factories at scale. Our...  ...looking for an ambitious Senior Solutions Architect to drive validation of NVIDIA AI factories...  ...Comfortable working with observability data (metrics, logs, dashboards) to... 
    Full time

    Nvidia

    Santa Clara, CA
    10 days ago
  • $152k - $241.5k

     ...largest customers? We are looking for an experienced networking Solutions Architect to support accelerated computing networking solutions for AI/...  ...on experience with Ethernet Switch software solution and data center production network. Strong experience with RDMA/RoCE... 
    Full time

    Nvidia

    Santa Clara, CA
    12 days ago
  •  ...The Principal AI Solutions Architect at DataDirect Networks (DDN) combines technical mastery with outcome driven strategic selling/consulting...  ...role is pivotal in aligning DDN’s cutting-edge AI solutions and data management technologies with clients’ business needs, driving... 
    Full time

    ddn

    Santa Clara, CA
    4 days ago
  • $148k - $235.75k

     ...you can make a lasting impact on the world. Join NVIDIA as a Solution Architect on the First Time Deployment Team and contribute to shaping the...  ...successful deployments. What you'll be doing: NVIS Data Center deployment planning: Collaborate with product and engineering... 
    Full time
    Work at office
    Worldwide

    Nvidia

    Santa Clara, CA
    10 days ago
  •  ...building the infrastructure behind the AI-driven data economy. As AI scales, so does data. Every...  ...platform. We are seeking a senior Kinaxis Architect to own the coherence, scalability and evolution of this business solution across demand, supply, capacity, material,... 
    Temporary work
    Local area
    Immediate start
    Remote work
    Worldwide
    Flexible hours
    Shift work

    Western Digital

    San Jose, CA
    6 days ago
  • $152k - $241.5k

     ...We’re hiring a Senior Solutions Architect to drive technical engagement with NVIDIA partners, OEMs, and customers across NVIDIA AI Factory solutions, focusing on on-premises enterprise solutions. In this role, you’ll connect real-world customer workloads to NVIDIA’s hardware... 
    Full time
    Local area
    Remote work

    Nvidia

    Santa Clara, CA
    12 days ago
  • $200k - $250k

     ...risk across human, machine, and agentic identities, and drives remediation through existing operational systems. We need a Solutions Architect who can carry the Axiad Mesh story into the field and make it real. This role goes well beyond traditional sales engineering... 
    Full time
    Remote work
    Shift work

    Axiad

    San Jose, CA
    4 days ago
  •  ...Description Request ID: 98680-1 Title: Siemens Camstar/OpCenter MES Solution Architect Locations: San Jose, CA Duration: 6+ Months Pay...  ..., uploading, and validating them. Collecting real-time data from equipment sensors and processes. Implementing data... 
    Work experience placement
    Immediate start

    Artech LLC

    San Jose, CA
    19 days ago
  •  ...Data Solutions ArchitectLocation: Santa Clara, CAFull Time – PermanentExperience Required - 08 - 10 YearsJob Description: We are seeking a highly experienced Data Solutions Architect to design and deliver next-generation cloud-based data platforms with a strong focus... 

    AceStack LLC

    Santa Clara, CA
    5 days ago
  • $123.75k - $282k

     ...SAP GTM Director & Solution Architect - CPRS Industry Choosing Capgemini means choosing a company where you will be empowered to shape your...  ...SAP transformation to leverage SAP Business AI, Business Data Cloud, SAP BTP, enterprise architecture, intelligent automation... 
    Full time
    Local area

    Capgemini

    Santa Clara, CA
    2 days ago
  • $224k - $356.5k

     ...NVIDIA is looking for a hands-on Solutions Architect to raise the Day 2 operations bar across our NVIDIA Cloud Partner ecosystem. Day 2 starts...  ...performance storage such as Lustre, IBM Storage Scale, WEKA, VAST Data, or comparable platforms. ~ Working experience across the... 
    Full time
    Work experience placement

    Nvidia

    Santa Clara, CA
    10 days ago
  • $152k - $241.5k

     ...We’re hiring a Solutions Architect to join the Agentic AI team. In this role, you’ll support customer-facing technical engagements and help connect real-world workloads to NVIDIA’s hardware and software ecosystem. We’re looking for someone who is technically curious, eager... 
    Full time

    Nvidia

    Santa Clara, CA
    4 days ago
  •  ...Role Overview We are looking for a senior Security Solutions Architect with deep experience across cybersecurity, AI/ML architecture, and emerging...  ...evaluation criteria across areas such as model security, data protection, access controls, isolation, observability,... 

    Apetan

    Milpitas, CA
    a month ago
  • $126.9k - $151.8k

     ...team that’s ready to tackle challenges and build cutting-edge solutions. We value purpose, drive, and curiosity—and we thrive in a fast...  ...ResponsibilitiesSet the analytics agenda for AP. Find product opportunities, data gaps, and automation candidates, and bring them to Product as... 
    Temporary work
    Work at office
    Remote work
    Flexible hours

    Bill.Com

    San Jose, CA
    5 days ago
  • $184k - $287.5k

    We are looking for a Senior Solutions Architect, Industrial Robotics to engage with customers, partners, and other NVIDIA software engineers to...  ...engaging with internal developers, scientific researchers, data scientists, IT managers, and senior leaders is an important part... 
    Full time

    Nvidia

    Santa Clara, CA
    1 day ago
  • $210.2k - $284.3k

    As an Amazon Web Services (AWS) Principal Solutions Architect within the Strategic Accounts segment, you are responsible for partnering with our...  ..., systems engineering, infrastructure, security, networking, data & analytics) experience- Experience developing technology... 
    Local area
    Flexible hours

    AmazonWebServices

    Cupertino, CA
    3 days ago
  • $152k - $241.5k

     ...memory use within device constraints.Lead optimization of synthetic data workflows spanning generation, augmentation, filtering, and...  ...engineering, developer relations, technical partnerships, solutions architecture, or product management, including 3+ years of direct... 
    Full time

    Nvidia

    Santa Clara, CA
    1 day ago
  • $152k - $241.5k

     ...leading AI company, and we are looking for an experienced Senior Solutions Architect to help customers build, scale, and optimize AI training...  ....Develop and optimize end-to-end training workflows spanning data preparation, distributed training, checkpointing, and evaluation... 
    Full time

    Nvidia

    Santa Clara, CA
    5 days ago
  • $152k - $241.5k

     ...leading AI company, and we are looking for an experienced Cloud Solution Architect to help assist customers with adoption of GPU hardware and...  ...building and deploying Machine Learning (ML) , Deep Learning (DL), data analytics solutions on various Cloud Computing Platforms. As... 
    Full time
    Local area

    Nvidia

    Santa Clara, CA
    2 days ago
  • SAP Subscription Management - SOM (BRIM) Solution ArchitectThis role has been designed as '...  ...connect, protect, analyze, and act on their data and applications wherever they live, from...  ...Management - SOM (BRIM) Solution Architect Onshore / Offshore Onshore Who We Are Hewlett... 
    Full time
    Contract work
    Work experience placement
    Work at office
    Local area
    Immediate start
    Worldwide
    Shift work
    2 days per week

    Hewlett Packard Enterprise

    San Jose, CA
    1 day ago
  • $138.1k - $196.5k

     ...6The Service Supply Chain IT Analyst will partner with global Service...  ...scalable enterprise IT solutions. This role translates sophisticated...  ....Collaborate with enterprise architects, software engineering squads,...  ...and formal change governance.Data, Telemetry & ReportingGuide... 
    Permanent employment
    Full time
    Contract work
    Temporary work
    Local area
    Flexible hours

    CISCO Systems

    San Jose, CA
    2 days ago
  • $124k - $195.5k

    We’re hiring a Solutions Architect to join our AI Software Segment Solutions Architecture team, focused on open-weight AI models. In this role...  ...tuning, reinforcement learning (GRPO, DPO, PPO), LoRA / PEFT, data curation, synthetic data generation, reward design, and... 
    Full time

    Nvidia

    Santa Clara, CA
    4 days ago
  • $124k - $195.5k

     ...innovation. Our Worldwide Field Operations Solutions Architecture team supports third-party...  ...solutions. We are hiring a Solutions Architect to boost adoption of NVIDIA DSX Sim, Omniverse...  ..., SimReady specifications, engineering data, multi-physics simulation, and... 
    Full time
    Worldwide

    Nvidia

    Santa Clara, CA
    3 days ago
  • $176.6k - $239k

     ...need a trusted technical partner who can keep pace. As a Senior Solutions Architect on the Amazon Web Services (AWS) Strategic Digital Native...  ...customers, incorporating generative AI capabilities, modern data patterns, and AWS managed services to solve complex business... 
    Local area
    Flexible hours
    Day shift

    AmazonWebServices

    Santa Clara, CA
    4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Analyst Edw Solution Architect. Be the first to apply!