Data Integrations Analyst
Job Posting for Data Integrations Analyst at HealthVerity
How you will help
You’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
You’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
- 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
- Ensure high-quality design of dimensional models and data mapping
- Sharing data content and industry knowledge to mentor team members
- Provide strategic guidance with respect to MDM best practices
- Data profiling and integration
- Explore, profile, and validate incoming healthcare data extensively, using SQL
- Map de-identified healthcare data to proprietary data structures
- Collaborate on the development of QA test plans for incoming data and data in our warehouse
- Perform troubleshooting on all ETL processes and resolve issues effectively
- Expand and reinforce company standards in terms of nomenclature, storage, design and deployment
- Provide support to all data warehouse initiatives
- Ability to write advanced SQL to standardize and enhance data assets
- Subject matter expert for medical claims, pharmacy data, and lab data
- Ability to master healthcare IT standards and healthcare data
- Proactive and take the initiative to implement improvements
- Data driven, testing and measuring when required
- 7 years of experience with EHR, medical claims, pharmacy data
- 15 years of experience in data warehousing
- 10 years of hands-on SQL
- 7 years of data modeling and/or building and modifying tables in an RDBMS environment
- 5 years of mapping source data to target tables
- Bonus: Lab data, medical device data, genomic data
- Understanding of healthcare IT standards and data structures such as ANSI 837/835, NCPDP D.0, HL7, and optionally HL7 CCR/CCD or FHIR
- Hive, Spark SQL, Python
Salary : $70,000 - $190,000
Software Integrations Analyst
HighPoint -
Philadelphia, PA
Business Analyst
NTT DATA -
Oaks, PA
Sr. Data Analyst (PL-SQL / FTE / Hybrid)
NTT DATA North America -
King of Prussia, PA
Estimate Salary for Data Integrations Analyst in Philadelphia, PA
$79,199 (Medium)
$68,774 (25th)
$94,839 (75th)
For Employer
Looking for Real-time Job Posting Salary Data?
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
Sign up to receive alerts about other jobs that are on the Data Integrations Analyst career path.
Click the checkbox next to the jobs that you are interested in.
Sign up to receive alerts about other jobs with skills like those required for the Data Integrations Analyst.
Click the checkbox next to the jobs that you are interested in.
-
SAP Asap Methodology Skill
-
Income Estimation: $151,295 - $200,741
-
Income Estimation: $151,578 - $207,146
-
-
Backup/Recovery Skill
-
Income Estimation: $79,097 - $104,589
-
Income Estimation: $81,784 - $109,204
-
This job has expired.
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles
Skills Library
Job openings at HealthVerity
HealthVerity
Philadelphia, PA
Full Time
HealthVerity
Philadelphia, PA
Full Time
HealthVerity
Philadelphia, PA
Full Time
HealthVerity
Philadelphia, PA
Full Time
Not the job you're looking for? Here are some other Data Integrations Analyst jobs in the Philadelphia, PA area that may be a better fit.
We don't have any other Data Integrations Analyst jobs in the Philadelphia, PA area right now.
NTT DATA, Oaks, PA
City of Philadelphia, Philadelphia, PA