Data Modeler - Healthcare

Acetech Group Corporation; United States; Remote; USD 150,000 - 190,000; Full time

Job summary

Acetech Group Corporation seeks a seasoned Data Architect for a twelve-month contract, 100% remote in the United States. You will design and govern enterprise-scale healthcare data models, including OLTP, OLAP, dimensional modeling, MDM, star schemas, and data movement strategies supporting Medicaid, Medicare, and commercial analytics.

The role requires deep healthcare domain expertise, HIPAA/PHI/PII compliance, and hands-on experience with large data warehouses and ETL pipelines using SQL,

Qualifications

• BS or MS in Computer Science/Business Information Systems/Engineering or related field.
• 10+ years IT experience with healthcare data environments.

Skills

Data Architecture

Data Modeling

Healthcare data

HIPAA/PHI/PII

SQL

Data Quality

Data Governance

ETL

Informatica

Azure Data Factory

BI tools

Python or R

AI/GenAI in data modeling

Dimensional modeling

OLTP/OLAP

Education

BS or MS in Computer Science/Business Information Systems/Engineering or related field

10 or more years of IT experience

Tools

Informatica

Azure Data Factory

SQL tooling

BI tooling

Job description

Twelve-Month Contract - Extensions Following, Multi-Year Project

100% Remote

1. Data Architecture & Modeling – Someone who can design and govern enterprise-scale healthcare data models, including OLTP, OLAP, dimensional modeling, MDM, star schemas, and data movement strategies supporting Medicaid, Medicare, and commercial healthcare analytics.

2. Healthcare Domain Expertise – Deep understanding of healthcare data ecosystems, including Medicaid, Medicare, claims, provider, member, and TPL datasets, with knowledge of HIPAA, PHI, PII, data governance, and regulatory compliance requirements.

3. Enterprise Data Warehousing & ETL – Strong hands-on experience building and optimizing large-scale data warehouse solutions using SQL, ETL tools (Informatica, Azure Data Factory), data quality frameworks, metadata management, and analytics/reporting platforms.

Qualifications

Education/Qualifications

• BS or MS in Computer Science/Business Information Systems/Engineering or related field
• 10 or more years of IT experience

Required skills

• Strong problem solving, influencing, communication, and presentation skills, self-starter.
• Expertise in Data Architecture, Data Strategy and Roadmap for large and complex health entity and systems and implemented large scale end-to-end Data Management & Analytics solutions for more than one large client.
• Strong knowledge of regulatory security requirements regarding HIPPA, PHI, PII, and other health care data security standards.
• Strong Healthcare domain knowledge of Medicaid, Medicare, and Commercial healthcare data sets.
• Expertise with normalized OLTP, OLAP, MDM and Dimensional modeling techniques, Star schemas, slowly changing dimensions, role-playing dimensions, dimensional hierarchies, and data classification.
• Expert level SQL skills with direct experience writing complex analytic queries, stored procedures, DDL, DML and DCL. Thorough knowledge of query optimization techniques with the ability to write code to ANSI standards and inspect code written by other developers.
• Expertise in Data Quality, Data Profiling, Data Governance, Data Security, Metadata Management, MDM, Data Archival and Data Migration strategies using appropriate tools.
• Hands-on experience with ETL tools (e.g., Informatica, Azure Data Factory)
• Hands-on experience with BI tools and reporting software.
• Demonstrated ability to work in a fast paced and changing environment with short deadlines, interruptions, and multiple tasks/projects occurring simultaneously.
• Must be able to work independently and have skills in planning, strategy, estimation, and scheduling.
• Experience with scripting language used for analytics such as Python or R
• Experience applying AI/GenAI capabilities to data modeling, metadata management, data profiling, data quality analysis, documentation automation, and analytics enablement, with the ability to evaluate appropriate use cases while maintaining privacy, security, and regulatory compliance.