drjobs Data Modeler

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Malvern, PA - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Data Modeler

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.

Required Skills & Experience
  • 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.

Nice to Have
  • 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

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.