Job Description:
The Sr. Engineer, Data Modeler will be responsible for shaping and managing the data models and architecture, enabling the organization to store, analyze, and leverage large-scale healthcare data efficiently. This includes developing and implementing reliable, scalable, and effective data models for various data warehouse solutions using cutting-edge tools such as Fivetran, DBT, Snowflake, AWS, Atlan, Erwin ER Diagrams, and Sigma Computing. This role will collaborate with a diverse set of stakeholders to develop a comprehensive data architecture that supports decision-making, reporting, analytics, and data governance. This role requires significant experience with dimensional models, RDBMS, cloud platforms, and ETL processes. This role will be responsible for defining and designing data models that support data governance, data quality, and master data management (MDM), while also working with stakeholders to implement data-driven solutions that enhance business outcomes in the healthcare sector. A strong focus will be placed on creating a trusted data environment by ensuring accurate data mapping, implementing Golden Record practices.Summary
We are seeking a Senior Data Modeler to join our Data Analytics team to design and implement a Common Healthcare Data Model conforming to our Lakehouse medallion architecture. The ideal candidate must have a deep understanding of US healthcare data standards and prior experience with Electronic Health Record (EHR) systems.
Key Responsibilities
- Design, develop, and maintain an analytical common data model that integrates data ingested from Electronic Health Records (EHR) systems and various other transactional and healthcare data sources
- Work closely with data engineers and business stakeholders to understand data requirements and translate them into logical and physical data models for the common data model.
- Ensure the data model is scalable, efficient, and well-documented.
- Utilize data modelling tools such as Erwin or ER Studio to create and design the common data model.
- Provide technical guidance and best practices to the broader analytics teams on data modelling & optimizations for query performance.
- Collaborate with downstream consumer teams to ensure the data model meets their analytical and reporting needs.
Qualifications
- Bachelor’s or Masters degree in Computer Science, Information Systems, Data Analytics or related field
- Minimum of 8 years of professional experience in data modelling.
- Prior experience with U.S. ambulatory healthcare data, including EHR and practice management systems.
- Proven ability to design and implement a canonical common data model that can consolidate data from diverse sources.
- Proficiency with data modelling tools
- Proficiency in SQL and familiarity with data ingestion and ETL processing in cloud environments
- Understand healthcare standards including HL7, FHIR, CCDA
- Strong understanding of various data modelling techniques, including dimensional modelling ,3NF, Data Mesh, Data Fabric , data lake
- Excellent communication and collaboration skills.
- Exposure to Python is a plus
- Familiarity with data analytics tools such as PowerBI, Tableau, Sigma a plus
NextGen Healthcare is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
Top Skills
What We Do
NextGen Healthcare is on a relentless quest to improve the lives of those who practice medicine and those they care for. We provide tailored solutions to fit the precise needs of ambulatory practices, as they strive to reach the quadruple aim while navigating the journey of value-based care. The result? Healthier patients and happier providers.