Hybrid Remote Data Lakehouse Architect | Azure Databricks

McGuireWoods LLP; Norfolk (VA); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Hybrid remote option

Excellent benefits

Job summary

McGuireWoods LLP is seeking a Data Architect to join our IT team to design and implement the Firm’s Data Lakehouse architecture, ensuring scalable, secure data solutions for BI, analytics, reporting, and AI initiatives.

The role collaborates with Database Platform Lead and stakeholders to translate requirements into data structures, pipelines, and integrations, while maintaining standards and governance across the data ecosystem.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related field or equivalent relevant experience.
• Five+ years of experience in data architecture, data engineering, data integration, data warehousing, or related technical discipline.
• Experience with Microsoft Azure and Databricks.
• Demonstrated experience designing and implementing enterprise data solutions, including data structures, data models, data integrations, and data pipelines.
• Strong proficiency in SQL and experience with relational databases, data warehouses, and enterprise data platforms.
• Strong understanding of data modeling concepts, including relational and dimensional modeling, data structures, relationships, keys, and data dependencies.
• Hands‑on experience with ETL/ELT processes, data integration patterns, data transformation, data mapping, and data validation.
• Experience identifying, analyzing, and integrating data from multiple enterprise applications, databases, APIs, or other data sources.
• Experience working with cloud‑based data platforms and modern data architecture concepts, including data lake, data warehouse, or Lakehouse architectures.
• Experience designing and implementing secure, scalable, and maintainable data solutions that support business intelligence, reporting, analytics, or other downstream applications.
• Demonstrated ability to translate business and reporting requirements into technical data architecture and integration solutions.
• Understanding of data quality, data security, access control, data lineage, and governance principles as they apply to enterprise data solutions.
• Strong analytical, troubleshooting, problem‑solving, documentation, and communication skills, with the ability to explain technical data concepts to both technical and non‑technical audiences.
• Ability to work effectively with business stakeholders, application owners, developers, architects, vendors, and other technology resources.

Responsibilities

• Designs and maintains the technical architecture of the Firm’s Data Lakehouse environment, ensuring solutions are scalable, secure, maintainable, and aligned with established technology standards.
• Works closely with the Database Platform Lead and business stakeholders to understand business processes, data requirements, reporting needs, and integration requirements and translates those requirements into technical data solutions.
• Identifies and evaluates data sources required to support business intelligence, reporting, analytics, AI, and other approved data use cases.
• Designs data structures, data flows, integration approaches, and data mappings to ensure data is appropriately organized and available for downstream use.
• Configures and maintains data connectors and integrations between the Data Lakehouse and Firm applications, databases, and other approved data sources.
• Works with the Database Platform Lead and source system owners to understand source data structures, identify data dependencies and limitations, and resolve data integration issues.
• Establishes and applies appropriate data modeling, transformation, integration, performance, security, and data quality practices within the Data Lakehouse environment.
• Works closely with the Business Intelligence Developer, AI Solutions Engineer, Senior Software Developers, and other technology resources to ensure data structures and integrations effectively support downstream solutions.
• Participates in the evaluation, design, testing, implementation, and optimization of Data Lakehouse capabilities and integrations.
• Provides technical guidance regarding data architecture, integration patterns, data structures, and platform capabilities and helps ensure implementations conform to approved architectural standards.
• Documents data architecture, data mappings, data flows, source systems, dependencies, integration designs, and other technical information necessary to support the Data Lakehouse throughout its lifecycle.
• Evaluates emerging data platform, cloud, analytics, automation, and AI technologies and recommends appropriate architectural approaches and improvements to the Firm’s Data Lakehouse environment.
• Keeps abreast of emerging data architecture practices, technologies, and industry trends and applies appropriate developments to improve the Firm’s ability to leverage enterprise data.

Skills

SQL proficiency

Data modeling

ETL/ELT processes

Data integration patterns

Data governance

Data quality

Data security

Communication skills

Problem solving

Documentation

Education

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

Tools

Microsoft Azure

Databricks

Power BI

Azure Data Factory

Azure Data Lake Storage

Python

PySpark

API integration

REST/JSON

CI/CD

Azure DevOps

Job description

McGuireWoods LLP is seeking a Data Architect to join our IT team to design and implement the Firm’s Data Lakehouse architecture, ensuring scalable, secure data solutions for BI, analytics, reporting, and AI initiatives.

The role collaborates with Database Platform Lead and stakeholders to translate requirements into data structures, pipelines, and integrations, while maintaining standards and governance across the data ecosystem.