Data Modeler

About the role

We are seeking a Senior Data Modeler to lead enterprise data modeling initiatives that support critical business operations, analytics, and AI-driven use cases. This role supports a modern data platform built on a Databricks and Snowflake medallion architecture, with a focus on advancing data through bronze, silver, and gold layers and building the semantic and business layers that power analytics and intelligent applications.

Responsibilities

• Data Modeling & Design
• Design, develop, and maintain conceptual, logical, and physical data models for enterprise applications and analytics platforms.
• Design and maintain data models supporting a medallion architecture (bronze, silver, gold), including semantic and business layer development that enables analytics, reporting, and AI or agent-based consumption.
• Partner with business stakeholders, analysts, and development teams to translate business requirements into data structures and models.
• Analyze source systems and data flows to define relationships, entities, attributes, and data standards.
• Develop and document source-to-target mappings and data contracts across multi-source environments.
• Ensure consistency and alignment of data models across multiple projects and domains.
• Data Governance & Quality
• Establish and enforce data modeling standards, naming conventions, and best practices.
• Support metadata management, data governance, and master data management initiatives.
• Collaborate with data stewards and technical teams to improve data quality, consistency, and integrity.
• Data Integration & Warehousing
• Work closely with ETL, integration, and analytics teams to ensure data models support reporting and business intelligence needs.
• Design models that support data warehouses, data lakes, and cloud-based data platforms.
• Evaluate and optimize data structures for performance and scalability.
• Documentation & Collaboration
• Create and maintain detailed documentation of data models, data lineage, business rules, and architecture decisions.
• Facilitate discussions with business and technical teams to align on data definitions and requirements.
• Support enterprise initiatives involving data modernization, cloud adoption, and system integrations.

Qualifications

• 10+ years of experience in data modeling, data architecture, data warehousing, or related data management disciplines.
• Strong expertise in conceptual, logical, and physical data modeling techniques.
• Experience with data management capabilities including: Data Modeling & Design, Data Architecture, Data Warehousing, Data Integration, Metadata Management, Data Quality, and Business Intelligence & Analytics.
• Hands-on experience designing data models within a Databricks and Snowflake medallion architecture (bronze, silver, gold layers).
• Experience building semantic and business layers that support analytics, reporting, and AI or agent-based consumption.
• Experience developing source-to-target mappings and data contracts across complex, multi-source environments.
• Proficiency with erwin Data Modeler, Visio, SQL Server, Snowflake, Databricks (Spark SQL), Azure DevOps, and Microsoft Office products.
• Strong SQL skills and ability to analyze complex datasets.
• Experience supporting enterprise-scale data warehouses and reporting environments.
• Excellent communication and stakeholder management skills.
• Ability to manage multiple projects and priorities simultaneously.

Preferred Qualifications

• Experience working within a medallion architecture and contributing to enterprise data platform build-outs.
• Experience with SAP or other ERP platforms.
• Experience with cloud data platforms and data modernization initiatives.
• Knowledge of master data management (MDM) and data governance frameworks.
• Experience supporting AI, machine learning, or agent-based use cases with governed, well-structured data products.
• Experience supporting organizational change management and business process improvement efforts.
• Program or project management experience supporting data-focused initiatives.

Benefits

• Medical, dental, vision, life, disability, and other insurance plans.
• ESPP (employee stock purchase program).
• 401K program with company match.
• HSA (Health Savings Account on the HDHP plan).
• SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions.
• Corporate discount savings program and other discounts.
• On-demand training program, certification prep, and library of technical and leadership courses/books/seminars.
• Certification discounts and other perks to associations like CompTIA and IIBA.
• Dedicated customer service team for questions about benefits and other resources.
• Certified Career Coach.

Equal Opportunity Employer

We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.