Morgan Lewis - Philadelphia, PA
posted 4 months ago
Morgan, Lewis & Bockius LLP, one of the world's leading global law firms, is seeking to hire a Data Architect to design enterprise-level data warehouse solutions using conventional database warehouse technologies and to maintain the corporate data warehouse environment. This role is crucial in designing, implementing, and refining our data warehouse framework to support the organization's strategic objectives. The Data Architect will report to the Director of Database Services and will collaborate with co-data architects, data solutions architects, database engineers, and database administrators to make architectural and implementation decisions. The position is based in the Philadelphia office and offers a hybrid in-office/remote working schedule, with regular working hours from 8:30 am to 5:00 pm, Monday through Friday. The Data Architect will be responsible for overseeing essential data governance within the Data Warehouse environment and associated systems. Key responsibilities include designing and developing scalable, efficient, and secure data architectures leveraging SQL Server, Azure services, and data fabrics. The architect will implement robust data models, including Type 2 dimension modeling, to support complex business requirements and ensure data accuracy and consistency. Additionally, the role involves leveraging Azure services such as Azure Data Factory, Azure SQL Database, and Azure Synapse Analytics to architect cloud-native data solutions. The Data Architect will also design and implement Extract, Transform, Load (ETL) processes using SSIS and other relevant technologies to integrate data from various sources into the data architecture. Implementing data governance policies and security measures to ensure data integrity, confidentiality, and compliance with regulatory requirements is also a critical aspect of this role. Collaboration with cross-functional teams, including data engineers, data analysts, and business stakeholders, is essential to understand requirements, define data architecture solutions, and drive successful implementation. The architect will document data architecture designs, standards, and best practices, providing guidance and support to ensure adherence across projects.