ArchWell Health is a new, innovative healthcare provider devoted to improving the lives of our senior members. The role involves building data integrations, monitoring data operations, and ensuring data quality within a Data Warehouse environment.
Responsibilities:
- Build data integrations from internal and external sources to centralize data into a Data Warehouse environment
- Monitor data integration operations, data quality, troubleshoot, and resolve problems
- Profile data sources and map to target table formats
- Develop and monitor data quality processes and address problems
- Develop, unit test and system test integration components
- Create support documentation describing the functionality of the integrations
- Participating in technical design & requirements gathering meetings
- Participate in planning and implementing data integration and data migration activities
- Perform QA tests to ensure data integrity and quality
- Research data issues between source systems and the data warehouse
Requirements:
- Bachelor's degree required; Master's degree (in data science, computer science or MIS, mathematics, engineering, or related field) preferred
- 5+ years of prior experience in Data Management / ETL / ELT / Data Warehousing
- Experience in writing Data Quality routines for cleansing of data and capturing confidence score
- Experience with master data management
- Strong knowledge of Structured Query Language (SQL) and Transact-SQL (T-SQL)
- Experience using scripting languages such as JavaScript or Python
- Experience Healthcare data models, datasets, and source systems (e.g. EHR, claims, labs, etc.)
- Experience with healthcare reference data (ICD, CPT etc.)
- Experience with agile delivery methodologies
- Strong organizational, administrative, and analytical skills required
- Experience managing and working in cloud environments such as Amazon Web Services or Azure
- Knowledge of HIPAA; ability to implement systems and processes in accordance with regulations
- Excellent interpersonal communication skills, both written and verbal
- Data Modeling experience preferred