Data Analyst/EDW Solution Architect

Headway Tek Inc

San Jose (CA)

On-site

USD 150,000 - 210,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Headway Tek Inc. in San Jose, CA seeks an experienced Data Analyst/EDW Solution Architect to design, build, and optimize scalable data, analytics, and AI solutions.

This blended role translates business needs into trusted data products, engineers ingestion and transformation pipelines, and defines the architecture for a modern EDW and data lake. You will use Informatica for ingestion, Google BigQuery for the data warehouse and data lake, and Tableau for analytics.

Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, Analytics, or related field, or equivalent practical experience.
  • 8+ years of experience across data engineering, BI, 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 RBAC and 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

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 RBAC/RLA controls.
  • Business-facing IT leadership: Act as the primary IT partner and trusted advisor for business stakeholders, maintaining frequent interaction to understand needs and coordinate delivery across teams.
  • Operational excellence: Monitor pipelines and dashboards, troubleshoot production issues, perform root-cause analysis, and improve reliability through automation and testing.
  • Technical leadership: Lead design reviews, create architecture standards and technical documentation, mentor team members, and collaborate with security and cloud teams.

Skills

SQL
Python
Informatica
APIs
Reporting
Dashboards
Data architecture
Pipeline design
BigQuery
Tableau
Workday

Education

Bachelor's degree in CS/IS/Analytics

Tools

Google BigQuery
Tableau
Informatica

Job description

Title: Data Analyst/EDW Solution Architect

Location: San Jose, CA

Work Type: Onsite 5 days

C2C or W2

Couple of re 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.

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
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Manager, Enterprise Data & Analytics
Sr. Manager, Enterprise Data & Analytics

Aisera • San Jose (CA)

Hybrid
USD 200,000 - 230,000
Data Architect
Data Architect

Capital Technology Alliance • Tallahassee (FL)

On-site
USD 130,000 - 160,000
Health insurance
401(k) retirement plan
Flexible working hours
Enterprise EDW Architect & Data Analytics Lead
Enterprise EDW Architect & Data Analytics Lead

Headway Tek Inc • San Jose (CA)

On-site
USD 150,000 - 210,000
Sr. Principal PreSales Lead – Data Management, Analytics & AI/ML
Sr. Principal PreSales Lead – Data Management, Analytics & AI/ML

Edgematics • United States

Remote
USD 180,000 - 280,000
Sr. Data Engineer
Sr. Data Engineer

ProArch • United States

Remote
USD 140,000 - 190,000
Data Architect (Advanced)
Data Architect (Advanced)

SGS Technologie • Tallahassee (FL)

On-site
USD 110,000 - 150,000
Data Architect
Data Architect

UNAVAILABLE • McLean (VA)

On-site
USD 140,000 - 190,000
Sr. Data Engineer
Sr. Data Engineer

ProArch • Atlanta (GA)

On-site
USD 120,000 - 180,000
Data Solution Architect
Data Solution Architect

UNAVAILABLE • McLean (VA)

On-site
USD 120,000 - 180,000
Enterprise Data Architect
Enterprise Data Architect

Paladin Consulting • Dallas (TX)

On-site
USD 180,000 - 240,000