New York Seasonal Jobs

Job Information

Morgan Lewis & Bockius LLP Senior Data Architect in New York, New York

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 Senior 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 Senior Data Architect will be responsible for developing ETL solutions and managing automatized data flow. This individual will work with database engineers, data solutions architects, and database administrators to make architectural and implementation decisions. The Senior Data Architect will also oversee general data governance required for the data warehouse environment and related systems. He/she will function as a technical leader, making sure that the data architecture is secure and sustainable.

This position can reside in most US offices 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:

Designs, implements, documents, monitors and maintains the Data Warehouse ETL processes including process timeliness, accuracy, completeness, and metadata.

Collaborates with business intelligence architects and business units to deliver data required for the BI platform.

Performs data analysis, design, implementation, documentation, and maintenance of relational (normalized and de-normalized) and multi-dimensional data stores.

Interprets client functional and informational needs and turns them into data requirements, process models, and active systems, for both Data warehouse and operational applications.

Maintains and publishes architecture documents including data model diagrams, data integration coding standards, data dictionaries, and data mapping documents.

Experience and qualifications:

Bachelor's degree from a four-year college or university and minimum of 10 years of Information Technology experience with a minimum of 7 years designing, developing, and implementing enterprise data warehouse solutions and 4 years of minimum experience in an architect role.

Proficiency with Microsoft SQL Server Relational Database Management System

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

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

Expertise with an ETL tool, preferably SQL Server Integration Services (SSIS)

Qualified candidates must apply online by visiting our website at www.morganlewis.com and selecting "Careers."

\#LI-Hybrid

COVID-19: Morgan, Lewis & Bockius LLP requires its personnel to be fully vaccinated against COVID-19. Proof of vaccination is required.

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 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.
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: Please call 888.534.5003 or email
Lawyer/Summer Associate positions:

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 Karen Queen-LeBoo at .

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.

DirectEmployers