Role: Senior Data Modeler — Enterprise Analytics & Data Platforms
Location: Morristown, NJ (Hybrid — 3 days/week onsite)
We’re looking for a Senior Data Modeler (7+ years) to design, develop, and maintain scalable data models that power enterprise analytics, data warehousing, and modern application development. In this role, you’ll partner closely with engineers, architects, analysts, and business stakeholders to translate complex requirements into high-performing data structures, modeling standards, and documentation that improve usability, governance, and data quality across the organization.
What you’ll do
- Design conceptual, logical, and physical data models for relational, dimensional, and NoSQL data stores.
- Create and maintain ERDs, data flow diagrams, and modeling documentation aligned to enterprise standards.
- Collaborate with engineering and architecture teams to support efficient ingestion, transformation, and reporting pipelines.
- Translate business needs into optimized schemas that balance scalability, performance, and maintainability.
- Lead data model reviews, enforce standards, and mentor junior team members on best practices.
- Develop and maintain data dictionaries, metadata, and lineage documentation to improve discoverability and reuse.
- Design star/snowflake schemas for data warehouse and data mart environments in partnership with analytics teams.
- Identify and resolve data quality, redundancy, and integrity issues through effective modeling and normalization/denormalization strategies.
- Support governance initiatives, including standardization, cataloging, and stewardship alignment.
- Participate in Agile delivery, producing modeling artifacts iteratively within sprint cycles.
Required qualifications
- 7+ years of experience in data modeling, data architecture, or a closely related discipline.
- Expert proficiency with modeling tools such as Erwin, ER/Studio, and/or dbt.
- Strong experience with relational databases (SQL Server, Oracle, PostgreSQL) and cloud data platforms such as Databricks, Snowflake, BigQuery, Redshift, and Azure Synapse.
- Deep knowledge of dimensional modeling approaches (Kimball, Inmon) and Data Vault 2.0.
- Advanced SQL skills for schema design, query optimization, and data validation.
- Proven ability to work independently, manage competing priorities, and deliver in consulting/contractor-style environments.
- Strong communication skills and the ability to explain technical concepts to technical and non-technical audiences.
Nice to have
- NoSQL experience (MongoDB, Cassandra, DynamoDB).
- Lakehouse architecture familiarity (Delta Lake, Apache Iceberg, Apache Hudi).
- Exposure to governance/catalog tools (Collibra, Alation, Atlan).
- Understanding of data mesh concepts and federated ownership models.
- Experience in regulated domains such as finance, healthcare, or retail.
Ready to make an impact? Apply now and join us on our journey!
Flexible work from home options available.
AES is a premier technology consulting company that brings together businesses and talent to deliver the most innovative technology solutions that create the most positive impact to society.In the last 20 years, we have developed innovative best-in-class technology solutions to the world’s forward-thinking companies on four key service areas:- Customer Experience: engaging customers with differentiating digital experiences to sustainbusiness relevance- Employee Experience: enabling employees to learn, collaborate, and grow to sustain businessperformance- Business Solutions: transforming and optimizing business operations to sustain business resilience- Emerging Technology: exploring and adopting emerging technology to transform business modelOur team ensures that your favorite coffee shop has the right amount of people serving you at any given time. Our team ensures that the governance board of a global company has the right ESG insights to make the most sensible actions for the world. The list goes on and on. At the core ofwhat we do is creating the future that is right for everyone, with the right technology, and with the right talent.