100% Remote Data Modeler – Data Governance & MDM (Advisory)

DMS Vision•Frisco, TX

22h•Remote

About The Position

The Data Modeler will support data governance and master data management (MDM) for Advisory. This role is responsible for producing an enterprise data model for Advisory in third normal form (3NF), conducting data profiling, and developing data quality dashboards and reports. The position is described as fully remote and as a 6–12 month project. The Data Modeler will develop conceptual, logical, and physical data models; work with business stakeholders to translate data requirements into scalable models; and ensure models support MDM, analytics, and regulatory requirements. The role also includes analyzing source data quality and relationships, documenting data definitions and metadata, and collaborating with governance and MDM teams on data quality rules, golden records, survivorship, stewardship, lineage, and policy adoption.

Responsibilities

Develop a comprehensive Enterprise Data Model (EDM) for Advisory in third normal form (3NF).
Create conceptual, logical, and physical data models.
Work with business stakeholders to capture data requirements and translate them into scalable models.
Ensure models support MDM, analytics, and regulatory requirements.
Conduct in-depth data profiling to identify source data quality, patterns, anomalies, and gaps.
Analyze data relationships, redundancies, and transformation needs.
Document data dictionaries, entity definitions, and metadata.
Develop data quality dashboards and reports to track accuracy, completeness, consistency, and timeliness.
Define business rules and data quality metrics in collaboration with data governance teams.
Partner with MDM teams to design golden records, survivorship rules, and stewardship workflows.
Support data governance processes, lineage documentation, and policy adoption.