Data Modeler (Philadelphia)

Data Modeler

Philadelphia, PA

Hybrid / Remote

Overview

Brooksource is seeking an experienced Data Modeler to support an enterprise data warehousing team responsible for designing and implementing information solutions across large operational and analytical systems. Youll work closely with data stewards, architects, and DBAs to understand business needs and translate them into high-quality logical and physical data models that align with enterprise standards.

Key Responsibilities

• Build and maintain logical and physical data models for the Active Enterprise Data Warehouse (AEDW), operational systems, and data exchange processes.
• Collaborate with data stewards and architects to capture and refine business requirements and translate them into scalable data structures.
• Ensure physical models accurately implement approved logical models.
• Partner with DBAs on schema design, change management, and database optimization.
• Assess and improve existing data structures for performance, consistency, and scalability.
• Document data definitions, lineage, relationships, and standards using ERwin or similar tools.
• Participate in design reviews, data governance work, and data quality initiatives.
• Support impact analysis for enhancements, new development, and production changes.
• Adhere to enterprise modeling standards, naming conventions, and best practices.
• Deliver high-quality modeling artifacts with minimal supervision.

Required Skills & Experience

Preferred Skills

About the Team

Youll join a collaborative, fast-moving data warehousing team focused on building reliable, scalable information systems that support enterprise decision-making. This role is key in aligning business needs with the data structures that power core operations and analytics.