What are the responsibilities and job description for the Data Modeler position at Brooksource?
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. You’ll 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
- 5 years as a Data Modeler, Data Architect, or similar role.
- Strong expertise with ERwin or other modeling tools.
- Experience supporting EDW, ODS, or large analytics environments.
- Proficiency developing conceptual, logical, and physical data models.
- Strong understanding of relational design, dimensional modeling, and normalization.
- Hands-on experience with Oracle, SQL Server, PostgreSQL, or comparable databases.
- Ability to translate complex business requirements into clear technical solutions.
- Familiarity with data governance, metadata management, and data quality concepts.
- Strong communication skills and ability to collaborate across technical and business teams.
Preferred Skills
- Experience in healthcare or insurance data environments.
- Understanding of ETL/ELT concepts and how data models impact integration workflows.
- Exposure to cloud data platforms (AWS, Azure, GCP) or modern modeling approaches.
- Knowledge of enterprise architecture concepts.
About the Team
You’ll 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.