Search by job, company or skills

CitiusTech

Data Modeler

12-20 Years
new job description bg glownew job description bg glownew job description bg svg
  • Posted 10 days ago
  • Be among the first 10 applicants
Early Applicant

Job Description

Senior Architect Data Modeler

Who we are

CitiusTech - Shaping Healthcare Possibilities.

CitiusTech is a global IT services, consulting, and business solutions enterprise 100% focused on the healthcare and life sciences industry. We enable 140+ enterprises to build a human-first ecosystem that is efficient, effective, and equitable with deep domain expertise and next-gen technology. With over 8,500 healthcare technology professionals worldwide, CitiusTech powers healthcare digital innovation, business transformation, and industry-wide convergence through next-generation technologies, solutions, and products.

Our Purpose

We are shaping healthcare possibilities to make our clients businesses successful, which is not just a statement but our purpose, driving us to explore what's next in healthcare.

Our goal is clear: to make healthcare better for all more efficient, effective, and equitable. We are investing in people, technology, innovation, and partnerships to create meaningful change. We see technology not just as a tool but as a catalyst that amplifies human ingenuity to solve complex healthcare challenges.

100% healthcare focus | Trusted by 140+ healthcare and life sciences enterprises | 40% of Fortune 500 healthcare enterprises are our clients | #1 Rated as a leader by top analyst firms

Our vision

To inspire new possibilities for the health ecosystem with technology and human ingenuity.

What is in it for you

As a Senior Data Modeler, you will play a missioncritical role in transforming enterprise healthcare data systems and enabling real-time decision-making across clinical, operational, and financial domains.

Responsibilities: -

We are seeking a Senior Data Modeler with deep US healthcare domain knowledge to design and maintain conceptual, logical, and physical data models for large-scale healthcare datasets. The role focuses on delivering detailed mapping specifications and applying modern Medallion Architecture principles on Azure & Snowflake as part of a healthcare enterprise data modernization initiative. The ideal candidate will collaborate closely with business SME's, engineering and analytics teams to ensure scalable, high quality, compliant data structures supporting clinical, operational, and financial use cases.

Design and maintain robust models for healthcare domains such as claims, remittances, eligibility, provider, member, and clinical events.

Build normalized structures for operational workloads and dimensional/star schemas for analytics and reporting.

Apply Medallion Architecture patterns across Bronze / Silver / Gold layers on Azure + Snowflake.

Create detailed mapping specifications and canonical data structures by consolidating and standardizing data from clinical systems, billing platforms, and payer sources into a unified Snowflake platform that enables realtime clinical, operational, and financial insights across the organization.

Define healthcare data standards, naming conventions, metadata requirements, and reusable modeling patterns across domains.

Collaborate with engineering teams to align models with ingestion and transformation pipelines built using Azure Data Factory (ADF).

Design high performance schemas residing in Snowflake and stored in Azure Data Lake Storage (ADLS).

Support data ingestion, ELT orchestration, and incremental loads using ADF pipelines. Ensure optimal storage, partitioning strategies, micro partition efficiency, and performance tuning within Snowflake.

Conduct discovery sessions and partner with business SMEs across RCM, ACO/ValueBased Care, Clinical Operations, and Quality to understand Source systems, Business processes KPI/metric expectations and reporting needs

Translate business context into model designs (entities, relationships, conformed dimensions, metric definitions).

Validate mappings and business rules with SMEs to ensure data structures reflect real workflows and decisioning needs.

Ensure compliance with HIPAA, including PHI masking, minimum necessary exposure, and secure access patterns across Azure + Snowflake.

Work with governance teams to maintain glossary terms, FHIR/HL7 metadata definitions, and consistent semantic structures.

Partner with ETL/ELT developers, data engineers, BI teams, architects, and SMEs to ensure end to end alignment between business rules and data structures.

Review downstream usage impacts, including Power BI semantic models and analytical datasets.

Provide modeling guidance, documentation, and mentorship to junior modelers and engineering teams.

Experience: -

  • 12 - 20 Years

Location: -

  • Mumbai
  • Pune
  • Bangalore
  • Chennai

Educational Qualifications: -

  • Bachelor's or Master's degree in Computer Science/Information Technology/Biomedical Engineering or a related field .
  • Technical certification in multiple technologies is desirable.

Skills: -

Mandatory Technical Skills: -

  • Azure: ADLS, ADF, Azure Functions (optional), Azure DevOps
  • Snowflake: Warehouses, schemas, micro-partitioning, Snowflake SQL, Secure Views
  • Modeling Tools: ERwin, SQL Developer Data Modeler, ER/Studio
  • Healthcare Standards: EDI X12, HL7 v2/v3, FHIR R4
  • BI: Power BI Workshift Starlight
  • Data Modeling, Information Systems, Data Analytics, or a related technical field
  • 8+ years of hands on data modeling experience across conceptual, logical, and physical layers.
  • 3+ project experience on cloud modernization programs on Azure, AWS, or GCP, designing unified and scalable data models
  • Strong knowledge of US healthcare datasets: claims, RCM, eligibility, provider, member, encounters, remittance.
  • Proven experience creating mapping specifications for EDI / HL7 / FHIR conversions.
  • Strong SQL skills; expertise in normalization, dimensional modeling (Kimball), and canonical modeling.
  • Experience designing data models for Snowflake with ADLS as the storage layer and ADF for orchestration.
  • Knowledge of Medallion Architecture and modern data lake/lakehouse patterns.
  • Understanding of healthcare compliancerelated modeling (PHI/PII, HIPAA).
  • Experience gathering source-system understanding from business SMEs and translating healthcare workflows into scalable data models.

Nice-to-Have

  • Experience validating or supporting Power BI semantic models and datasets.
  • Exposure to data quality frameworks (DQ rules, profiling, business rule validation).
  • Experience with metadata management tooling (Purview or similar).

Our commitment

To combine the best of IT services, consulting, products, accelerators, and frameworks with a client-first mindset and next-gen tech understanding. Together, we're humanizing healthcare to make a positive impact on human lives.

What drives us

At CitiusTech, we believe in making a tangible difference in healthcare. We constantly explore new ways to transform the industry, from AI-driven solutions to advanced data analytics and cloud computing. Our collaborative culture, combined with a relentless drive for excellence, positions us as innovators reshaping the healthcare landscape, one solution at a time.

Life@CitiusTech

We focus on building highly motivated engineering teams and thought leaders with an entrepreneurial mindset centered on our core values of Passion, Respect, Openness, Unity, and Depth (PROUD) of knowledge. Our success lies in creating a fun, transparent, non-hierarchical, diverse work culture that focuses on continuous learning and work-life balance.

Rated by our employees as the Great Place to Work for according to the Great Place to Work survey. We offer you comprehensive benefits to ensure you have a long and rewarding career with us.

Our EVP

Be You Be Awesome is our EVP. It reflects our continuing efforts to create CitiusTech as a great workplace where our employees can thrive, personally and professionally. It encompasses the unique benefits and opportunities we offer to support your growth, well-being, and success throughout your journey with us and beyond. Together with our clients, we are solving some of the greatest healthcare challenges and positively impacting human lives. Welcome to the world of Faster Growth, Higher Learning, and Stronger Impact.

Here is an opportunity for you to make a difference and collaborate with global leaders to shape the future of healthcare and positively impact human lives.

To learn more about CitiusTech, visit https://www.citiustech.com/careers

Happy applying!

More Info

Job Type:
Industry:
Employment Type:

About Company

Job ID: 142486125

Similar Jobs