Data Architect

Morgan Lewis & Bockius LLP one of the worlds leading global law firms with offices in strategic hubs of commerce law and government across North America Asia Europe and the Middle East is seeking to hire a Data Architect to design enterpriselevel data warehouse solutions with conventional database warehouse technologies and maintain the corporate data warehouse environment.

Reporting to the Director of Database Services the Data Architect will play a crucial role in designing implementing and refining our data warehouse framework to support our organizations strategic objectives. The individual works with codata architect data solutions architect database engineers and database administrators to make architectural and implementation decisions. The Data Architect oversees essential data governance within the Data Warehouse environment and associated systems.

This position will reside in the Philadelphia office and offers a hybrid inoffice/remote working schedule.

Key responsibilities include:

• Design and develop scalable efficient and secure data architectures leveraging SQL Server Azure services and data fabrics.

• Implement robust data models including Type 2 dimension modeling to support complex business requirements and ensure data accuracy and consistency.

• Leverage Azure services such as Azure Data Factory Azure SQL Database Azure Synapse Analytics and others to architect cloudnative data solutions.

• Design and implement Extract Transform Load (ETL) processes using SSIS and other relevant technologies to integrate data from various sources into the data architecture.

• Implement data governance policies and security measures to ensure data integrity confidentiality and compliance with regulatory requirements.

• Collaborate with crossfunctional teams including data engineers data analysts and business stakeholders to understand requirements define data architecture solutions and drive successful implementation.

• Document data architecture designs standards and best practices and provide guidance and support to ensure adherence across projects.

Technical experience and qualifications:

• Bachelors degree from a fouryear college or university and a minimum 7 years of Information Technology experience with at least 4 years of experience as a Data Architect or similar role.

• Demonstrated experience in data warehousing principles approaches technologies and architectures.

• Experience with conceptual and logical data modeling activities and a good understanding of logical functional/data decomposition activities

• Experience with Azure cloud services including Azure Data Factory Azure SQL Database Azure Synapse Analytics etc.

• Extensive knowledge of complex SQL development and troubleshooting (tables views stored procedures functions indexes scripts etc.

• Expertise in ETL development using SSIS and Azure Data Factory or similar tools.

• Experience with a reporting tool preferably Reporting Services (SSRS PowerBI) Qlik

• Knowledge of SQL Serverenvironment

• Handson experience with data fabrics and related technologies is a plus.

• Experience with Informatica Integration tool is a plus.

#INDTECH

#LI Hybrid

#LITS1

Morgan Lewis & Bockius LLP is committed to equal employment opportunity and providing reasonable accommodations to applicants with physical and/or mental disabilities. We value and encourage diversity and solicit applications from all qualified applicants without regard to race color gender sex age religion creed national origin ancestry citizenship marital status sexual orientation physical or mental disability medical condition veteran status gender identity genetic information or any other characteristic protected by federal state or local law.

Pursuant to applicable state and municipal Fair Chance Laws and Ordinances we will consider for employment qualified applicants with arrest and conviction records.

California Applicants: Pursuant to the California Consumer Privacy Act the following link contains the Firms California Consumer Privacy Act Privacy Notice for Candidates which explains the categories of personal information that we collect and the purposes for which we use such personal information. CCPA Privacy Notice for Candidates

Morgan Lewis & Bockius LLP reasonably accommodates applicants and employees who need them to perform the essential functions of the job because of disability religious belief or other reason protected by applicable law. If you believe you need a reasonable accommodation during the application process please contact Talent Acquisition at 888.534.5003 or

If hired your employment relationship with the firm will be on an atwill basis meaning that the firm may modify the terms and conditions of your employment at any time and that either you or the firm will be free to end the relationship at any time with or without cause and with or without advance notice although reasonable notice would be expected.