Data Analyst - SQL & Tableau Confidential Irvine, CA Job Details Contract From $65,000 a year 1 day ago Qualifications Performance dashboard reports Data integrity assurance Dashboard development Crystal Reports Teamwork Data visualization software proficiency Data analysis reporting Data migration Data validation techniques Collaboration Business intelligence report generation Dashboard creation support SQL Query management Data transformation Data analytics technologies Cross-functional communication Full Job Description Job Overview We are seeking an experienced Data Analyst / BI Analyst with strong expertise in SQL, Tableau, and complex reporting solutions. The ideal candidate will have hands-on experience migrating legacy reports from Crystal Reports to Tableau, ensuring that existing business logic, calculations, and reporting requirements are accurately maintained. This role requires strong SQL query development skills, experience building Tableau dashboards, and the ability to analyze legacy reporting systems and deliver reliable, user-friendly business intelligence solutions. Candidates must have prior Crystal Reports-to-Tableau migration experience. Local candidates who can support the hybrid work arrangement are preferred. Key Responsibilities Develop, enhance, and maintain SQL-based reports and Tableau dashboards. Migrate existing Crystal Reports to Tableau while preserving business logic and reporting functionality. Review legacy reports to understand data sources, calculations, queries, and business rules. Recreate and improve existing reports and visualizations using Tableau. Write and optimize complex SQL queries involving multiple-table joins, subqueries, CTEs, aggregations, and data transformations. Apply calculated fields, filtering conditions, CASE statements, and window functions to meet reporting requirements. Validate and reconcile data between existing Crystal Reports and newly developed Tableau reports. Investigate discrepancies and resolve issues related to data accuracy, SQL logic, and report calculations. Collaborate with business stakeholders to gather requirements and convert them into effective reporting solutions. Handle ad hoc reporting and data analysis requests. Improve report performance, usability, consistency, and accuracy. Maintain documentation for SQL queries, report logic, data sources, and reporting specifications. Support ongoing business intelligence and reporting initiatives in collaboration with the wider team. Required Qualifications 3+ years of experience in Data Analytics, Business Intelligence, Reporting, or a related field. Strong hands-on experience with SQL and SQL-based reporting solutions. Proven experience developing Tableau reports and dashboards. Practical experience migrating reports from Crystal Reports to Tableau. Advanced SQL skills, including complex joins, subqueries, CTEs, aggregations, and data transformations. Knowledge of inner and outer joins, CASE statements, window functions, filtering, and calculated fields. Ability to interpret existing reporting logic and reproduce it accurately in Tableau. Experience with report validation, data reconciliation, and troubleshooting. Strong analytical and problem-solving abilities. Effective communication skills and the ability to work independently with business stakeholders.

Work Arrangement Location:

Irvine, California.

Work Model:

Hybrid.

Candidate Preference:

Local California candidates who can meet the onsite requirements.

Pay:

From $65,000.00 per year Application Question(s): How many years of professional experience do you have with SQL, Tableau, and Crystal Reports? Have you completed a Crystal Reports-to-Tableau migration involving complex SQL queries, business calculations, and data validation? 1. Are you currently located in California and able to work onsite as required under a hybrid arrangement?

Work Location:

Hybrid remote in Irvine, CA 92604