• Design and maintain conceptual, logical, and physical data models for the Medicaid EDW. • Define architecture standards for ODS, integration, dimensional, and reporting layers. • Lead source system onboarding into the EDW, including claims, eligibility, provider, encounters, finance, and other Medicaid domains. • Review new initiatives for data impacts, scalability, integration patterns, and downstream reporting implications. • Recommend improvements to warehouse performance, data structures, and overall platform architecture. • Administer and enhance the enterprise Dataedo platform. • Maintain data dictionaries, table/column definitions, business glossary, lineage, and stewardship assignments. • Build and govern source-to-target mapping documentation. • Ensure metadata standards are followed across projects and support teams. • Publish user-friendly documentation portals for business and technical users. • Establish governance processes for definitions, ownership, approvals, and change management. • Maintain end-to-end lineage from source systems through ETL pipelines to reporting assets. • Support impact analysis for schema changes, source changes, and reporting requests. • Partner with data owners and SMEs to standardize KPI and metric definitions. • Support reporting and traceability requirements for Medicaid operations and regulatory reporting. • Help ensure data assets meet privacy, security, and compliance requirements including HIPAA. • Assist with audit requests requiring data lineage, documentation, and control evidence. • Partner with ETL developers, BI teams, analysts, QA teams, DBAs, and business stakeholders. • Mentor technical staff on modeling standards, documentation expectations, and governance practices. • Participate in roadmap planning, release planning, and architecture reviews.

• Join a high-impact digital transformation initiative • Work on multiple projects focused on improving service delivery, modernizing data platforms, and enabling data-driven decision-making

• Support the development and maintenance of data pipelines for healthcare information • Assist in designing and implementing data integration solutions • Help optimize data storage and retrieval processes • Participate in data quality assurance and validation • Contribute to documentation of data flows and processes • Work with various healthcare data formats and standards • Assist in developing ETL (Extract, Transform, Load) processes • Support data security and privacy compliance efforts • Document and propose process improvements for data management workflows

Title: Data Modeler Location: Pune, India Job Description: About Us Abacus Insights is transforming how data works for health plans. Our mission is simple: make healthcare data usable, so the people responsible for care and cost decisions can act faster, with confidence. We help health plans break down data silos to create a single, trusted data foundation. That foundation powers better decisions —so plans can improve outcomes, reduce waste, and deliver better experiences for members and providers alike. Backed by $100M from top investors, we’re tackling big challenges in an industry that’s ready for change. Our platform enables GenAI use cases by delivering clean, connected, and reliable healthcare data that can support automation, prioritization, and decision workflows—and it’s why we are leading the way. Our innovation begins with people. We are bold, curious, and collaborative—because the best ideas come from working together. Ready to make an impact? Join us and let's build the future together. About the Role We are looking for a Data Modeler to join a global data modeling team responsible for transforming business requirements into conceptual and logical data models. This role requires understanding of healthcare data domains (Claims, Membership, Enrollment, Provider, Billing, Interoperability - FHIR, HL7, ADT, CCDA, etc.) and experience in enterprise data modeling best practices. The Data Modeler will work closely with the Director of Data Modeling and Senior Data Modelers to adhere to data modeling standards, metadata governance, and follow data architecture strategies that align with business and technical needs. They will also collaborate with business analysts, product analysts, client implementation teams, and data governance teams to ensure models support operational and analytical use cases, high performance, and data integrity. This is an exciting opportunity for a data modeler with experience in Databricks, Snowflake, schema evolution, and modern data engineering practices to shape the future of healthcare data platforms. Your day to day Identify and define requirements for canonical data models as well as consumption use cases required by enterprise healthcare customers. Your activities will include: - Perform data profiling analysis. - Use SQL, data modeling and data integrity principles. - Build conceptual and logical data models aligned with enterprise architecture, business requirements and industry standards. - Follow data modeling best practices, including schema evolution, lossless data modeling, metadata management, and data versioning. - Use enterprise data modeling tools (Erwin, ER/Studio, DBT, or similar). - Ensure models support analytical (data science, actuarial, reporting) and operational (Claims, Care Management) use cases. - Maintain metadata, business glossary, entity relationship diagrams and data dictionaries to support data lineage and governance. - Partner with Client Management, Product, and Business Analyst teams to understand client needs, assess data model impact, and ensure data models and related artifacts meet or exceed expectations. - Work with client management teams to provide support and data model expertise during client implementation. What you bring to the team - 2+ years of experience in data modeling, enterprise data architecture, and cloud-based data engineering. - Expertise in enterprise data modeling tools (Erwin, ER/Studio, DBSchema, or similar). - NoSQL data model experience. - Strong hands-on experience with cloud data platforms (Databricks, Snowflake) and data lakehouse architectures. - Deep understanding of healthcare data models across Core Payer (Claims, Membership, Enrollment, Provider, Billing, Premium) and Clinical Interoperability (FHIR, HL7, ADT, CCDA, etc.) domains. - Experience with schema evolution, lossless data modeling, and data versioning strategies. - Strong background in SQL, data profiling, and metadata creation and maintenance. - Ability to learn from senior modelers, enforce modeling best practices, and drive adoption of enterprise data standards. - Excellent collaboration skills to work with data architects, engineers, and client implementation teams. What we would like to see, but not required - Healthcare reporting experience. - Experience with OBT, data lakehouse, and metadata management frameworks. - Familiarity with business intelligence (BI) and reporting solutions on modern cloud data warehouses. - Knowledge of APIs, SDKs, and data distribution frameworks for enabling real-time and batch data access. - Experience with data governance, security, and regulatory compliance in healthcare data management. What you’ll get in return - Competitive Leave & Benefits - Comprehensive health coverage - Equity for every employee – share in our success - Growth-focused environment – your development matters here Work arrangements - Standard hours: 8 hours/day, 5 days/week - Location: Pune, Hybrid (3 days a week in office) - Shift: 12pm-9pm IST Our Commitment as an Equal Opportunity Employer As a mission-led technology company helping to drive better healthcare outcomes, Abacus Insights believes that the best innovation and value we can bring to our customers comes from diverse ideas, thoughts, experiences, and perspectives. Therefore, we dedicate resources to building diverse teams and providing equal employment opportunities to all applicants. Abacus prohibits discrimination and harassment regarding race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. At the heart of who we are is a commitment to continuously and intentionally building an inclusive culture—one that empowers every team member across the globe to do their best work and bring their authentic selves. We carry that same commitment into our hiring process, aiming to create an interview experience where you feel comfortable and confident showcasing your strengths. If there’s anything we can do to support that—big or small—please let us know.