Technology

Data Analyst

Kaygen IncWest Hollywood, CA🇺🇸United StatesPosted Oct 15, 2026

Quick Overview

Seniority

Mid Senior

Work mode

Hybrid

Location

West Hollywood, CA, United States

Posted

Yesterday

SQLTableauMicrosoft Office

Job Description

Job Title: Data Analyst
Location: Los Angeles, CA (Hybrid)
Duration: 6 Months
Job Description:

We are seeking a mid-level Data Analyst / BI Analyst with strong hands-on experience in SQL reporting and Tableau to support reporting and business intelligence initiatives.
The primary focus of this role will be developing, maintaining, and enhancing SQL-based reports and migrating existing reports from Crystal Reports to Tableau. The ideal candidate should be comfortable working with complex SQL queries, including complex joins, subqueries, aggregations, and data transformations, and translating existing reporting requirements into effective Tableau dashboards and visualizations.
Healthcare or hospital experience is not required. The successful candidate will primarily need strong technical reporting and data visualization capabilities.
Key Responsibilities
Develop, maintain, and enhance reports using SQL and Tableau.
Support the migration of existing Crystal Reports to Tableau.
Analyze existing Crystal Reports to understand business logic, calculations, data sources, and SQL queries.
Recreate and improve existing reports and reporting functionality in Tableau.
Write and optimize complex SQL queries involving:
- Multiple-table joins
- Complex joins
- Subqueries
- CTEs
- Aggregations
- Calculated fields
- Data transformations
- Filtering and business logic
Validate data between legacy Crystal Reports and newly developed Tableau reports.
Troubleshoot discrepancies in reporting results and identify underlying data or query issues.
Work with business stakeholders to understand reporting requirements and translate them into SQL queries, reports, and Tableau dashboards.
Assist with ad-hoc reporting and data analysis requests.
Develop and maintain SQL-based reporting solutions to support ongoing business needs.
Help improve existing reports for usability, accuracy, performance, and consistency.
Document reporting logic, SQL queries, data sources, and report specifications as needed.
Collaborate with team members to support ongoing reporting and business intelligence initiatives.

Preferred / Nice-to-Have Qualifications
Experience migrating Crystal Reports to Tableau. Hands-on experience with Crystal Reports. Experience with Microsoft Office 365. Experience with Microsoft Forms and Forms-based booking/workflows. Experience with Power Automate. Experience with SharePoint. Experience working with healthcare or hospital reporting environments is a plus, but not required. Familiarity with healthcare data or credentialing systems is a plus, but not required.Required Qualifications
3–6 years of experience in Data Analytics, Business Intelligence, Reporting, or a related field. Strong hands-on experience with SQL and SQL-based reporting. Strong experience developing reports and dashboards using Tableau. Experience writing complex SQL queries, including complex joins across multiple tables. Experience with SQL concepts such as:

Inner/Outer Joins
CTEs
Subqueries
Aggregations
CASE statements
Window functions
Data filtering and transformation

Experience analyzing and translating existing reporting requirements into Tableau. Experience troubleshooting and validating reporting data. Ability to work independently on reporting requirements and communicate effectively with stakeholders.