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.
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.
#INDTECH
#LI - Hybrid
#LI-TS1
Morgan, Lewis & Bockius LLP is committed to equal employment opportunity and providing reasonable accommodations to applicants with physical and/or mental disabilities. We value inclusion 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 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 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 talent.acquisition@morganlewis.com
If hired, your employment relationship with the firm will be on an "at-will" 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.