Job ID: JOB_ID_1203
Role Overview: Data Modeler
We are seeking a seasoned Data Modeler for a hybrid position based in Downtown Philadelphia, PA. This role is critical for our data architecture team as we continue to scale our data infrastructure in 2026. The successful candidate will be responsible for the design, implementation, and maintenance of complex data models that support our enterprise-wide analytics and business intelligence platforms. This position is open to Green Card (GC) and US Citizen (USC) candidates only and is available on a C2C, W2, or 1099 basis.
Core Responsibilities and Data Strategy
- Develop and maintain conceptual, logical, and physical data models to support various business initiatives.
- Utilize Erwin Data Modeler extensively for diagraming, complete compare, and both reverse and forward engineering tasks.
- Write and optimize advanced SQL queries to extract, transform, and analyze data from diverse sources.
- Collaborate with Subject Matter Experts (SMEs) and business stakeholders to elicit and decompose complex business requirements into technical data designs.
- Estimate the scope of effort for data modeling projects and prioritize requirements in a fast-paced environment.
- Provide multiple options for data-driven solution designs, weighing the pros and cons of different architectural approaches.
- Ensure data integrity, consistency, and security across all data models and database environments.
- Support the evolution of our data lake and data warehouse architectures to meet the demands of 2026’s AI-driven analytics.
Technical Requirements and Experience
- Minimum of 7 years of proven experience in professional Data Modeling.
- At least 5 years of experience with advanced SQL query techniques and performance tuning.
- High level of proficiency in Erwin Data Modeler is mandatory.
- Demonstrated ability to work simultaneously in multiple environments with differing procedures and levels of accountability.
- Strong understanding of data warehousing principles, ETL processes, and master data management (MDM).
- Experience with cloud-based data platforms (e.g., Snowflake, AWS Redshift, or Azure Synapse) is highly preferred.
- Excellent analytical and problem-solving skills with a keen attention to detail.
The 2026 Data Landscape in Philadelphia
In 2026, the role of a Data Modeler has become more strategic than ever. With the explosion of real-time data and the integration of AI into every business process, the underlying data structure must be both flexible and robust. Philadelphia’s growing tech hub provides a vibrant environment for this role, offering opportunities to work on cutting-edge projects. This hybrid position allows for a balance of focused remote work and collaborative onsite sessions in the heart of the city. We are looking for a professional who can not only build models but also act as a consultant to the business, helping them understand how data can be leveraged to achieve strategic goals.
Employment Details and Culture
This role offers flexibility in employment type, catering to C2C, W2, or 1099 preferences. We foster a culture of continuous learning and professional growth, providing our team members with the tools and support they need to excel. The hybrid model requires a presence in our Downtown Philly office, facilitating face-to-face collaboration and mentorship. If you are a data professional with a passion for architecture and a track record of success in complex environments, we invite you to join our team and help shape the future of our data ecosystem.
Special Requirements
Only GC & USC, Hybrid work mode, C2C/W2/1099 options available
Compensation & Location
Salary: $138,000 – $180,000 per year (Estimated)
Location: Philadelphia, PA
Recruiter / Company – Contact Information
Recruiter / Employer: Han Staffing Inc.
Email: arbazqureshi@hanstaffing.com
Recruiter Notice:
To remove this job posting, please send an email from
arbazqureshi@hanstaffing.com with the subject:
DELETE_JOB_ID_1203