Job Description
KAYGEN is an emerging leader in providing top talent for technology-based staffing services. We specialize in providing high-volume contingent staffing, direct hire staffing and project-based solutions to companies worldwide ranging from startups to Fortune 500 and Managed Service Providers (MSP) across a wide variety of industries.
Job Title: Data Analyst
Location: Los Angeles, CA (Hybrid)
Duration: 6 Months
Job Description:
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:
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
At KAYGEN, people are at the heart of everything we do. We foster a diverse, inclusive, and employee-driven culture where every individual is valued, empowered, and encouraged to bring their authentic self to work. Our candidate-first approach means we are committed to understanding your career goals and connecting you with opportunities that align with your aspirations, skills, and potential. Whether you're taking the next step in your career or searching for your dream opportunity, KAYGEN is more than a staffing partner—we're a community dedicated to helping you grow, succeed, and thrive. Join us and discover a place where your talent is recognized, your ambitions are supported, and your future is built alongside a team that invests in your success every step of the way.
Our team of experienced staffing experts will work with you to find you the best opportunity. For more information, please visit us at www.kaygen.com.
Benefits:
- Free Healthcare Insurance
- 401(k) Retirement Plan
- Free Life Insurance
- Sick Time Off
- Mentorship Program
- Certifications
- Referrals
- Family and Wellness benefits
- Continuous Growth and Career Development
Numbers & Facts
| Location | West Hollywood, CA |
| Industry | Computer/IT Services |
| Salary | $45–$55 Per Hour |
| Company Size | 100 to 499 employees |
| Year Founded | 2003 |
| Website | http://www.kaygen.com |
Benefits
Paid Sick Days, Professional Development, 401K, Employee Referral Program, Flexible Spending Accounts, Employee Events, Life Insurance, Merchandise Discounts
About Company
Kaygen, an award-winning technology consulting and talent firm, assists organizations to achieve digital transformation. From structuring data to the Cloud and visualization, Kaygen leads the digital transformation of global clients.
Kaygen, from the Japanese word, kaizen, for continuous improvement, signifies how we continuously seek to bring expert tech talent to our client engagements to create a sustainable competitive advantage. However, there is more. Our company is diverse, and minority woman owned and operated by expert data technologists who have conceived and developed the very strategic technology initiatives that we now engage in for our clients with our talent.
Our core belief in diversity, complemented by the principles of kaizen, ensures we bring the best expert data talent to work transparently, collaboratively, and with the flexibility to ensure client success.
Visit http://www.kaygen.com/ for a solutions overview.
.
Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder