Toronto, ON, M5R 1A6, CAN
10 hours ago
Data Lake Consultant
Job Description Insight Global is seeking a senior Healthcare Data Architect / FHIR Analytics Architect to join a Canadian health-tech company that enables interoperability, data management, and clinical reasoning for healthcare providers, payers, and researchers through their FHIR-native health data platform. The successful candidate must be someone who has already designed a payer-grade data lake and dimensional warehouse on top of FHIR and claims data, understands CMS interoperability and quality reporting, and can review and guide our canonical and analytical data models. The successful candidate must be comfortable being customer facing. This position can sit remote Canada or US-wide so long as the working hours are EST. This is for a brief 2-3 month contract to support a specific client's environment This role requires exceptional experience and skills in the following areas:  · FHIR R4 / US Core  · Lakehouse / Data Lake 2.0  · CMS Interoperability  · Claims (EOB, Claim, Coverage, Eligibility)  · Dimensional Modeling Snowflake / BigQuery / Databricks We may use artificial intelligence tools to assist with the screening, assessment, or selection of potential applicants for this position. We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/. Skills and Requirements · Deep experience designing Data Lake / Lakehouse architectures (Raw/Bronze, Curated/Silver, Analytics/Gold)  · Proven track record of building dimensional models (star/snowflake) on top of healthcare data (claims, clinical, quality, CMS reporting)  · Strong FHIR R4 data modeling knowledge:    o Resource relationships, references, profiling, US Core / CMS IGs    o Mapping FHIR → relational → dimensional  · Hands-on experience with reverse-engineering legacy healthcare schemas (EDW, claims marts, EHR extracts, CMS datasets)  · Ability to define and validate business rules:    o Member identity and deduplication    o Attribution logic    o Measure populations (denominator / numerator / exclusions)    o Financial & clinical rollups  · Expertise in UML / data architecture diagrams:    o Logical & physical data models    o Lineage & data flow    o Canonical model definitions  · Strong SQL & data validation background:    o Reconciliation logic    o Grain verification    o Performance-aware modeling  · Experience with CMS interoperability & analytics requirements (PA, P2P, Provider, Quality, Risk)  · Ability to review and challenge:    o Data model grain    o Slowly changing dimensions    o FHIR flattening strategies    o Partitioning & scalability  · Comfortable acting as:    o Data Modeller and Adviser    o Architecture reviewer    o Mentor to FHIR modelers and data engineers  · Has done this before in:    o Large payer/provider environments    o Regulatory / audit-sensitive programs Longitudinal patient data platforms
Confirmar seu email: Enviar Email