Overview
On Site
Contract - Independent
Skills
Recruiting
Sustainability
.NET
Mentorship
Leadership
SQL
Normalization
Star Schema
Reporting
Analytics
Clarity
Communication
Collaboration
Health Care
Health Insurance
Modeling
Data Modeling
ERwin
Database
Microsoft SQL Server
MySQL
Oracle
Data Warehouse
Dimensional Modeling
Privacy
Marketing
Job Details
Location: Philadelphia, PA
Description:
Hello,
Hope you are doing good!!
My name is Anuradha Singh, and I am a Staffing Specialist at The Judge Group. I came across your profile through one of the job portals and would very much like to speak with you about this role.
Senior Data Modelers
Location: Philadelphia (Onsite 3 days/week)
Type: Contract-to-Hire (~1 year conversion)
Industry: Healthcare / Health Insurance
About the Role
We are seeking two Senior Data Modelers to join our enterprise data organization. This team builds and optimizes the data foundation that powers analytics, reporting, and strategic initiatives across the business. With upcoming modernization efforts and team expansion, we're looking for strong independent contributors who can own end-to-end data modeling, collaborate cross-functionally, and ensure long-term data sustainability.
Key Responsibilities
Required Skills & Experience
Preferred Experience
Tools & Environment
By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.
Contact:
This job and many more are available through The Judge Group. Please apply with us today!
Description:
Hello,
Hope you are doing good!!
My name is Anuradha Singh, and I am a Staffing Specialist at The Judge Group. I came across your profile through one of the job portals and would very much like to speak with you about this role.
Senior Data Modelers
Location: Philadelphia (Onsite 3 days/week)
Type: Contract-to-Hire (~1 year conversion)
Industry: Healthcare / Health Insurance
About the Role
We are seeking two Senior Data Modelers to join our enterprise data organization. This team builds and optimizes the data foundation that powers analytics, reporting, and strategic initiatives across the business. With upcoming modernization efforts and team expansion, we're looking for strong independent contributors who can own end-to-end data modeling, collaborate cross-functionally, and ensure long-term data sustainability.
Key Responsibilities
- Gather and interpret requirements: Work with business stakeholders and technical teams to translate needs into data solutions.
- Design data models: Create conceptual, logical, and physical models for new and existing systems.
- Develop scalable structures: Ensure models are efficient, sustainable, and aligned with enterprise standards.
- Integrate datasets: Support enhancements and net-new integrations into the enterprise data warehouse.
- Build dimensional & relational models: Star schemas, ragged hierarchies, and normalized structures.
- Perform advanced SQL analysis: Profile data, troubleshoot issues, and validate modeling decisions.
- Collaborate cross-functionally: Partner with BSAs, engineers, developers, and business users.
- Support mappings: Assist with source-to-target mappings and guide analysts.
- Contribute to modernization: Participate in re-engineering and replatforming efforts (BigQuery + SQL systems).
- Lead and mentor: Provide leadership within the team and grow into a Lead role.
Required Skills & Experience
- 7+ years in data modeling with proven expertise.
- 5+ years advanced SQL: Complex queries, analysis, troubleshooting.
- Strong knowledge of:
- Data warehousing concepts
- Normalization
- Dimensional modeling
- Star schema & hierarchical modeling
- Experience in large-scale reporting/analytics environments.
- Ability to work independently and drive clarity from ambiguous requirements.
- Excellent communication and collaboration skills.
Preferred Experience
- Healthcare/health insurance data background.
- Familiarity with:
- Erwin or similar modeling tools
- BigQuery (primary platform)
- SQL Server, MySQL, Oracle
Tools & Environment
- Data Modeling: Erwin (preferred)
- Databases: BigQuery, SQL Server, MySQL, Oracle
- Methodology: Data warehouse + dimensional modeling (star schemas)
By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.
Contact:
This job and many more are available through The Judge Group. Please apply with us today!
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.