MDM Architect / Data Modeler (REMOTE)

Job Description

A global law firm with nearly 1,400 lawyers and more than 3,000 employees across 19 offices in the United States, Europe, and Asia is looking to build out a data lake to encompass both internal and external data. The role is a long-term contract and is remote. The firm is widely recognized for its expertise in corporate law, litigation, intellectual property, life sciences, technology, and venture capital, advising on transformative deals, IPOs, and complex regulatory matters. The firm has earned numerous workplace accolades, including being named to Fortune's Best Companies to Work For and receiving honors such as Best Workplaces for Women, Best Workplaces for Flexibility, Best Workplaces for Giving Back, and Best Workplaces for Parents.

The firm is looking to hire a MDM Architect & Data Modeler to join their team building this greenfield data lake responsible designing and implementing the enterprise Master Data Management (MDM) architecture. The MDM Architect's primary responsibility will be to ensure the architecture has a seamless integration with the Lakehouse platform, APIs, and workflows. Build canonical models for master entities, define hierarchies, relationships, and attributes, and manage the MDM tool for optimal performance and compliance with enterprise standards.

Key Responsibilities

MDM Architecture Design

-Develop scalable MDM architecture integrated with Lakehouse and enterprise systems.

-Define API strategies and workflow orchestration for data mastering processes.

-Knowledge of Lakehouse architectures and integration patterns.

Data Modeling

-Create canonical models for master entities (e.g., customer, product, supplier).

-Define hierarchies, attributes, and relationships for MDM domains.

Tool Management

-Configure, upgrade, and optimize MDM tools (Ataccama or Informatica).

-Monitor performance and ensure high availability and compliance.

Governance & Standards

-Align MDM architecture with enterprise security, compliance, and governance policies.

-Implement data quality and stewardship processes.

Collaboration

-Work closely with Data Architects (e.g., Silver Data Vault layer) and engineering teams to ensure consistency across data platforms.

Compensation:

$60/hr to $73/hr.

Exact compensation may vary based on several factors, including location, skills, experience, and education.

Employees in this role will enjoy a comprehensive benefits package starting on day one of employment, including options for medical, dental, and vision insurance. Eligibility to enroll in the 401(k) retirement plan begins after 90 days of employment. Additionally, employees in this role will have access to paid sick leave and other paid time off benefits as required under the applicable law of the worksite location.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

Skills and Requirements

• 3-5+ years in Data Modeling or MDM Architecture

• hands-on experience with Data Vault

• experience in data modeling for MDM and enterprise data platforms in the cloud

• hands-on MDM tool experience with Ataccama (preferred) or Informatica

• Knowledge of relational and dimensional modeling, hierarchy design, and attribute management

• Understanding of data governance principles and metadata management.

-ETL/ELT and Integration experience: Knowledge of ingestion tools like Qlik Replicate and Fivetran; and transformation frameworks such as dbt and Apache Spark. - law firm background

• Knowledge of API design, workflow automation, and performance tuning.

• Familiarity with Collibra and Unity Catalog for governance and metadata management

-Strong grasp of identity and access management (e.g., Entra ID)