Global Business Intelligence Solutions Data Architect

Lam Research; Fremont (CA); Hybrid; USD 137,000 - 287,000; Full time

Job summary

Lam Research is seeking a Data Architect to drive digital transformation in their Global Business Intelligence Solutions group. The role involves designing data engineering solutions, collaborating with business stakeholders, and ensuring alignment with analytical strategies.

The ideal candidate should have over 12 years of experience in data engineering and cloud technologies, particularly with Azure and AWS. The position offers hybrid work flexibility, balancing onsite collaboration and remote work.

Qualifications

• 12+ years of experience with modern data engineering and data warehousing.
• 10+ years of SQL experience with cloud-native data warehousing.
• 5+ years of experience with FP&A applications and ERP systems.

Responsibilities

• Lead design of data engineering and integration solutions.
• Collaborate with stakeholders for big data platform initiatives.
• Design data governance specifications as part of digital transformation.

Skills

Data engineering

SQL

Cloud platforms (Azure, AWS)

Python

Spark

Data governance

Analytics design

Education

Bachelor’s in Computer Science/IT/MIS/Data Science/Analytics

Master’s or PhD preferred

Tools

Databricks

Workday Adaptive

Azure Synapse

Microsoft Fabric

Job description

Overview

As a Data architect supporting digital transformation in GBIS (Global Business Intelligence Solutions) group at Lam Research, you'll be responsible for designing and developing data engineering and integration solutions for future systems. Your role includes drafting specifications, creating solution designs, coordinating with development teams, and collaborating with data architecture, business, and development groups. You'll also advise application and business development teams on complex analytics design, ensuring alignment with Data and Analytics Hub principles, standards, and strategies.

What You’ll Do

• Use leadership skills to drive process, data, analytics, and AI design from discovery to delivery.
• Collaborate with Business and GIS stakeholders to support big data platform initiatives and provide direction on defining data strategy and architecture for cloud-native platforms.
• Design and develop data engineering solutions and data governance specifications as part of digital transformation processes.
• Participate in business transformation workshops with subject matter experts to identify data and process gaps, proposing scalable data and analytics architectures to address those needs.
• Utilize existing architecture as a data hub for the digital transformation program, identifying supplemental tools and services for process improvement.
• Offer guidance and insights on emerging data analytics trends and technical capabilities that can enhance digital transformation across the company.
• Demonstrate advanced data and analytics solutions to digital transformation teams, showing the potential of the Data Fabric platform with proof‑of‑concept projects.
• Develop, uphold, and advocate for advanced analytics standards and procedures throughout the GIS Data Hub across the entire organization.
• Design planning and analytics solutions by integrating Workday Adaptive with the Azure analytics stack (Microsoft Fabric, Synapse, Power BI), including ETL/ELT pipelines to support enterprise decision‑making.
• Build strong relationships with key business sponsors and IT resources to efficiently resolve work requests.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, MIS, Data Science, Analytics, or a relevant Engineering field; Master’s or PhD preferred.
• Over 12 years of experience with modern data engineering, data warehousing, and data lake technologies on cloud platforms such as Azure, AWS, and Databricks.
• Over 10 years of SQL experience with cloud-native data warehousing and data modeling.
• Over 5 years of experience building and supporting FP&A applications, integrating platforms such as Workday Adaptive, Anaplan, SAP BPC etc. with ERP systems and Azure data platform.
• Over 5 years of experience configuring Azure cloud and SaaS platforms and building automated ETL/ELT pipelines for real‑time, streaming and batch data exchange.
• Minimum of 3 years working extensively with Spark and Python technologies for big data processing.
• At least 3 years of hands‑on experience implementing end‑to‑end medallion architecture using Databricks or similar cloud tools.
• Proven background in schema design and dimensional data modeling.
• Comprehensive knowledge of data warehouse best practices, development standards, and methodologies using platforms like MS Fabric, Azure Synapse, Redshift, etc.
• Skilled communicator and presenter, with a record of leveraging insights to influence executives and team members.

Preferred Qualifications

• Experience with financial planning platforms and related business processes (e.g., budgeting, forecasting and long‑term planning) is a plus.
• Strong background in working with and analyzing large datasets, particularly in IoT and enterprise domains.
• Preferred: Strong computer science and mathematics foundation.
• Excellent SQL/query writing skills and communication abilities.
• Familiarity with common APIs, such as REST and SOAP, is advantageous.

Work Location

Lam offers a variety of work location models based on the needs of each role. Our hybrid roles combine the benefits of on‑site collaboration with colleagues and the flexibility to work remotely and fall into two categories – On‑site Flex and Virtual Flex. ‘On‑site Flex’ you’ll work 3+ days per week on‑site at a Lam or customer/supplier location, with the opportunity to work remotely for the balance of the week. ‘Virtual Flex’ you’ll work 1-2 days per week on‑site at a Lam or customer/supplier location, and remotely the rest of the time.

Salary

CA San Francisco Bay Area Salary Range for this position: $137,000.00 - $287,000.00. The above salary range for this position is relevant to applicants that reside or work onsite in the California, San Francisco Bay Area only. Salary offers will depend on factors that include the location you work from, your level, education, training, specific skills, years of experience and comparison to other employees already in this role. Actual salary may vary from salary offered due to numerous factors including but not limited to unpaid time off, unpaid leave, company mandated shutdown, and other relevant factors.

Equal Opportunity Employer

Lam Research is an equal opportunity employer. Lam is committed to and reaffirms support of equal opportunity in employment and non‑discrimination in employment policies, practices and procedures on the basis of race, religious creed, color, national origin, ancestry, physical disability, mental disability, medical condition, genetic information, marital status, sex (including pregnancy, childbirth and related medical conditions), gender, gender identity, gender expression, age, sexual orientation or military and veteran status or any other category protected by applicable federal, state, or local laws. It is the Company’s intention to comply with all applicable laws and regulations. Company policy prohibits unlawful discrimination against applicants or employees.