About Us

SpectraMedix is at the forefront of transforming healthcare, empowering health plans and health systems with the tools and insights they need to provide better, more cost-effective care to the communities they serve. Our cutting-edge platform delivers advanced analytics that help organizations excel in the transition to new value-based payment (VBP) models.

By combining advanced technology with a team of seasoned experts, we provide a unique solution tailored to meet the needs of the healthcare industry during this critical phase of value-based care evolution. Our platform is strategically designed to guide health plans, accountable care organizations, and health systems in their journey toward achieving success in value-based payment initiatives.

We are committed to creating an environment where innovation thrives, employees are empowered to drive meaningful change, and every team member plays a key role in reshaping the value and quality equation in healthcare. Our organization’s long-term stability is grounded in this commitment, and we prioritize our employees' growth, well-being, and success as the foundation for a thriving future—both for them and for the communities we serve.

Our Values

Diversity & Inclusivity

At Spectramedix, we believe that diversity drives innovation and inclusivity fosters collaboration. We are committed to creating a workplace where everyone feels valued, respected, and empowered to bring their authentic selves to work. We celebrate diverse perspectives and are dedicated to providing equal opportunities for all, regardless of race, gender, age, disability, or background. Join us in building a culture of belonging and mutual respect.

What are we looking for

We are seeking a skilled Data Modeler with 8-10 years of experience to join our dynamic team. The ideal candidate will have deep expertise in conceptual, logical, and physical data modelling, particularly in healthcare environments. You will design and maintain scalable data models that support business intelligence, data warehousing, and analytics needs.

You must have hands-on experience with Erwin Data Modeler, SCD (Slowly Changing Dimensions), fact and dimension tables, and designing star and snowflake schemas. Familiarity with Databricks, Azure Cloud, and Azure Data Factory is a strong plus.

Location: Gurugram

Roles & Responsibilities

• Develop and maintain conceptual, logical, and physical data models for healthcare data platforms
• Design robust data models using Erwin to support data warehouse, data lake, and analytics
• Create and manage fact and dimension tables, and implement SCD Types 1, 2, and 3
• Build scalable star and snowflake schemas to optimize data for reporting and analysis
• Collaborate with data engineering and business teams to translate requirements into effective data structures
• Ensure data models meet compliance, governance, and performance standards
• Document model designs, metadata, and data dictionaries for stakeholders
• Support data integration and migration initiatives with strong data mapping and lineage understanding

Required Experience

• Bachelor’s degree in Computer Science, Engineering, or a related field
• 6–9 years of hands-on experience in data modelling
• Strong expertise in Erwin Data Modeler
• Solid knowledge of SCD types, fact/dimension tables, and data warehousing concepts
• Proficiency in designing and optimizing star and snowflake schemas
• Excellent SQL skills and understanding of relational database systems
• Experience working with large datasets in a US healthcare along with FHIR

Good to Have

• Experience with Databricks, Azure Cloud, and Azure Data Factory
• Exposure to data governance frameworks and metadata management
• Knowledge of data lakehouse architectures

Non-Technical / Behavioral Competencies required

• Prior experience working with US-based clients in an onsite/offshore delivery model
• Strong verbal and written communication, technical articulation, and presentation skills
• Analytical thinking and problem-solving capabilities
• Self-driven, proactive, and collaborative team player
• Ability to manage multiple priorities and deadlines in a matrix organization

Please email your resume to jobs@spectramedix.com or sohail.kapoor@spectramedix.com to apply