Hybrid SQL & Tableau: Crystal Reports Migration Pro

Arccus Inc.; Irvine (CA); Hybrid; USD 60,000 - 70,000; Full time

Benefits offered by this job

Hybrid work schedule

Onsite attendance as required

Job summary

Arccus Inc. is seeking a contract Data Analyst in the Irvine area to migrate legacy Crystal Reports to Tableau while preserving calculations and business logic. The role focuses on SQL-based reporting and Tableau dashboards with BI enhancements.

You will translate requirements, validate migrated outputs, and collaborate with stakeholders to improve performance and usability. Hybrid work with onsite attendance is required.

Qualifications

• 4+ years of experience in data analytics, BI, or reporting.
• Strong SQL reporting and analytics experience.
• Hands-on Tableau reporting and interactive dashboards experience.
• Experience migrating Crystal Reports to Tableau (mandatory).
• Advanced SQL knowledge: joins, subqueries, CTES, aggregations, and data transformations.
• Knowledge of inner/outer joins, CASE statements, and window functions.
• Ability to analyze legacy report logic and reproduce results in Tableau.
• Experience with data validation, reconciliation, and troubleshooting.
• Strong analytical thinking and good communication with business teams.

Responsibilities

• Build, maintain, and enhance SQL-based reports and Tableau dashboards.
• Convert legacy Crystal Reports into Tableau dashboards preserving functionality and business logic.
• Analyze legacy reports: data sources, formulas, calculations, and queries.
• Recreate outputs in Tableau and improve results and presentation.
• Develop and optimize complex SQL queries with joins, CTEs, subqueries, aggregations, and data transformations.
• Implement calculated fields, conditional logic, filters, and window functions.
• Verify data consistency by comparing legacy and migrated reports.
• Troubleshoot discrepancies in SQL, calculations, and data quality.
• Collaborate with stakeholders to translate needs into solutions.
• Support ad hoc data analysis and reporting requests.
• Optimize dashboard performance and usability.
• Document reporting logic, SQL queries, data sources, and specs.
• Contribute to BI development initiatives.

Skills

SQL queries

Tableau dashboards

Crystal Reports migration

Data analysis

Data validation

Problem solving

Communication

Tools

Tableau

Crystal Reports

SAP

SQL

CTEs

Job description

Arccus Inc. is seeking a contract Data Analyst in the Irvine area to migrate legacy Crystal Reports to Tableau while preserving calculations and business logic. The role focuses on SQL-based reporting and Tableau dashboards with BI enhancements.

You will translate requirements, validate migrated outputs, and collaborate with stakeholders to improve performance and usability. Hybrid work with onsite attendance is required.