Data Analyst 3 - SQL, ETL, Excel, Python

Zeektek; Bakersfield (CA); Remote; USD 80,000 - 110,000; Full time

Job summary

A leading healthcare analytics company is seeking a Data Analyst who will work remotely. You will focus on data collection, analytics, and reporting while driving insights for operational improvements. Ideal candidates have strong SQL skills and a relevant educational background.

Qualifications

• 3-5 years of experience in data analysis or business intelligence.
• Strong SQL skills required.
• Experience in healthcare analytics preferred.

Responsibilities

• Extracting and transforming data from various systems.
• Building dashboards and reports for leadership.
• Collaborating with IT for data pipeline optimization.

Skills

SQL

ETL

Data Management

Communication

Education

Bachelor in math, statistics, information systems, computer science, or related field

Master in math, statistics, information systems, computer science, or related field

Tools

Power BI

Excel

Python

Job description

We have a contract to hire opportunity for a data analyst experienced in SQL, ETL (from multiple data sources), data management, and C-Suite communication(s). 100% Remote.

Responsibilities :

Data Collection and preparation Extracting data from claims, enrollment, encounter, and payment systems Cleaning and transforming raw data to ensure accuracy and usability Integrating data from multiple source

Claims and Encounter Analytics Monitoring encounter data for patterns in operational inefficiencies and risk adjustment value Analyzing encounter data to ensure compliance with state and federal guidelines Measuring provider performance based on metrics like utilization, timeliness, reject rate, and quality of care Reporting and Visualization Building dashboards and reports for leadership and stakeholders using Power BI (e.g. Claims trends, patient outcomes, operational efficiency) Presenting actionable insights to drive strategy or policy division Ensuring reports align with regulatory requirements Direct Payment Compliance and Liability Assessments Provide reconciliation reporting to stakeholders and payment recipients Prepare data submissions for regulatory agencies (DHCS) Ensure encounter and claims data meet reporting deadlines and quality thresholds Staying updated on policy changes and understanding their impact on programs Cross-Functional Collaboration Working with IT to optimize data pipelines and systems Partnering with Provider Engagement teams to evaluate the effectiveness of reporting Identifying Opportunities for Improvement Analyzing member and provider data to identify gaps in care or submission quality Recommending operational improvements based on data-driven insights Testing and validating new analytics tools or methods Ad Hoc Analysis Answering data requests from stakeholders within organization Investigating anomalies in encounter submissions and escalating or resolving discrepancies Staying Up-to-Date Keeping current with industry trends, new tools, and best practices in healthcare analytics Learning about legislative changes that impact health insurance analytics

What previous job titles or background work will in this role?

Data Analyst, Business Systems Analyst, Business Intelligence Analyst, Healthcare Analyst

Any future projected positions potentially coming up?NO If yes, note : Internal / External Groups with which the Candidate will interface : Required Skills / Experience : Preferred Skills / Experience : 1. Strong SQL Skills 1. SAS ENTERPRISE GUIDE 2. Extract, Transform, Load data from multiple data sources 2. TERADATA, ORACLE, SNOWFLAKE SQL 3. Data Management 3. PYTHON (DATA WRANGLING & MANAGEMENT) 4. COLLABORATIVE, INTERPERSONAL, ORAL, AND WRITTEN COMMUNICATION 4. ABILITY TO CREATE TECHNICAL AND BUSINESS PROCESS WORKFLOW DIAGRAMS 5. ABILITY TO WORK WELL WITH MULTIPLE INTERNAL AND EXTERNAL PARTNERS, AS WELL AS WORK INDEPENDENTLY 5. Education Requirement : Bachelor in math, statistics, information systems, computer science, or related field. Education Preferred : Master in math, statistics, information systems, computer science, or related field. Software Skills Required : SQL, Excel, Python Required Certifications : None Required Testing : SQL No fields configuredPlease contact your admin to configure this card

Create a job alert for this search