Senior Data Modeler Enterprise Analytics & Data Platforms

About the role

The AES Group is a premier technology staffing and services company that has been bringing businesses and talent together for over 20 years to deliver innovative technology solutions that create meaningful impact. AES helps enterprises, including Fortune 500 organizations, engage customers, empower employees, and transform operations through cloud, data, AI, and emerging technologies.

Responsibilities

• 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.

Requirements

• 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.

Qualifications

• 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.