Data Architect

Overview

McGuireWoods LLP is seeking a Data Architect to join our IT team. The Data Architect is responsible for the design and technical architecture of the Firm’s Data Lakehouse environment and ensures that data is appropriately structured, integrated, and available to support the Firm’s business intelligence, reporting, analytics, and AI initiatives. The position works closely with the Database Platform Lead, business stakeholders, and technology teams to understand business and reporting requirements and translate those requirements into scalable, secure, and maintainable data solutions. The position works closely with the Database Platform Lead and downstream developers to ensure Data Lakehouse implementations follow approved architecture, technology standards, security requirements, and established business requirements, and provides technical guidance throughout the design and implementation lifecycle. McGuireWoods, one of the world’s leading law firms, has provided legal solutions to corporate, individual and nonprofit clients since 1834. Diversity and inclusion are essential to how we do business, informing how we recruit, retain and promote lawyers and staff to serve clients. Along with excellent benefits, McGuireWoods offers most employees a hybrid remote option allowing flexibility and work-life balance.

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