Data Integrations Analyst

How you will helpYou’ll be embarking on a hands-on role, from ingestion up to making all data available in the warehouse layer, in standardized form, and ready to use. You’ll investigate and map the data, assess data quality, and QA the transformed results. You’ll reinforce data architecture standards, and data warehouse policies and procedures, ensuring that clients receive the highest quality data. You’ll use the best tools for the job, whether modern and revolutionary or time tested and proven, to deliver elegant, scalable solutions that meet business and technical needs. Your team will support you and you the same. Peer review of solutions and implementations is expected. You will play an integral part in building the foundation of everything to come. 

What you will do

1. Provide expertise on all healthcare data types: medical claims transactions (e.g. 837 and 835), pharmacy claims (NCPDP D.0), EMR/EHR, lab transactions, and other emerging data assets
2. Ensure high-quality design of dimensional models and data mapping
3. Sharing data content and industry knowledge to mentor team members
4. Provide strategic guidance with respect to MDM best practices
5. Data profiling and integration
6. Explore, profile, and validate incoming healthcare data extensively, using SQL
7. Map de-identified healthcare data to proprietary data structures
8. Collaborate on the development of QA test plans for incoming data and data in our warehouse
9. Perform troubleshooting on all ETL processes and resolve issues effectively
10. Expand and reinforce company standards in terms of nomenclature, storage, design and deployment
11. Provide support to all data warehouse initiatives