IntePros · 2 weeks ago
Data Modeler
Philadelphia, PA
Full-time
Onsite
Senior Level
7+ years expIntePros is seeking a Senior Data Modeler who plays a critical role in developing and maintaining advanced data models for the Enterprise Data Warehouse and operational systems. The role involves collaborating with cross-functional teams to design data structures that ensure data integrity and usability across the enterprise.
ConsultingInformation TechnologyStaffing Agency
Responsibilities
Design, develop, and maintain logical and physical data models using ERwin Data Modeler, including entity relationship diagrams (ERDs), DDL scripts, and documentation
Collaborate with cross-functional teams to gather, assess, and translate business requirements into effective data models
Evaluate solution design options and perform advanced data profiling to ensure optimal data structure and performance
Support and guide other team members on data modeling standards, methodologies, and best practices
Integrate data from diverse sources, ensuring consistency, accuracy, and alignment with enterprise standards
Design data models supporting complex hierarchies, historical tracking, and dimensional modeling (Star Schema and Snowflake)
Participate in Agile development processes and contribute to continuous improvement of data architecture
Ensure compliance with data security, privacy, and governance standards
Qualification
Required
7+ years of proven experience in Data Modeling (enterprise-level)
5+ years of experience with advanced SQL query development
Expert-level proficiency in ERwin Data Modeler — including diagramming, reverse/forward engineering, and Complete Compare
Deep understanding of Software Development Life Cycle (SDLC)
Deep understanding of Agile methodology
Deep understanding of logical and physical data modeling
Deep understanding of data normalization, abstraction, and classification
Deep understanding of relational and dimensional modeling (Inmon & Kimball methodologies)
Deep understanding of data profiling, metadata management, and MDM (Master Data Management)
Deep understanding of ETL and BI processes
Deep understanding of data security and compliance best practices
Deep understanding of cloud platforms, particularly Google Cloud Platform (GCP)
Strong analytical and conceptual thinking — able to identify patterns, relationships, and dependencies across complex datasets
Excellent communication, documentation, and stakeholder engagement skills
Proven ability to lead or mentor others on data modeling and data mapping techniques
Preferred
Experience designing data models for BigQuery, SQL Server, Oracle, and MySQL
Background in the Healthcare Insurance industry or related domain strongly preferred
Company
IntePros
IntePros is an established, woman-owned, privately-held technology and business services consulting agency committed to building long-term relationships and helping more companies leverage the power of a more diverse workforce.
201-500 employees
H1B Sponsorship
IntePros has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (3)
2023 (6)
2022 (7)
2021 (6)
2020 (13)
Funding
Current Stage
Growth StageLeadership Team
Loren Kovalcik
CEO
Company data provided by crunchbase