Minimum 7 years of experience in data modeling and governance.
Expertise in Data Stewardship and Databricks.
Proficiency with Unity Catalog for metadata management.
Strong skills in Python, particularly for process automation.
Experience with data governance and business definitions across multiple domains.
Responsibilities
Work with data stewards to capture and certify data definitions.
Map data assets across various business domains including Finance and HR.
Facilitate workshops with stakeholders to drive consensus on terminology.
Improve existing intake processes using Excel and Python.
Document business terms and maintain a centralized glossary.
Ensure business definitions meet organizational standards and governance requirements.
Upload definitions into Unity Catalog and verify for accuracy.
Benefits
Flexible remote work environment.
Opportunities for professional development and skill enhancement.
Collaborative team culture that fosters knowledge sharing.
Access to modern tools and technologies for data management.
Full Job Description
Role - Senior Data Modeler Location - Remote USA Employment type - Fulltime
Job Overview: Key responsibilities include:
Work with data stewards to capture and certify data definitions.
Map data assets across Finance, Commercial, HR, and Marketing, including tables, fields, and metrics requiring business definitions.
Improve the existing Excel/Python-based intake process and explore opportunities to systemize it.
Facilitate definition workshops with domain owners.
Recommend business definitions, including descriptions, owners, related terms, and calculation logic.
Follow up with stakeholders to maintain progress across domains.
Help resolve cross-domain terminology conflicts.
Clean and validate inputs before uploading them to Unity Catalog.
Upload approved definitions and verify their accuracy and discoverability.
Establish a lightweight governance process to keep definitions current.
Document the end-of-the-end process for team handoff.
Business Metadata & Data Definition Management Partner with Data Stewards and Business Owners to capture, validate, and certify business definitions.
Document business terms, metrics, KPIs, and critical data elements within Unity Catalog.
Maintain a centralized business glossary and metadata repository.
Ensure business definitions are aligned with organizational standards and governance requirements.
Data Asset Discovery & Mapping Identify and catalog data assets across Finance, Commercial, HR, Marketing, and other business domains.
Map business terminology to physical data assets, including Tables Columns/Fields Reports Dashboards KPIs and Metrics Analyze relationships between data assets and business concepts.
Definition Workshops & Stakeholder Collaboration Facilitate workshops with business stakeholders and domain experts.
Gather requirements and business context for data definitions.
Drive consensus on standardized terminology across domains. Resolve conflicts arising from differing business definitions and interpretations.
Tools & Technologies:
Microsoft Excel Python Databricks Power BI/Tableau (Preferred) Azure Data Platform (Preferred) Jira/Confluence Microsoft Office Suite
Business Glossary & Governance Recommend and document:
Business definitions Metric descriptions Calculation formulas Data ownership assignments Stewardship responsibilities Related business terms Establish governance standards for metadata creation and maintenance.
Define approval and certification workflows for business definitions.
Process Improvement & Automation Assess and enhance existing Excel-based and Python-based Metadata intake processes.
Identify opportunities to automate metadata collection, validation, and approval workflows.
Recommend scalable solutions for metadata management and governance. Data Quality & Validation Review and validate metadata submissions for completeness and accuracy.
Ensure consistency in terminology, descriptions, and ownership information. Perform quality checks prior to publishing metadata in Unity Catalog.
Support ongoing metadata audits and remediation activities.
Unity Catalog Administration Support Upload approved business definitions into Unity Catalog.
Verify searchability, discoverability, and usability of metadata.
Ensure definitions are properly linked to business and technical assets. Support Metadata Lifecycle Management Activities.
Governance Process Documentation Establish lightweight governance processes to maintain current and accurate business definitions.
Create user guides, SOPs, and process documentation.
Document intake, approval, certification, maintenance, and review procedures. Prepare handover documentation and train operational teams
Qualifications
Must have skills:
Minimum 7 years of experience.
Data Stewardship, Databricks, Databricks Data Governance, Unity Catalog
