Healthcare data analyst

Company: EXLService.com, LLC Location: New York, NY Position Title: Healthcare Data Analyst (EXL76) Job Description: Develop and implement ETL (Extract, Transform, Load) processes in Azure Databricks to ingest and integrate new data sources into the data warehouse. Monitor and validate data flows to ensure accurate and timely data availability. Leverage Azure Databricks for data processing, transformation, and analysis tasks. Develop and optimize Spark jobs using SQL within Azure Databricks environment. Responsible for handling data, including data quality, data organization, metadata and data profiling. Import the data and perform the quality control steps to determine raw data quality. Create new Big Data and Azure Databricks datasets from raw data files using Import Techniques and modify existing datasets using Set, Merge, Sort, Update, and other conditional statements. Develop logics to map the client data with the Data Warehouse. Develop and change implementation logic for new and existing clients based on the Change Requests received from the client. Extensively perform Data Cleansing during the ETL Extraction and Loading Phase by analyzing the raw data and writing SQL, Pyspark. Program and create complex reusable Macros. Collaborate with team members on the analysis, development, and delivery of support and project tasks for assigned group(s). Contribute technical expertise in Azure Databricks and follow best practices to ensure efficient implementation. Communicate with clients to address questions and provide clarifications as needed. Support task planning and progress tracking and assist in coordinating daily workloads. Actively participate in team activities to help drive project success. Constantly look for ways to improve processes and implement new initiatives and make sure all staff understand them. Give prompt and accurate information on individual staff member performance. Position may work at various and unanticipated worksites throughout the United States. Telecommuting permitted. Job Requirements: Requires Masters degree in Business Administration, Computer Applications, Computer Science, or a related field plus Five (5) years of experience in Healthcare data analytics. Experience must include: Five (5) years of experience with ETL and integration, Data Warehousing; Four(4) years of experience with US Healthcare data and claims processes; Three (3) years of experience with Membership, Medical, Pharmacy, and Laboratory domains, Care Optimization, Payment Integrity and PBM (Pharmacy Benefit Management) operations, Cloud, BigData, Azure Databricks, Delta Lake, Azure Data Factory and Azure Synapse, Data processing using Apache Spark (SQL, PySpark), SAS(BASE, SQL, Macros) and Python. Employer will also accept a Bachelors degree plus Eight (8) years of experience in Healthcare data analytics in lieu of a Masters degree plus Five (5) years of experience in Healthcare data analytics. 40 hours/week, 9:00am-5:00pm, Salary range: $168,000 to $170,000 per year. To apply: Send resume and cover letter to us.careers@exlservice.com. Must cite job title and code EXL76 in response. This notice is subject to ExlService.com, LLC's employee referral program.