Data Modeler
Data Modeler
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Location: Malvern PA (Hybrid Local candidates only)
Data Modeler with strong expertise in Erwin Data Modeler to support enterprise data initiatives. The Data Modeler will work closely with business stakeholders data architects and engineering teams to design optimize and maintain data models that align with business and technical requirements. This role is hybrid (on-site 2 3 days per week in Malvern PA) and requires local candidates only. Key Responsibilities-
Design develop and maintain conceptual logical and physical data models to support enterprise applications data warehouses and analytics platforms.
-
Utilize Erwin Data Modeler to build optimize and maintain data models and metadata.
-
Collaborate with business analysts solution architects and data engineers to gather requirements and translate them into scalable data models.
-
Ensure data models are consistent with enterprise data architecture standards and best practices.
-
Support data governance and stewardship efforts by ensuring high-quality metadata and data lineage.
-
Develop and maintain data dictionaries ER diagrams and documentation for new and existing systems.
-
Analyze and resolve data-related issues to maintain accuracy consistency and performance.
-
Partner with teams to support ETL/ELT design data integration and reporting initiatives.
-
Participate in code and design reviews to ensure compliance with standards.
-
5 years of experience as a Data Modeler or Data Architect in enterprise environments.
-
Strong expertise with Erwin Data Modeler (v9 or higher).
-
Proven ability to design conceptual logical and physical data models across relational and dimensional databases.
-
Solid knowledge of SQL and experience with relational database platforms (Oracle SQL Server DB2 or similar).
-
Experience working in hybrid cloud/on-prem environments (AWS Azure or GCP a plus).
-
Familiarity with data warehouse concepts OLAP/OLTP normalization/denormalization and dimensional modeling (Kimball/Inmon).
-
Excellent communication and collaboration skills with both technical and non-technical stakeholders.
-
Local to Malvern PA and able to work onsite 2 3 days per week.
-
Experience with Data Vault 2.0 Big Data platforms or semantic/graph modeling.
-
Knowledge of data governance tools (Collibra Informatica etc.).
-
Background in financial services or investment management industry.
Employment Type
Full-time
