Kaygen Inc
Kaygen Inc

Data Analyst

West Hollywood, CA, US • Posted 1 day ago • Updated 6 hours ago
Contract W2
12 Months
On-site
$40 - $50/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • DATA ANALYST
  • BI ANALYST
  • SQL QUERIES
  • COMPLEX JOINS
  • SUBQUERIES
  • AGGREGATIONS
  • DATA VISUALIZATION
  • CRYSTAL REPORTS
  • TABLEAU

Summary

We are looking for Data Analyst at West Hollywood, CA (Hybrid) . Please share your resume with rate and availability . 

Job Title: Data Analyst
Location:  West Hollywood, CA (Hybrid)
Duration: 6+ Month

MUST be local to Los Angeles, CA

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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10299352
  • Position Id: 26-04977
  • Posted 1 day ago
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.
More jobs at Kaygen Inc in West Hollywood, CA