Optima Medical logo
Optima MedicalPosted 3 weeks ago

Data Operations Specialist

On-siteScottsdale, Arizona, United States

Full TimeMedium

Job Summary

Collaborate cross-functionally with clinical, IT, and business teams to gather requirements, identify data anomalies, and resolve requests supporting clinical data initiatives. Develop, optimize, and maintain SQL-based reports and Power BI dashboards for scheduled and ad hoc clinical operations reporting. Write and tune complex SQL queries to extract, manipulate, and analyze large healthcare datasets across a multi-schema enterprise database. Build and maintain data pipelines using Azure Data Factory and Azure Functions to ingest, transform, and deliver data from clinical and vendor systems. Develop and support internal data applications, APIs, and automation in Python, deployed via Docker containers with CI/CD pipelines. Manage code changes through Git and Azure DevOps version control, including branching, pull requests, and automated build/deploy pipelines. Work with enterprise subject matter experts and IT services to manage resolution of clinical application incidents and requests.

Required Qualifications

  • Strong SQL programming skills — able to write, optimize, and troubleshoot complex queries and stored procedures against large enterprise databases
  • Experience with Power BI or equivalent BI tools (DAX, dashboard development, scheduled refresh)
  • Healthcare data knowledge: medical claims, utilization management, demographic data, encounter processing, and coding systems (ICD-10, CPT/HCPCS, Revenue Codes)
  • Proficiency in data modeling, schema analysis, and data mining across large, multi-schema databases
  • Python proficiency for ETL and application development - including web frameworks (FastAPI/Flask) for building internal APIs and data services
  • Experience with Azure Data Factory or equivalent ETL/orchestration tools
  • Familiarity with Azure (this role's environment) or equivalent cloud platform experience (AWS, GCP) — serverless compute, object storage, cloud-hosted SQL databases, and containerized app hosting
  • Version control and CI/CD experience (Git, Azure DevOps Pipelines or equivalent)
  • Familiarity with Docker/containerized application deployment
  • Familiarity with file-based data exchange protocols (SFTP) and REST API integration

Desired Qualifications

  • Nice to haves: Experience with Large Language Models (LLMs), IBM Cognos, or other legacy BI tools

Hiring someone like this?

Get your role in front of qualified candidates on Sorce.

Get started

Apply to this job in one click with Sorce

Apply on Sorce