Title: Data Modeler
Location: Remote, Y
Duration: 3 months with the possibility of extension
Job Description:
The Data Modeler / Architect, with expertise in the healthcare domain, is responsible for designing, implementing, and governing enterprise data models and data architecture that support data warehouses, data marts, analytics, reporting, and AI/ML initiatives.
This role defines and enforces modeling standards and best practices to ensure high data quality, scalability, reusability, and minimal data redundancy, while enabling efficient data movement across Provider, Payer, and Clinical domains in cloud-native healthcare data platforms.
Work with the team to design and implement data strategies (Data Mesh/Lakehouse), build data flows and develop conceptual, logical and physical data models. Develop strategies to simplify data movement across disparate domains (Provider, Payer, Clinical), reducing technical debt and redundant pipelines.
Create and maintain conceptual, logical, and physical data models, along with corresponding metadata, according to enterprise standards using the Erwin tool.
Dimensional Modeling Design: Design and develop efficient dimensional models (star schema, snowflake schema) for large-scale data warehouses, ensuring that data structures support analytical and reporting requirements.
Understand and translate business needs into data models to satisfy enterprise analytics & reporting and AI/ML needs with hands-on expertise multi-model data architecture expertise across relational, unstructured, and vector databases, including healthcare data such as audio transcripts, video, waveforms (ECG/EEG), and medical imaging (DICOM and non-DICOM).
Cloud-Native Data Platform Design for AI/ML, Design and architect cloud-based data platforms on AWS/Azure leveraging Snowflake Iceberg tables to store and manage structured and unstructured data, enabling scalable feature engineering, model training, and inference workloads for AI/ML initiatives.
Collaborate with data scientists and ML engineers to ensure high-quality, accessible, and well-structured data for machine learning use cases.
Lead the mapping of source data into FHIR (for exchange) and OMOP (for research/analytics), ensuring strict adherence to LOINC, SNOMED, and ICD-10 coding schemes.
Establish data architecture standards, best practices, naming conventions, and documentation.
Design, build, and maintain robust data pipelines using Snowflake-native features (such as Dynamic tables, Streams, and Tasks), while developing and optimizing SQL, stored procedures, and scripts for data ingestion, and transformation.
Strong Data Analysis, SQL Querying, Data Profiling & Healthcare Domain Knowledge: Leverage advanced data analysis techniques, SQL querying, and data profiling to identify trends, patterns, and data anomalies.
Perform reverse engineering of physical data models from databases and SQL scripts.
Implement data quality, governance, data contracts and security best practices while optimizing cost and performance. Develop architectural patterns that ensure Snowflake performance and manage Total Cost of Ownership (TCO) through credit optimization and warehouse right-sizing.
Years of Experience:
Experience: 7+ years in Data Architecture, Modeling, or Warehousing.
Snowflake Expertise: 2+ years of deep, hands-on experience with Snowflake-native features
Minimum 3+ years' experience in Healthcare Domain: In-depth knowledge of FHIR, HL7, X12, DICOM communications protocols for healthcare data exchange, and expertise with OMOP (i2b2 is a bonus) data models.
Minimum Qualification:
A Developer assists in designing, developing, and supporting applications.
These applications include systems developed solely for the web environment as well as development efforts designed to web-enable end-user applications.
This individual may also assist in the creation and ongoing management of corporate web sites and intranet communities.
The Developer will have a thorough understanding of programming techniques and tools, web development, and system management tools.
General Tasks and Responsibilities Will Include:
Develop and understand all features of each a module and their impact on other modules.
Analyze and develop understanding of how data flows through the system and apply that knowledge to the current business model.
Identify and define system errors and/or deficiencies.
Liaise with other developers (i.e: software, application, web, etc) to determine b est path solutions and manage the priorities through collaboration with internal stakeholders.
Plan and coordinate testing and implementation of system patches and upgrades leading a cross functional team of power users.
Extract key business performance metrics. • Analyze user needs and software requirements to determine areas of opportunity for increased efficiencies.
Create written user documentation, instructions, and procedures for the purpose of training new employees and improving over-all user proficiency.
Evaluate new technologies for potential implementation including development of business justification and project implementation planning, when appropriate.
Utilizing in-house or external resources, manage the network and related hardware. Ensure that help-desk tasks are promptly addressed and resolved
Educational Level:
A Baccalaureate Degree from an accredited college or university with a major in Computer Science, Systems Engineering, applied Mathematics, Business Administration, Economics/Statistics, Telecommunications, Data Communications, or a related field of study; and
Five (5) years of progressive, responsible experience in the field of data processing, computer systems, and applications.
Network Services requires a telecommunications background and experience.
Broad knowledge and expertise in the characteristics of computers, peripheral devices, communications systems and hardware capabilities, programming languages, E.D.P. applications, systems analysis methodology, data management and retrieval techniques; or
A satisfactory equivalent combination of training, education, and experience.
Years of Experience:
Five (5) years of progressive, responsible experience in the field of data processing, computer systems, and applications.
