Data Analyst – SQL & Tableau

Location: Orange County, CA (Hybrid – Irvine area)
Employment Type: Contract
Experience Required: 4+ Years
Preference: Local candidates preferred

Job Overview

We are looking for a skilled Data Analyst / BI Analyst with hands-on experience in SQL, Tableau, and complex reporting. The ideal candidate will have a proven background in migrating legacy reports from Crystal Reports to Tableau while maintaining existing calculations, business rules, and reporting accuracy.

The candidate should be comfortable analyzing legacy reporting structures, developing advanced SQL queries, and creating reliable Tableau dashboards that meet business requirements.

Prior experience with Crystal Reports-to-Tableau migration is mandatory. Candidates based in Irvine or nearby Orange County areas are preferred for the hybrid work arrangement.

Key Responsibilities

• Build, maintain, and enhance SQL-based reports and Tableau dashboards.
• Convert legacy Crystal Reports into Tableau dashboards while preserving existing functionality and business logic.
• Analyze legacy reports, including their data sources, formulas, calculations, and underlying queries.
• Recreate existing reporting outputs in Tableau and identify opportunities for improvement.
• Develop and optimize complex SQL queries using joins, CTEs, subqueries, aggregations, and data transformations.
• Implement calculated fields, conditional logic, filters, and window functions to support reporting needs.
• Compare legacy and migrated reports to verify data consistency and accuracy.
• Troubleshoot reporting discrepancies and resolve issues related to SQL queries, calculations, and data quality.
• Work with business stakeholders to understand reporting needs and translate them into technical solutions.
• Fulfill ad hoc data analysis and reporting requests.
• Optimize dashboard performance, presentation, and usability.
• Document reporting logic, SQL queries, data sources, and technical specifications.
• Contribute to ongoing BI development and reporting improvement initiatives.

Required Qualifications

• At least 4 years of experience in data analytics, business intelligence, reporting, or a related field.
• Strong practical experience writing SQL queries for reporting and analytics.
• Hands-on experience creating Tableau reports and interactive dashboards.
• Demonstrated experience migrating Crystal Reports to Tableau.
• Advanced SQL knowledge, including complex joins, subqueries, CTEs, aggregations, and data transformations.
• Understanding of inner and outer joins, CASE statements, window functions, filtering, and calculated fields.
• Ability to analyze legacy report logic and reproduce the same results accurately in Tableau.
• Experience with report testing, data validation, reconciliation, and troubleshooting.
• Strong analytical thinking and problem-solving skills.
• Good communication skills and the ability to work independently with business teams.

Work Arrangement

• Location: Irvine / Orange County, California.
• Work Model: Hybrid, with onsite attendance as required.
• Candidate Preference: Applicants residing in Irvine and surrounding areas who can accommodate the hybrid schedule.

Pay: $60,000.00 - $70,000.00 per year

Experience:

• SAP: 4 years (Required)
• SAP integration / SAP data extraction: 4 years (Required)

Work Location: Hybrid remote in Irvine, CA