Senior Data Analyst (SQL SME)

Medasource; Salt Lake City (UT); Remote; USD 80,000 - 110,000; Full time

Job summary

A leading healthcare consultancy is seeking a proactive Senior Data Analyst to join their technical team. This role focuses on SQL and data engineering within large-scale data environments to improve clinical outcomes. The ideal candidate will have experience with data warehousing, a solid understanding of clinical workflows, and strong soft skills, including independence and collaboration. Proficiency in tools like Databricks and Tableau is highly desired. This is a remote position with a 6-month contract.

Qualifications

• Expert-level querying and data manipulation using Microsoft SQL.
• Experience extracting and transforming data in data warehouses.
• Hands-on experience with Databricks in data operations.

Responsibilities

• Act as a bridge between data environments and clinical leadership.
• Meet with customers to translate needs into deliverables.
• Maintain strong documentation of data lineage and logic.

Skills

Advanced Microsoft SQL

Data Warehouse Navigation

Databricks

Relational Design

Tableau

Clinical/EMR Data

Claims Data

Tools

IBM Cognos

Job description

Location: Remote (United States)

Hours: MST Time Zone

Duration: 6-Month Contract

The Opportunity

We are seeking a proactive, forward-thinking Senior Data Analyst to join a core technical team within our payer client. In this role, you will act as a bridge between complex data environments and clinical leadership. You will be responsible for data design, navigating data warehouses, and translating high-level business concepts into technical deliverables that improve Care Management (CM) and Utilization Management (UM) outcomes.

Technical Skillset

1. SQL & Data Engineering (Primary Focus)

• Advanced Microsoft SQL: Expert-level querying and data manipulation.
• Data Warehouse Navigation: Proven experience extracting and transforming data within large-scale warehouses.
• Databricks: Hands‑on experience within a Databricks environment is highly preferred.

2. Data Modeling & Design

• Relational Design: Deep understanding of how tables relate, specifically within a clinical context.
• Warehouse Structures: Ability to design and maintain efficient data structures.
• Tableau: Intermediate to Advanced proficiency. (Note: This role is more heavily weighted toward SQL/Engineering than visualization).
• Cognos: Experience with IBM Cognos is a strong "nice to have."

Domain Expertise: The Payer Perspective

The ideal candidate must have a background working on the Payer side of healthcare, specifically dealing with:

• UM/CM Workflows: Understanding how Care Managers enter data and how those clinical workflows impact outcome metrics.
• Clinical/EMR Data: Familiarity with table structures and the nuances of clinical content.
• Claims Data: Experience with claims data is preferred to provide a holistic view of the member journey.

Soft Skills & Responsibilities

• Consultative Approach: You will meet directly with customers to translate their needs into task-specific deliverables.
• Proactive Communication: We need a "thinker," not just a "doer." You should be comfortable asking high‑level questions to ensure data integrity.
• Independence & Collaboration: While you will work closely with our core team of four, you must be able to drive projects independently.
• Documentation: Strong habits in documenting data lineage and logic for long-term sustainability.