Healthcare Data Analyst

Consulting-Professional Services Consulting

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.

Responsibilities

• 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.

Qualifications

Requires Master's 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 Bachelor's degree plus Eight (8) years of experience in Healthcare data analytics in lieu of a Master's 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 View email address on click.appcast.io. Must cite job title and code EXL76 in response. This notice is subject to ExlService.com, LLC's employee referral program. EEO/Minorities/Females/Vets/Disabilities.

Required Skills

• Accounting Fundamentals
• Adapting To Change
• Attention To Consistency
• Automation Management
• Big Data Analysis
• Interpersonal Dynamics with Coworkers
• Process Digitalization
• Results Orientation
• Time Management Skills
• Working under Pressure
• Writing Communication Skills