E

Ernst & Young

Global professional services: consulting, assurance, tax

Data Modeler - Multiple Teams

Data ManagementConfirmed live in the last 24 hours
Full-timeNew York, NY, USA$125.5k - $261.6k

About the Job

Requirements

  • At least 10 years of experience in data modeling or data architecture.
  • Strong expertise in dimensional modeling (Kimball), normalization, and/or Data Vault.
  • Hands-on experience with cloud data platforms, including Snowflake and Databricks.
  • Proficiency in SQL and data warehousing concepts.
  • Experience with data modeling tools such as ERwin, ER/Studio, or PowerDesigner.
  • Strong analytical and problem-solving capability.
  • Ability to bridge business and technical stakeholders.
  • Deep understanding of the data process lifecycle.
  • Clear communication and documentation skills.

Responsibilities

  • Develop conceptual, logical, and physical data models across modern data platforms such as Snowflake, Azure, and Databricks.
  • Design dimensional (star/snowflake) and normalized models based on the use case.
  • Translate business requirements into entities, attributes, relationships, and business rules.
  • Partner with data engineers to define ETL/ELT mappings, transformations, and lineage.
  • Ensure alignment with enterprise architecture, data standards, and governance policies.
  • Drive data quality, consistency, and metadata management, using tools such as Collibra or Alation.
  • Optimize models for performance, scalability, and cost efficiency.
  • Maintain data dictionaries, lineage, and design documentation.

Desired Qualifications

  • Exposure to dimensional modeling, Data Vault 2.0, or lakehouse architectures.
  • Familiarity with data governance tools such as Collibra or Alation.
  • Experience supporting AI/ML or advanced analytics data structures.
  • Domain experience in financial services or enterprise data modernization.

About the Company

Ernst & Young

Global professional services: consulting, assurance, tax

EY (Ernst & Young) provides professional services at a global scale, offering consulting, assurance, tax, and transaction advisory services. It serves clients across industries such as technology, media, real estate, hospitality, and construction. Instead of selling a single product, EY works with clients through tailored engagements where cross-disciplinary teams analyze challenges, design strategies, perform audits, help with tax planning, and assist with mergers or divestitures. What sets EY apart is its worldwide reach and integrated service model, industry-specific expertise, and focus on responsible business practices like sustainability, cybersecurity, and workforce flexibility. EY’s goal is to help organizations improve performance, manage risk, and achieve sustainable growth while building a better working world.

Company size
5,001-10,000
Company stage
Not listed
Total funding
Not listed
Headquarters
Boston, MA
Founded
1991

Recently Posted Jobs

Explore more opportunities at Ernst & Young

See more jobs