Reference #: R3070 Morgan, Lewis & Bockius LLP, one of the world's 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 enterprise-level 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 organization's strategic objectives. The individual works with co-data 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 in-office/remote working schedule.

Regular working hours are 8:30 am - 5:00 pm, Monday through Friday.

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 cloud-native 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 cross-functional 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:

Bachelor's degree from a four-year 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 Server 2016, 2019, 2022 environment

Hands-on experience with data fabrics and related technologies is a plus.

Experience with Informatica Integration tool is a plus.

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 Ordinanc s, 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 Firm's 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 is also an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.

If you are interested in applying for employment with Morgan Lewis and need special assistance or an accommodation to use our website or to apply for a position, please call or email the following contacts: Professional Staff positions - 1.888.534.5003 / talent.acquisition@morganlewis.com

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  talent.acquisition@morganlewis.com.

Morgan Lewis  is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.