Data Lakehouse Architect for BI & AI

McGuireWoods

Los Angeles (CA)

Hybrid

USD 140,000 - 195,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Hybrid remote option

Job summary

McGuireWoods LLP is seeking a Data Architect to join our IT team in Los Angeles. The role designs and sustains the Firm's Data Lakehouse, ensuring secure, scalable data solutions that power BI, analytics, and AI initiatives.

Collaborating with the Database Platform Lead and stakeholders, you translate business needs into robust data architecture, governance, and integration patterns, supporting enterprise reporting across the firm.

Qualifications

  • Bachelor’s degree or equivalent in a related field.
  • Minimum five years of data architecture/engineering experience.
  • Experience with Azure and Databricks.
  • Enterprise data solutions design including structures, models, and pipelines.
  • Strong SQL proficiency with relational databases and data warehouses.
  • Knowledge of data modeling, relational and dimensional concepts.
  • Hands-on ETL/ELT, data integration patterns, transformation, mapping, and validation.
  • Experience integrating data from multiple enterprise sources.
  • Cloud-based data lake/warehouse/lakehouse architectures.
  • Secure, scalable data solutions for BI, analytics, or AI.
  • Translate business requirements into technical data architectures and integrations.
  • Understanding data quality, security, access control, lineage, and governance.

Responsibilities

  • Designs and maintains the Data Lakehouse architecture ensuring scalability and security.
  • Translates business requirements into technical data solutions.
  • Identifies data sources to support BI, analytics, AI and reporting.
  • Designs data structures, data flows, mappings for downstream use.
  • Configures data connectors between Data Lakehouse and Firm applications.
  • Resolves data integration issues with source system owners.
  • Applies governance, data quality, and security practices in the data platform.
  • Collaborates with BI, AI, and development teams to support solutions.
  • Documents architecture, mappings, data flows, and dependencies.
  • Evaluates emerging technologies and improvements for the Data Lakehouse.

Skills

SQL
Data Modeling
ETL/ELT
Data Integration
Azure Databricks
Python / PySpark
Data Lakehouse
Data Security & Governance
Communication

Education

Bachelor’s degree in Computer Science, Information Systems, Data Engineering

Tools

Microsoft Azure
Databricks
Power BI

Job description

McGuireWoods LLP is seeking a Data Architect to join our IT team in Los Angeles. The role designs and sustains the Firm's Data Lakehouse, ensuring secure, scalable data solutions that power BI, analytics, and AI initiatives.

Collaborating with the Database Platform Lead and stakeholders, you translate business needs into robust data architecture, governance, and integration patterns, supporting enterprise reporting across the firm.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Lakehouse Architect for AI & Analytics
Data Lakehouse Architect for AI & Analytics

McGuireWoods LLP • Texas

Hybrid
USD 120,000 - 180,000
Data Lakehouse Architect for BI & AI (Hybrid Remote)
Data Lakehouse Architect for BI & AI (Hybrid Remote)

McGuireWoods • Charlottesville (VA)

Hybrid
USD 140,000 - 190,000
Hybrid Data Architect - Lakehouse, Azure & AI Solutions
Hybrid Data Architect - Lakehouse, Azure & AI Solutions

McGuireWoods LLP • Maryland

Hybrid
USD 120,000 - 160,000
Hybrid remote option
Hybrid Remote Data Lakehouse Architect | Azure Databricks
Hybrid Remote Data Lakehouse Architect | Azure Databricks

McGuireWoods LLP • Norfolk (VA)

Hybrid
USD 120,000 - 180,000
Hybrid remote option
Excellent benefits
Data Lakehouse Platform Lead — Hybrid Remote
Data Lakehouse Platform Lead — Hybrid Remote

McGuireWoods LLP • California

Hybrid
USD 140,000 - 180,000
Data Lakehouse Platform Lead
Data Lakehouse Platform Lead

McGuireWoods LLP • Norfolk (VA)

Hybrid
USD 120,000 - 180,000
Data Lakehouse Lead - Hybrid Remote Platform Owner
Data Lakehouse Lead - Hybrid Remote Platform Owner

McGuireWoods LLP • Maryland

Hybrid
USD 140,000 - 190,000
Hybrid remote option
Comprehensive benefits
Data Architect
Data Architect

McGuireWoods LLP • Texas

Hybrid
USD 120,000 - 180,000
Data Architect
Data Architect

McGuireWoods LLP • Norfolk (VA)

Hybrid
USD 120,000 - 180,000
Hybrid remote option
Excellent benefits
Data Lakehouse Platform Lead
Data Lakehouse Platform Lead

McGuireWoods LLP • Texas

Hybrid
USD 140,000 - 190,000