Must have Qualifications:
- Qualified Candidates MUST HAVE experience with either Rx PHARMACY DATA OR MEDICAL/HEALTHCARE CLAIMS DATA.
- 5+ years of hands-on in cloud technologies (AWS) including cloud databases and ETL tools
- 8+ years of experience working with SQL Server and SSIS
- Experience doing data migration/transformation from on premise to cloud (using SSIS and AWS services
- Strong ETL preferably knowing SSIS/MS SQL model building with a solid SQL base.
- Advanced working SQL knowledge - query authoring (SQL) and familiarity with data quality improvement tasks.
- Experience with PySpark and Python
- Experience with AWS services (Glue, S3, Lambda, API Gateway.)
- Experience with working with Protected Health Information (PHI)
Other Qualifications:
- Ability to use data profiling tools such as AWS DataBrew and identify accuracy and completeness of data.
- Familiarity with working in AWS environment and running SQL queries using services such as Athena.
- Ability to identify and pinpoint data quality issues and capture the output in a report with stats.
- Ability to quickly understand data and look at the data pipeline to identify where in the process data quality issues are occurring.