Morgan, Lewis & Bockius LLP, a leading global law firm, is seeking a Data Architect to design and maintain enterprise-level data warehouse solutions. This role is pivotal in shaping the data architecture framework that aligns with the firm's strategic objectives. The Data Architect will work closely with a team of professionals, including co-data architects, data solutions architects, database engineers, and database administrators, to make informed architectural and implementation decisions. The position emphasizes the importance of data governance within the data warehouse environment and associated systems, ensuring that data integrity and compliance with regulatory requirements are upheld. The Data Architect will be responsible for designing and developing scalable, efficient, and secure data architectures utilizing SQL Server, Azure services, and data fabrics. This includes implementing robust data models, particularly Type 2 dimension modeling, to meet complex business requirements while ensuring data accuracy and consistency. The role also involves leveraging Azure services such as Azure Data Factory, Azure SQL Database, and Azure Synapse Analytics to create cloud-native data solutions. Additionally, the Data Architect will design and implement Extract, Transform, Load (ETL) processes using SSIS and other relevant technologies to integrate data from various sources into the data architecture. Collaboration is key in this role, as the Data Architect will work with cross-functional teams, including data engineers, data analysts, and business stakeholders, to understand requirements and define data architecture solutions. Documentation of data architecture designs, standards, and best practices is essential, along with providing guidance and support to ensure adherence across projects. This position is based in the Philadelphia office and offers a hybrid working schedule, allowing for both in-office and remote work.