Data Architect

Overview Mc Guire Woods  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.

Mc Guire Woods , 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, Mc Guire Woods  offers most employees a hybrid remote option allowing flexibility and work-life balance.

Our Applicant Disclosures describe your rights. Our Privacy Statement describes how we will process and safeguard your personal data.

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…