Data Analyst – Healthcare (Azure Databricks)

It's fun to work in a company where people truly BELIEVE in what they are doing!

We're committed to bringing passion and customer focus to the business.

Data Analyst – Healthcare (Azure Databricks)

Fractal is a strategic AI partner to Fortune 500 companies with a vision to power every human decision in the enterprise. Fractal is building a world where individual choices, freedom, and diversity are the greatest assets; an ecosystem where human imagination is at the heart of every decision. Where no possibility is written off, only challenged to get better. We believe that a true Fractalite is the one who empowers imagination with intelligence. Fractal has been featured as a Great Place to Work by The Economic Times in partnership with the Great Place to Work® Institute and recognized as a ‘Cool Vendor’ and a ‘Vendor to Watch’ by Gartner.

Please visit Fractal | Intelligence for Imagination for more information about Fractal.

Role Overview:

We are seeking an experienced Senior Data Analyst to drive data analysis, source-to-target mapping, and business-driven data insights across complex healthcare datasets, with a strong focus on claims data. This role will partner closely with business stakeholders, data engineering teams, and analytics initiatives to ensure high-quality, well-governed, and analysis-ready data to support forecasting, reporting, and AI/ML use cases.

The ideal candidate will combine strong SQL and data analysis expertise, deep healthcare domain knowledge (claims, provider, member data), and hands-on experience with Azure Databricks and modern data platforms.

Key Responsibilities:

Data Analysis & Mapping 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. Business Engagement & Intake 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. SQL & Data Processing 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.

Healthcare Data Expertise 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. Data Quality & Governance Ensure high standards of data quality, consistency, and governance. Develop and enforce validation frameworks and reconciliation processes. Document data lineage, definitions, and transformation logic.

Required Skills:

Technical Skills Strong experience in SQL (advanced querying, optimization) Hands-on experience with Azure Databricks (Spark, Delta Lake) Experience with cloud data platforms (Azure, Snowflake, BigQuery is a plus) Knowledge of data modeling, ETL/ELT concepts, and data warehousing Domain Expertise Strong experience in healthcare data, especially claims data processing Understanding of provider, member, financial datasets Familiarity with healthcare data standards and business rules Analytical & Functional Skills Expertise in data profiling, root cause analysis, and validation Experience creating Source-to-Target Mapping documents Ability to work with ambiguous requirements and drive clarity Strong problem-solving and troubleshooting skills Soft Skills Excellent communication and stakeholder management Ability to work cross-functionally with business and technical teams Strong ownership and accountability mindset

Required Qualification:

• B.Tech/MCA (Minimum 16 years of formal education)
• Overall 8+ years of experience.
• Minimum of 3 years of experience in Azure (ADF), Databricks
• 5 years of experience in writing advanced level SQL.

Key Outcomes / Success Metrics

• Improved data quality, consistency, and governance
• Faster onboarding of new dataset