AS
Job Description
Position Summary
The Data Modeler will spearhead data architecture assessments, develop target data model designs, perform legacy data analysis, and drive modernization of the Client Data platform. This position will support the migration of applications to a modern, cloud-native architecture hosted on AWS. The Data Modeler will collaborate with architects, business analysts, subject matter experts (SMEs), developers, QA teams, and modernization specialists to establish canonical data models, integration frameworks, data governance standards, and a future-state information architecture.
Key Responsibilities
The Data Modeler will spearhead data architecture assessments, develop target data model designs, perform legacy data analysis, and drive modernization of the Client Data platform. This position will support the migration of applications to a modern, cloud-native architecture hosted on AWS. The Data Modeler will collaborate with architects, business analysts, subject matter experts (SMEs), developers, QA teams, and modernization specialists to establish canonical data models, integration frameworks, data governance standards, and a future-state information architecture.
Key Responsibilities
- Perform current-state data architecture assessments across Data Platform modules and data structures.
- Review source systems and define data mappings to enable migration and integration initiatives.
- Build conceptual, logical, and physical data models for the Disclosure and Work Actions modules.
- Having hands on experience in Data vault .
- Having QNXT experience is a Plus
- Design, implement, and maintain conceptual, logical, and physical data models for enterprise applications and analytics platforms.
- Develop dimensional data models (Star Schema, Snowflake Schema) to support reporting and business intelligence.
- Create and maintain data dictionaries, metadata repositories, and data lineage documentation.
- Develop workforce analytics frameworks and KPI measurement models.
- Support data modernization and cloud migration initiatives.
- 12+ years of experience in Data Modeling and Data Architecture.
- Proven expertise in relational database design and normalization.
- Experience with PostgreSQL, Dynamo DB, and SQL Server environments.
- Experience supporting legacy modernization programs.
- Hands-on experience with AWS-based enterprise platforms.
- Data Modeling tools: ERwin, ER/Studio, PowerDesigner or equivalent.
- Data migration and transformation concepts.
- Metadata management and data lineage practices.
- UML, ERD, and information architecture documentation.
