[Remote] Fulltime opening -- Sr. Data Analyst – (Azure Databricks)

Note: The job is a remote job and is open to candidates in USA. E-Solutions is seeking an experienced Senior Data Analyst to analyze and govern complex healthcare claims and related datasets. The role will create source-to-target mappings, develop SQL-based analyses, support Azure Databricks data pipelines, engage business and technical stakeholders, and ensure data quality for forecasting, reporting, and AI/ML use cases.

Responsibilities

• Perform initial data analysis and profiling of complex healthcare datasets (claims, providers, members, finance)
• Create and maintain Source-to-Target Mapping (STM) documents, ensuring traceability and accuracy across systems
• Define and standardize data definitions, business glossary, transformations, and business rules
• Identify data anomalies, trends, and inconsistencies and work towards resolution
• Collaborate closely with business stakeholders to understand requirements and translate them into analytical solutions
• Define and manage data intake processes, onboarding new datasets efficiently
• Act as a bridge between business, SME, data engineering and data science teams for requirement clarification and validation
• Write and validate complex, optimized SQL queries for data extraction, transformation, and validation
• Work with large datasets using Azure Databricks (Spark, SQL, Python/Scala)
• Support and validate data pipeline outputs developed in Databricks
• Experience working with Snowflake and cloud-based data warehouses is a plus
• Work with engineering teams to ensure scalable and secure data solutions
• Analyze and handle healthcare claims data, ensuring compliance with domain-specific business rules
• Work with datasets across Claims, Provider, Member, Vision, Dental, and Finance domains
• Ensure correct interpretation of healthcare data structures and coding standards
• Ensure high standards of data quality, consistency, and governance
• Develop and enforce validation frameworks and reconciliation processes
• Document data lineage, definitions, and transformation logic

Skills

• A) Strong experience in SQL (advanced querying, optimization)
• B) Hands-on experience with Azure Databricks (Spark, Delta Lake)
• C) Experience with cloud data platforms (Azure, Snowflake, BigQuery is a plus)
• D) Knowledge of data modeling, ETL/ELT concepts, and data warehousing
• A) Strong experience in healthcare data, especially claims data processing
• B) Understanding of provider, member, financial datasets
• C) Familiarity with healthcare data standards and business rules
• A) Expertise in data profiling, root cause analysis, and validation
• B) Experience creating Source-to-Target Mapping documents
• C) Ability to work with ambiguous requirements and drive clarity
• D) Strong problem-solving and troubleshooting skills
• A) Excellent communication and stakeholder management
• B) Ability to work cross-functionally with business and technical teams
• C) Strong ownership and accountability mindset
• • Overall 8+ years of experience
• • Minimum of 3 years of experience in Azure (ADF), Databricks
• • 5 years of experience in writing advanced level SQL

Benefits

• Remote work

Company Overview

Company H1B Sponsorship