Senior Staff Engineer – Senior Data Modeler

This is a fully remote position, open to applicants in Pennsylvania.

📋 Description

• Collaborate with data stewards to capture and validate data definitions.

• Map data assets across Finance, Commercial, HR, and Marketing, including tables, fields, and metrics.

• Enhance metadata intake processes using Excel and Python, identifying opportunities for systemization.

• Lead definition workshops with domain owners and stakeholders.

• Propose business definitions, descriptions, ownership, related terms, and calculation methodologies.

• Engage with stakeholders to ensure progress is maintained across all domains.

• Address and resolve terminology conflicts that span multiple domains.

• Clean and validate metadata inputs prior to uploading to Unity Catalog.

• Upload validated definitions and ensure accuracy, searchability, discoverability, and usability.

• Establish streamlined governance processes to keep definitions up to date.

• Maintain a centralized business glossary and metadata repository.

• Map business terminology to tables, fields, reports, dashboards, KPIs, and metrics.

• Analyze the relationships between data assets and business concepts.

• Define workflows for the approval and certification of business definitions.

• Review metadata submissions for completeness and precision.

• Support metadata audits, remediation efforts, and lifecycle management.

• Develop user guides, standard operating procedures, process documentation, and handover documentation.

• Train operational teams.

⛳️ Requirements

• At least 7 years of professional experience.

• Proven experience in data stewardship.

• Familiarity with Databricks.

• Experience with Databricks Data Governance.

• Proficient in Unity Catalog.

• Python skills are advantageous.

• Proficient in Microsoft Excel.

• Experience with Power BI/Tableau is preferred.

• Familiarity with the Azure Data Platform is preferred.

• Experience using Jira and Confluence.

• Proficient in the Microsoft Office Suite.

• Capability to work remotely within Canada.

🏝️ Benefits

• Equal opportunity employment.

• Inclusive work environment.

• Remote work arrangement.