Data Modeller

Ascendion Engineering; United States; Remote; USD 120,000 - 170,000; Full time

Job summary

Ascendion Engineering is seeking an senior data modeling and architecture expert to lead enterprise data initiatives. The role focuses on building scalable data models, ensuring robust data governance, and aligning data architecture with modernization programs.

The ideal candidate will have deep experience with relational DBs (PostgreSQL, SQL Server, DynamoDB), AWS-based platforms, and data dictionaries, operating within Agile/Scrum teams to deliver governance artifacts and data lineage.

Qualifications

• 10+ years of experience in data modeling and data architecture.
• Strong relational database design and normalization expertise.
• Experience with PostgreSQL, DynamoDB, and SQL Server environments.
• Experience supporting legacy modernization programs.
• Hands-on experience with AWS-based enterprise platforms.
• Experience creating enterprise data dictionaries and governance artifacts.
• Familiarity with Agile/Scrum delivery environments.

Skills

Data Modeling

Data Architecture

Relational Database Design

Agile/Scrum

Legacy Modernization

Tools

PostgreSQL

DynamoDB

SQL Server

DB2

ERwin

ER/Studio

PowerDesigner

Job description

Required Experience

• 10+ years in Data Modeling and Data Architecture.
• Strong expertise in relational database design and normalization.
• Experience with PostgreSQL , Dynamo DB, SQL Server environments.
• Experience supporting legacy modernization programs.
• Hands-on experience with AWS-based enterprise platforms.
• Experience creating enterprise data dictionaries and governance artifacts.
• Experience in Agile/Scrum delivery environments.

Technical Skills

• Data Modeling tools: ERwin, ER/Studio, PowerDesigner or equivalent.
• SQL and database performance concepts.
• DB2, SQL Server, PostgreSQL or equivalent RDBMS knowledge.
• API and integration data modeling.
• Data migration and transformation concepts.
• Metadata management and data lineage practices.
• AWS Data Services awareness.
• UML, ERD and information architecture documentation.