As a Data Integration Architect, this role will play a pivotal role in designing, constructing, and maintaining our healthcare data warehouse. This warehouse will be responsible for ingesting, storing, and organizing data from various sources, including Electronic Medical Records (EMRs), ADP, CMS, and other healthcare data repositories. This role expertise will be crucial in ensuring data quality, security, and availability for analytics and reporting. Develop and implement robust ETL/ELT processes to ingest data from diverse healthcare sources into the data warehouse. - Ensure data accuracy, consistency, and compliance with healthcare standards and regulations. Apply extensive knowledge of healthcare data, including patient records, medical codes (ICD-10, CPT), and healthcare regulations (e.g., HIPAA), to guide data integration efforts. Utilize advanced SQL skills to design and optimize complex queries, create stored procedures, and maintain SQL Server databases. - Continuously monitor and improve database performance. Design and implement the data warehouse's architecture and data models to meet healthcare analytics and reporting needs. Document data integration processes, data lineage, and data dictionaries to ensure data governance, lineage tracking, and compliance. Integrate Health Information Exchange (HIE) Admissions, Discharges, and Transfers (ADT) data to enhance the overall data integration capabilities, ensuring seamless connectivity and interoperability with external healthcare systems. Implement rigorous security measures to safeguard sensitive healthcare data and ensure compliance with healthcare regulations. Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to understand data requirements and deliver actionable insights. Continuously optimize the data warehouse's performance, including indexing, partitioning, and query optimization. Establish efficient data loading schedules and automate ETL processes to keep data up to date.
Requirements: Bachelor’s degree in Computer Science, Information Technology, or a related field or foreign equivalent and Five (5) years’ experience as a Data Integrations Architect or Software Engineer with a focus on healthcare data or any related occupation involving designing, constructing, and maintaining healthcare data warehouses. Or, alternatively, Master’s Degree in Computer Science, Information Technology, or a related field or foreign equivalent and Three (3) years’ experience as a Data Integrations Architect or Software Engineer with a focus on healthcare data or any related occupation designing, constructing, and maintaining healthcare data warehouses.
Special skills: Must have experience with the following:
• Advanced SQL and database design.
• Cloud platform Snowflake.
• Experience with ETL processes, data warehousing, and EMR data.
• Healthcare data standards, regulations, and best practices.
• Building and maintaining data warehouses
• SQL Server administration and maintenance
Benefits + Perks of Joining the Team Select Family
Medical, Dental, and Vision Insurance
Paid Time Off and Paid Sick Time
401(k)
Referral Program
Team Select Home Care reserves the right to change the above job description and qualifications without notice. Team Select Home Care will not discriminate against you on the basis of race, color, religion, national origin, sex, sexual preference, disability, political belief, veteran status, age, or any other status protected by law. Team Select Home Care is an employment-at-will employer.