Data Analyst – SQL & Tableau

Arccus Inc is hiring a contract Data Analyst to support business intelligence and reporting needs from a hybrid setup in the Irvine area. This role centers on SQL and Tableau, with a mandatory focus on migrating legacy Crystal Reports to Tableau while keeping calculations, business logic, and reporting accuracy intact.

Working closely with business stakeholders, you will translate reporting requirements into technical solutions, validate migrated results, and help improve dashboard performance and usability. The position is designed for an analyst who can analyze legacy report structures and recreate outputs reliably in Tableau.

Responsibilities

• Build, maintain, and enhance SQL-based reports and Tableau dashboards.
• Convert legacy Crystal Reports into Tableau dashboards while preserving functionality and business logic.
• Analyze legacy reports, including data sources, formulas, calculations, and underlying queries.
• Recreate existing reporting outputs in Tableau and identify opportunities to improve results and presentation.
• Develop and optimize complex SQL queries using joins, CTEs, subqueries, aggregations, and data transformations.
• Implement calculated fields, conditional logic, filters, and window functions to meet reporting requirements.
• Compare legacy and migrated reports to verify data consistency and accuracy.
• Troubleshoot reporting discrepancies, resolving issues related to SQL queries, calculations, and data quality.
• Collaborate with business stakeholders to understand reporting needs and translate them into technical solutions.
• Support 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.

Requirements

• 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 (mandatory).
• 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.

Location and Work Arrangement

• Location: Irvine / Orange County, California (Hybrid – Irvine area).
• Work model: Hybrid, with onsite attendance as required.
• Preference: Local candidates preferred, including those residing in Irvine and surrounding areas who can accommodate the hybrid schedule.

Compensation and Employment Details

• Job type: Contract
• Salary: $60,000.00 to $70,000.00 per year
• Experience required: 4+ years

Tech Stack

• SQL
• Tableau
• Crystal Reports
• CTEs
• Window functions
• SAP

SAP experience requirement: 4 years with SAP, including SAP integration and SAP data extraction (both listed as required).