Holmusk, a 2019 World Economic Forum Technology Pioneer, is a data science and digital therapeutics company dedicated to establishing objective evidence as a core utility to the treatment of mental health and chronic diseases. Our proprietary technology leverages analytic and digital tools to prevent, manage and reverse treatable diseases. We leverage data and advanced analytics to accelerate research and improve outcomes in mental health and chronic diseases. We focus on harnessing actionable insights from data for pharma, providers, and payers. We develop predictive models based on real-world data and deploy them for patients and clinicians using solutions, such as mobile apps, electronic medical records, or integrated web apps. We are looking for a IICS ETL Data Engineer on our Real-World Data team. What you will do: Port complex ETL routines written in SQL to InformaticaDevelop ETL mappings and processes for deidentifying all PHI and PII information through IICS ETLs.Create ETL Framework and Auditing Data model to support all Audit and ETL Control tables etc. for ETL audit reporting purposes.Lead conversations with client data partners to onboard new systems and understanding their environment and how to propose basic setup of IICS.Work closely with DBA team, data partners, and data science team to make sure data is properly loaded in expected format etc.Oversee the automation of pre-defined QC queriesOversee the implementation of ETL automation. Identify, Define, and Implement automation of master tasklfows with proper dependencies and error handling.Perform thorough UNIT testing of the ETL code to reduce iterations between DEV to QA etc… What you will need: Minimum Bachelor’s degree in Computer Science or related field is required.Master’s in computer science is a nice to haveMinimum 5 years of Informatica Cloud work experience or equivalentExcellent hands-on experience on SQL QueriesHands on experience on converting SQL Queries to IICS ETL Jobs Informatica Cloud Architecture – How is data secured and IICS ProcessingIICS Secure Agent / Run Time Environment setup and configurationSecurity model for user’s access restrictionsOverall performance tuning and informatica best practices Preferably you will also have: Knowledge of healthcare industry and healthcare data standards (NDC, CPT, HCPCS, ICD10, HL7 etc…)Knowledge of Data Obfuscation to deidentify PHI and PII information.Knowledge of PostGRES SQLLinux ScriptingIICS Certifications At Holmusk we take pride in our diverse workforce and inclusive culture. We believe it takes all kinds of people to build the best products and bring real change to the healthcare space.