Data Integrations Architect
Phoenix, AZ Headquarters, United States
Team Select Home Care
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), HRIS systems, CMS, and other healthcare data repositories. This role expertise will be crucial in ensuring data quality, security, and availability for analytics and reporting. In this role, you will report to the Manager of Analytics and Engineering.
Supervisory Responsibilities:
None
Duties/Responsibilities:
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
Leverage experience in integrating 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
Other responsibilities as assigned
Required Skills/Abilities/Knowledge:
Proficiency in advanced SQL and database design
Experience with cloud platforms like Snowflake
Extensive experience with ETL processes, data warehousing, and EMR data
Deep knowledge of healthcare data standards, regulations, and best practices
Previous experience in building and maintaining data warehouses
Strong problem-solving skills, attention to detail, and effective communications
Ability to work collaboratively in a cross-functional team environment
Knowledge of SQL Server administration and maintenance
Education/Experience/Licenses/Certifications:
Bachelor’s degree in Computer Science, Information Technology, or a related field
7-8 years of experience as a Data Integrations Architect, with a focus on healthcare data
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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Computer Science Data governance Data quality Data warehouse Data Warehousing ELT Engineering ETL Security Snowflake SQL
Perks/benefits: Health care Insurance
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.